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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
