Request a Demo
Home   >   mailing lists

Re: Authentication failed when Password contains Japaneese Charecters - Mailing list pgsql-jdbc

From Shivender Devarakonda
Subject Re: Authentication failed when Password contains Japaneese Charecters
Date
Msg-id k2ta7ddbfcf1004210918x64f9c66au4183983f5d0fb46@mail.gmail.com
Whole thread Raw
In response to Re: Authentication failed when Password contains Japaneese Charecters  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Authentication failed when Password contains Japaneese Charecters
List pgsql-jdbc
Tree view
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@sss.pgh.pa.us> wrote:
Shivender Devarakonda <shivenderd@gmail.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

pgsql-jdbc by date:

Previous
From: Nikolas Everett
Date:
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Next
From: Tom Lane
Date:
Subject: Re: Authentication failed when Password contains Japaneese Charecters