Re: odbc problem on Japanese windows machine

["Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>]

Hi, 
Thanks you very much ! you solution did it. 
Regards 
Yuval

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp] 
Sent: Friday, December 14, 2007 10:15 AM
To: Sofer, Yuval
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] odbc problem on Japanese windows machine

Sofer, Yuval wrote:
> Hi,  
> 
> I am trying to use postgres odbc driver on windows Japanese machine,
to 
> test connection to a remote postgres database. The database has latin1

> encoding.  
> 
> Connection tests to databases with latin1 encoding fail with this
error 
> message:  
> 
> fatal: conversion between SJIS and LATIN1 is not supported

Are you testing the ANSI version driver ?
If so, please set the *Connect  Settings* option like
        set client_encoding to 'XXXX'
  (XXXX e.g. SQL_ASCII, LATIN1 etc).

You can see the example (SJIS case) at
   http://www.geocities.jp/inocchichichi/psqlodbc/encoding.jpg .

However I'm not sure if you can see LATIN1 specific characters using
Japanese machine.

regards,
Hiroshi Inoue