From: | "Vladimir S(dot) Petukhov" <vladimir(at)sycore(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Lower case |
Date: | 2005-01-27 00:16:14 |
Message-ID: | 200501270016.14782.vladimir@sycore.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-ru-general |
On Wednesday 26 January 2005 20:01, you wrote:
> "Vladimir S. Petukhov" <vladimir(at)sycore(dot)org> writes:
> > pg_controldata /var/pgsql/data
> > ...
> > LC_COLLATE: ru_RU
> > LC_CTYPE: ru_RU
> >
> > bash-2.05b# psql -l
> > List of databases
> > Name | Owner | Encoding
> > -----------+----------+----------
> > testdb | postgres | UNICODE
> >
> > And LIKE, ILIKE, ~ do not recognize upper/lower case..
>
> What character encoding is implied by those LC_ settings on your machine?
> If it's different from the database encoding (here utf8) these things
> won't actually work right.
LANG=ru_RU.koi8r
LC_ALL=ru_RU.koi8r
But how it act on lower/upper cases? Client use utf-8 encoding...
>
> Also, before PG 8.0 upper/lower simply don't work on multibyte characters,
> which means you'd have to use a single-byte encoding to make it work
> (I think koi8 is single-byte but not sure).
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
You feel a whole lot more like you do now than you did when you used to.
Now playing:
AutoGenerated by fortune & xmms...
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2005-01-27 00:33:01 | Re: visualizing B-tree index coverage |
Previous Message | PFC | 2005-01-26 23:59:58 | Re: Recursive queries |
From | Date | Subject | |
---|---|---|---|
Next Message | Mihail Nasedkin | 2005-01-27 03:23:03 | Re: [GENERAL] Lower case |
Previous Message | Vladimir S. Petukhov | 2005-01-26 22:33:26 | Re: Lower case |