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
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