Re: Special portuguese characters are not displayed in 08.00.01.02

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Carlos Benkendorf
Sent: Monday, October 31, 2005 8:50 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Special portuguese characters are not displayed in 08.00.01.02

Hello,

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
(
  nome char(50)
)
WITH OIDS;

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?