Re: [ADMIN] restored database locale problem

2005-12-28 Thread Gary Stainburn
On Wednesday 28 December 2005 16:22, Tom Lane wrote: > Gary Stainburn <[EMAIL PROTECTED]> writes: > > goole=# show lc_ctype; > > lc_ctype > > - > > en_US.UTF-8 > > (1 row) > > > > goole=# show server_encoding; > > server_encoding > > - > > UNICODE > > (1 row) > > Hm

Re: [ADMIN] restored database locale problem

2005-12-28 Thread Tom Lane
Gary Stainburn <[EMAIL PROTECTED]> writes: > goole=# show lc_ctype; > lc_ctype > - > en_US.UTF-8 > (1 row) > goole=# show server_encoding; > server_encoding > - > UNICODE > (1 row) Hm. Well, the error message implies that there's some data in the database that we

Re: [ADMIN] restored database locale problem

2005-12-28 Thread Gary Stainburn
On Wednesday 28 December 2005 15:58, Tom Lane wrote: > Gary Stainburn <[EMAIL PROTECTED]> writes: > > ERROR: invalid multibyte character for locale > > HINT: The server's LC_CTYPE locale is probably incompatible with the > > database encoding. > > The HINT seems straightforward enough to me ;-).

Re: [ADMIN] restored database locale problem

2005-12-28 Thread Tom Lane
Gary Stainburn <[EMAIL PROTECTED]> writes: > ERROR: invalid multibyte character for locale > HINT: The server's LC_CTYPE locale is probably incompatible with the > database encoding. The HINT seems straightforward enough to me ;-). What do "show lc_ctype" and "show server_encoding" say?