Postgres Pro
Downloads
Home   >   mailing lists

Thread: Special portuguese characters are not displayed in 08.00.01.02

Special portuguese characters are not displayed in 08.00.01.02

From
Carlos Benkendorf
Date:
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?
 
Does anybody know another simple way to emulate an application using the ODBC driver?
 
Thanks!!!
 
Benkendorf
 

Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!

Re: Special portuguese characters are not displayed in 08.00.01.02

From
Hélder M. Vieira
Date:
> 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.

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


Hello from Portugal.

I'm currently using 08.00.01.01, with no visible problem concerning this
specific issue.
After reading your message, I also checked 8.01.00.05 (ANSI), again with no
visible problem.

For app development I use VB6, and for on-the-fly database manipulation I
use Access 2000.

All databases use LATIN1 encoding.



Hélder M. Vieira

Re: Special portuguese characters are not displayed in 08.00.01.02

From
"Merlin Moncure"
Date:

Using Delphi? try Zeos J

http://zeosforum.net.ms/

 

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).

 

Merlin

 

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?

 

Does anybody know another simple way to emulate an application using the ODBC driver?

 

Thanks!!!

 

Benkendorf

 

Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!