On Thu, 27 Jan 2005 00:16:14 +, Vladimir S. Petukhov
<[EMAIL PROTECTED]> wrote:
> > > LC_COLLATE: ru_RU
> > > LC_CTYPE: ru_RU
> > >Name| Owner | Encoding
> > > ---+--+--
> > > testdb | postgres | UNICODE
On Wednesday 26 January 2005 20:01, you wrote:
> "Vladimir S. Petukhov" <[EMAIL PROTECTED]> writes:
> > pg_controldata /var/pgsql/data
> > ...
> > LC_COLLATE: ru_RU
> > LC_CTYPE: ru_RU
> >
> > bash-2.05b# psql -l
> > List of databases
>
"Vladimir S. Petukhov" <[EMAIL PROTECTED]> 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
> ---+--+-
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 rec
Vladimir,
there is pgsql-ru-general mailing list for russian speaking people
Oleg
On Wed, 26 Jan 2005, Vladimir S. Petukhov wrote:
Hi!
Sorry for my English..
I want to do case-insensitivity search, like this
... WHERE lower (column_name) LIKE lower (%value%);
This work fine for English..
Bu
Tino Wildenhain wrote:
Hi,
On Wed, 2005-01-26 at 12:01 +, Vladimir S. Petukhov wrote:
Hi!
Sorry for my English..
I want to do case-insensitivity search, like this
... WHERE lower (column_name) LIKE lower (%value%);
This work fine for English..
But i need search for Russian words, lower() operat
On Wed, 26 Jan 2005 12:01:49 +, Vladimir S. Petukhov
<[EMAIL PROTECTED]> wrote:
> I want to do case-insensitivity search, like this
> ... WHERE lower (column_name) LIKE lower (%value%);
> This work fine for English..
> But i need search for Russian words, lower() operator does not work with
> R
Hi,
On Wed, 2005-01-26 at 12:01 +, Vladimir S. Petukhov wrote:
> Hi!
>
> Sorry for my English..
>
> I want to do case-insensitivity search, like this
> ... WHERE lower (column_name) LIKE lower (%value%);
> This work fine for English..
> But i need search for Russian words, lower() operator d
Hi!
Sorry for my English..
I want to do case-insensitivity search, like this
... WHERE lower (column_name) LIKE lower (%value%);
This work fine for English..
But i need search for Russian words, lower() operator does not work with
Russian (non-English) chars, but ORDER works fine...
