db-# ; server_encoding ----------------- SQL_ASCII (1 row)
whoa! yikes, I bet this has a lot to do with it? I really wanted to keep everything UNICODE end-to-end. I must have forgotten --encoding on my initdb? Anything I can do at this point?
On Mon, 15 Nov 2004, Tom Lane wrote:
Christian Fowler <[EMAIL PROTECTED]> writes:[shell]$ env PGCLIENTENCODING=UNICODE LANG=en_US.UTF-8
db=# \encoding UNICODE
I was more concerned about the database encoding, which the above doesn't prove. Try "SHOW server_encoding"
regards, tom lane
[ \ / [ >X< Christian Fowler | spider AT viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend