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

Re: odbc problem on Japanese windows machine

From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>,"Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Subject: Re: odbc problem on Japanese windows machine
Date: 2007-12-16 11:53:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Thanks you very much ! you solution did it. 

-----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,
> test connection to a remote postgres database. The database has latin1

> encoding.  
> Connection tests to databases with latin1 encoding fail with this
> 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 .

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

Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2007-12-17 06:57:26
Subject: Re: weird vb6 odbc null problem
Previous:From: lshafranovichDate: 2007-12-14 17:33:01
Subject: weird vb6 odbc null problem

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