Adrian,
Actually I havent tried to view unicode chars through the login that succeeds, but that was a good test to see if its the connector that is messing things up. Unfortunately im now at home, so I dont have access to the system, so the test will have to be conducted Monday.
By the way, when looking at the create statements shown by pgadmin when I click on the Login Role, i do see a difference, but not something that would cause alarm.
the aaa role has a definition like: create role aaa ....
where the other with unicode have: create role "æøå"....
so the unicode is in brackets (cant remenmber if its single or double,), but again is just something i notised, and dont think affexts anything, but worth mentioning..
Best Regards
Kim Mortesnen
2011/1/21 Adrian Klaver
<adrian.klaver@gmail.com>On Friday 21 January 2011 8:10:24 am Kim Mortensen wrote:
> Adrian,
>
> The ODBC driver is the psqlodbc driver version 9 (latest msi installer,
> just downloaded from the homepage a couple of days ago.). This installation
> installel both an ANSI and Unicode version, and i have tried to run tests
> on both, but not gaining any positive results.
>
> Best Regards
> Kim Mortensen
>
>
Hmm, I am going to have to think about this. I will be away from a computer for
a while so I will be able to respond for a bit. In the meantime, when you login
with the 'aaa' role through ODBC can you see the correct characters for the
other role in the database?
--