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