| From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | t-ishii(at)sra(dot)co(dot)jp, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: confused with encodings |
| Date: | 2003-06-17 04:51:50 |
| Message-ID: | Pine.LNX.4.44.0306170647260.6856-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 16 Jun 2003, Oleg Bartunov wrote:
> 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.
En encoding does not imply any sort order. UTF-8 can be used to store
strings in many languages, each having different sort order (and other
properties). It's the locale that determines these things.
It would be nice to be able to set the locale per database, or even per
column.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-06-17 06:21:11 | O_DIRECT in freebsd |
| Previous Message | Christopher Kings-Lynne | 2003-06-17 03:53:34 | Re: pg_get_triggerdef in pg_dump |