Re: Character invalid saving memo with UpdateSQL - Mailing list pgsql-odbc

From Richard Combs
Subject Re: Character invalid saving memo with UpdateSQL
Date
Msg-id 3FC4E7EE.20105@covad.net
Whole thread Raw
In response to Character invalid saving memo with UpdateSQL  ("Cristian Custodio" <cristian_custodio@terra.com.br>)
List pgsql-odbc
I haven't used the BDE in a while, however it looks like a problem with character sets.  That is BDE is using one character set and PG is using another, hence the "invalid" characters.  Check the postgreSQL documentation on localization to see how to make your server recognize other language (character) sets.

One other question, does this happen only with varchar and only with that one column, or can you duplicate the problem with character type in another column?

Cristian Custodio wrote:
 
I'm using delphi 5 and PG: 7.3.4 and BDE
 
I have 1 varchar(4000) column. When I try post any value in this column
using UpdateSQL it save very invalids caracters. Like this: ííííííííí.
 
Any body could help me?
 
Thanks,
 
Cristian Luciano Custodio

pgsql-odbc by date:

Previous
From: "Philippe Lang"
Date:
Subject: Timestamp column & Access linked ODBC table
Next
From: "Greg Campbell"
Date:
Subject: Re: strange behavior