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

Adrian,

Tje letters you are typing are from Danish, but any will do.

Now im working abit from memory, but when the databse is build, initdb is
using UNICODE as encoding, "C" for locale, so it should be independant of
the locale settings.

Best Regards
Kim Mortensen

2011/1/21 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>

> On 01/21/2011 10:20 AM, Kim Mortensen wrote:
>
>> Thank you for your input,
>>
>> it may be that only ascii chars is to be used, however it should be
>> stated or a bug report filled out, as you can insert Login Roles with
>> different charakterset as you can actually use.
>>
>> Best Regards
>> Kim Mortesnen
>>
>>
>>
> I cranked up a virtual instance of Windows XP to try to figure this out.
> Turns out I need to know more about how encoding works on Windows. I had no
> problem creating the role æøå on my Linux server and logging in using psql.
> On Windows not so, I get:
>
> Username [postgres]: æøå
> Password for user µ°Õ:
> psql: FATAL: password authentication failed for user "æøå"
>
> and through ODBC:
>
> 2011-01-21 12:16:32 PSTFATAL: password authentication failed for user
> "æøå"
>
> Seems client encoding is getting in the way somehow, just not sure how.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>