Re: Unicode, ODBC and MS Access - Mailing list pgsql-odbc

> -----Original Message-----
> From: Hans-JEgen Schönig [mailto:hs@cybertec.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@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@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