| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: confused with encodings |
| Date: | 2003-06-17 12:34:35 |
| Message-ID: | Pine.LNX.4.44.0306162102360.2751-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Oleg Bartunov writes:
> I thought I could specify different encodings for different databases
> and these encodings will be used in text operations (sort, upper,lower),
> not just for conversion. But, actually, the only encoding is important
> for text operations - the one specified with 'initdb' command ! Is't
> true ?
Absolutely not, but you may find that in order to allow LC_CTYPE
operations (namely sort, upper, lower) in UTF8, you need a locale that
supports that, namely the xx_XX.utf8 kind. So realistically, you are kind
of stuck with one encoding for the entire cluster.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-06-17 12:35:27 | Re: [HACKERS] CVS -Tip compile issue -- FreeBSD 4.8 |
| Previous Message | Curt Sampson | 2003-06-17 10:34:50 | Re: O_DIRECT in freebsd |