Hello list,
I am trying to convince pgadmin 1.6.0 to display my Unicode encode databases
as WIN1250 per default
(not launching a SET CLIENT ENCODING command on each connection).
The problem is that pgadmin does not use a DNS but uses ODBC "dynamically"
setting up the connection string by explicitely.
First I looked after an environment variable but in vain there are only env variables for the
DB itself.
Then I found the registry entry
HKLM\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL\ConnSettings
even though there is no way to change it using a UI with regedit I set it to
"SET+CLIENT%5fENCODING+%3d+%27WIN1250%27%3b"
the same value as set when using the UI on a particular DNS.
I saw that the registry value is read (using regmon) but it does not seem
to be used when opening the connection
(connection strings in logfiles and db properties in pgadmin)
As anyone an idea to fix this encoding problem or should I file a bug report ?
Thank you and regards,
Claus