He Dave,
as other wrote, there should be an encoding problem with Windows 2000.
My Environment:
Windows 2000 internal version: 5.0.2195; SP 2
Germal locale
PostgreSQL: 8.0.3
ODBC driver: 8.00.01.01 (5. March 2005)
No MDAC
Setting the encoding in the odbc driver (DNS) has no effect.
I made some tests:
Database encoding
| Client encoding
| Wrinting column (äöüß)
| Reading column
|
UNICODE
| LATIN1
| OK
| corrupted in app
|
UNICODE
| UNICODE
| corrupted in database (writing ß -> error character is a bad UNICODE)
| OK
|
Written data was verified with PgAdminIII
Best Regards,
Josef Springer
Dave Page wrote:
Hi Dave,
thanks for quick answer.
- I used Win2k with german locale
I've tested in German as well now, and it still works OK
- Used the ODBC 08.00.0101 (psqlodbc.dll)
You should definately use 08.01.0003. It fixes a major Unicode related bug.
My application works well with other databases.
Is a point of this the reason of my problems ?
What locale settings did you use for database and client ?
The database is using 'C' for everything. The clients are all default - ie. I've tried German (Germany) and English (UK).
Regards, Dave.
