I am also using postgres database with delphi. Therefor I don't use ODBC
but I use the Zeos Database components for delphi.
I had similar problems though. My database is in iso8859-7 and I needed
Greek chars to appear corectly in my application. What I did is I am
running an sql statement when my application is starting up (after my
datasource connection to the db etc) and I am setting my client's
encoding to iso8859-7. No problems since then ... Greeks show ok .. they
are stored ok and the search on the data works file.
Hope I helped a little
Alexander Antonakakis
John Sidney-Woollett wrote:
> Priem, Alexander said:
>
>>Could this be due to the fact that the database was CREATED using
>>SQL_ASCII
>>encoding? Maybe your solution only works when the database was created
>>using
>>LATIN1 or UNICODE encoding.
>
>
> Yes, I suspect
>
>
>>Maybe I'll just try recreating the database using UNICODE or LATIN1
>>encoding
>>tomorrow. UNICODE seems the best, right? Or does LATIN1 have more
>>possibilities than UNICODE?
>
>
> Unicode has a larger character set than latin-1. But if you only need to
> support latin-1 then use that... Of course, if you have to upgrade to
> support unicode later, you'll wish you had started off using latin-1!
>
> I'm no expert on this, so I hope this info is correct.
>
> John Sidney-Woollett
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
