Re: problem connecting via ODBC when unicode (now in correct forum.).

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(dot)klaver(at)gmail(dot)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?
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>