When I did the psql -l I see the following DBs in my local environment:
C:\PostgreSQL\bin>psql -l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
cmdb | admin | UTF8
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
I am using cmdb which is UTF8.
I think it is consistent with my application? any thoughts what might be wrong.
Thanks,
Shivender
On Tue, Apr 20, 2010 at 7:07 PM, Shivender Devarakonda
<shivenderd@gmail.com> wrote:
Thanks. Where should I look for this property?
Thanks,
Shivender
On Tue, Apr 20, 2010 at 6:18 PM, Tom Lane
<tgl@sss.pgh.pa.us> wrote:
> I did not give any explicit encoding while creating the DB. I am running
> postgres on Windows XP system.
Well, you should look at what server_encoding is set to, then.
If it's not UTF-8 then that's likely the source of the problem.
regards, tom lane