Re: Authentication failed when Password contains Japaneese Charecters

I did not get you on this. My DB cmdb is in UTF-8 already, do I still need
to change the password and test it?

I tried to use ALTER USER to change the password, for some reason the sql
command is not displaying the japaneese charecter properly and I tried using
the buffer file but the buffer file was default to ANSI format and it is not
accepting UTF-8 format..

any thoughts?

Thanks,
Shivender

On Wed, Apr 21, 2010 at 7:58 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Shivender Devarakonda <shivenderd(at)gmail(dot)com> writes:
> > I set the following property in postgresql.conf:
> > client_encoding = UTF-8 # actually, defaults to database
>
> That would not help if you were connecting to a database with SQL_ASCII
> encoding (which defeats all encoding intelligence). I'd suggest
> connecting to cmdb with psql and issuing an ALTER USER command to
> set the user's password again.
>
> regards, tom lane
>