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

Re: Unicode, ODBC and MS Access

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: <marcus(at)dactylis(dot)com>, <hs(at)cybertec(dot)at>
Cc: "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Unicode, ODBC and MS Access
Date: 2003-02-24 02:48:05
Message-ID: EKEJJICOHDIEMGPNIFIJKEKCKMAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
> -----Original Message-----
> From: Hans-JEgen Schönig [mailto:hs(at)cybertec(dot)at]
>
> Good morning ...
>
> We have some minor problems with UNICODE as well.
> We are using PostgreSQL 7.3.1 with 7.02.00.05 driver.
>
>
> 2003-02-21 08:39:30 [16593]  LOG:  connection authorized: user=plank
> database=test
> 2003-02-21 08:39:30 [16593]  LOG:  query: select version()
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.003769 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: set DateStyle to 'ISO'
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.000421 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: set geqo to 'OFF'
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.000288 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: select oid from pg_type where
> typname='lo'
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.011502 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: select pg_client_encoding()
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.001134 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: BEGIN
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.000273 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: SELECT max(adr_id) FROM
> t_adresse
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.007809 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: SELECT last_value FROM
> t_adresse_adr_id_seq
> 2003-02-21 08:39:30 [16593]  LOG:  duration: 0.001503 sec
> 2003-02-21 08:39:30 [16593]  LOG:  query: INSERT INTO t_adresse
> VALUES('117',NULL,'ÓELOL.ZÁRÓV','ATÉTRotoform
> ajtókilincs','MUK',NULL,'AT','6020',NULL,NULL,NULL,NULL,NULL,NULL,NULL)
> 2003-02-21 08:39:30 [16593]  ERROR:  Invalid UNICODE character sequence
> found (0xd345)
> 2003-02-21 08:39:31 [16593]  LOG:  query: ROLLBACK
> 2003-02-21 08:39:31 [16593]  LOG:  duration: 0.000203 sec
>
>
> The server side database is set to UNICODE.
>
> [hs(at)backup hs]$ psql -l
>        List of databases
>    Name    | Owner | Encoding
> -----------+-------+-----------
>
>  template0 | hs    | SQL_ASCII
>  template1 | hs    | SQL_ASCII
>  test      | hs    | UNICODE
> (7 rows)
>
>
> Somehow the driver seems to select the client encoding but it does not
> care about it. I am using RedHat 7.3 and it's default UNIX side
> ODBC stuff.
>
> Also: I have an additional problem because "ÓELOL" is not what the
> client is supposed to send me. The "O" should be an "O" with something
> like a " on top of it (some hungarian symbol). A tool is supposed to
> write all data inside an Access database to PostgreSQL. On the Windows
> desktop the hungarian symbols are displayed properly. Where do we lose
> that information or is it a problem with my terminal settings on Linux?
> ([hs(at)backup postgresql-7.3.1]$ echo $TERM $LANG
> xterm en_US.iso885915)
>
> Does anybody have an idea?

You seem to have to set the client_encoding using the *Connect Settings*
DSN option.

regards,
Hiroshi Inoue


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2003-02-24 03:51:55
Subject: Re: Newer ODBC drivers : exellent !
Previous:From: Jeff EckermannDate: 2003-02-20 20:34:59
Subject: Re: Only fails when logging is off

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