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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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