Using Delphi? try Zeos :-)
Zeos implements TDataSet which replaces the TTable/TDatabaase layer.
go to the above link and search on 'unicode' I think this is your best shot for Unicode in the vcl. (although recent versions of the pg odbc driver have similar behavior to the old version if you don't want to switch off of odbc).
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Carlos Benkendorf
Sent: Monday, October 31, 2005 8:50 AM
Subject: [ODBC] Special portuguese characters are not displayed in 08.00.01.02
We were using ODBC driver 07.02.00.05 and now we are trying to use ODBC driver version 08.00.01.02 but portuguese special characters are not showed in the right way.
The database was created with encoding LATIN1, postgresql.conf with client_encoding = LATIN1 and we´re not using any command in the "Connect settings" field of the ODBC driver.
The following table is used for the tests:
CREATE TABLE empregado
DELPHI 7 SQL Explorer tool is used to emulate an application working with the table through ODBC. Using driver 07.02.00.05 all the data are showed right but when I changed to 08.00.01.02 the contents of column "nome" does not appear any more, only spaces.
If I use pgAdmin III and execute:
SET CLIENT_ENCODING = 'LATIN1';
SELECT * FROM EMPREGADO;
then all the characters are displayed in the right way, even those inserted by SQL Explorer tool.
It could be the DELPHI 7 SQL Explorer tool that is not working well, even so, with 07.02.00.05 the data could be displayed by the tool.
Is it a ODBC driver error or maybe there is something wrong with DELPHI 7 SQL Explorer tool?
Does anybody know another simple way to emulate an application using the ODBC driver?
Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe! <http://yahoo.fbiz.com.br>
pgsql-odbc by date
|Next:||From: Jorge Redond Flames||Date: 2005-10-31 19:43:47|
|Subject: Postgres ODBC|
|Previous:||From: Hélder M. Vieira||Date: 2005-10-31 15:25:49|
|Subject: Re: Special portuguese characters are not displayed in 08.00.01.02|