| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | hernan gonzalez <hgonzalez(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql weird behaviour with charset encodings |
| Date: | 2010-05-07 21:43:02 |
| Message-ID: | 1514.1273268582@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
hernan gonzalez <hgonzalez(at)gmail(dot)com> writes:
> My scenario: Fedora 12, Postgresql 8.4.3 compiled from source.
> Database encoding (global) LATIN9.
> User postgres locale: LANG=en_US.iso885915,
> User root locale LANG=en_US.UTF-8
> When I connect from postgres user, all is right.
> When I connect from root, it's not right... except with \x
What's client_encoding set to in the two cases? If it's not utf8,
does changing it to that improve matters? Alternatively, see what
xterm (or whatever terminal window you're using) thinks the encoding
is, and change it to match psql's client_encoding.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hernan gonzalez | 2010-05-07 22:01:56 | Re: psql weird behaviour with charset encodings |
| Previous Message | hernan gonzalez | 2010-05-07 21:21:05 | psql weird behaviour with charset encodings |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hernan gonzalez | 2010-05-07 22:01:56 | Re: psql weird behaviour with charset encodings |
| Previous Message | Tom Lane | 2010-05-07 21:35:37 | Re: beta to release |