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-JEgen 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
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 |