Skip site navigation (1) Skip section navigation (2)

Re: odbc problem on Japanese windows machine

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: odbc problem on Japanese windows machine
Date: 2007-12-14 08:14:42
Message-ID: 47623B72.3030805@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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


In response to

Responses

pgsql-odbc by date

Next:From: Kenny ChengDate: 2007-12-14 09:07:05
Subject: IIS Only Opens One Database Connection At A Time
Previous:From: Hiroshi SaitoDate: 2007-12-14 06:35:52
Subject: Re: odbc problem on Japanese windows machine

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group