Re: Lower case

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...

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-ru-general by date

  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