)
Yes, now when initdb done with --locale=ru_RU.UTF-8,
lower('RussianString') gives me 'russianstring', though, case-insensiive
regexp still not working. I guess i'll stick with lower() ~ lower()
construction.
And thanks everybody who replied!
Oleg
On Thu, 12 Jul 2007, alex
Tom Lane wrote:
alexander lunyov <[EMAIL PROTECTED]> writes:
With this i just wanted to say that lower() doesn't work at all on
russian unicode characters,
In that case you're using the wrong locale (ie, not russian unicode).
Check "show lc_ctype".
db=&
(as we talked earlier), then how long
will it take to fix it? I know little about postgresql development
process, maybe you know it little better?
--
alexander lunyov
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
have first char
capitalized, and result is the same. Seems that lower() can't lower
multibyte character.
db=> select lower('Зелен');
lower
---
Зелен
(1 запись)
--
alexander lunyov
[EMAIL PROTECTED]
---(end of broadcast)--
with case-insensitive regexp does no work right now!
On 09/07/07, alexander lunyov <[EMAIL PROTECTED]> wrote:
Hello, friends.
OS FreeBSD 6.2, Postgresql 8.2.4
Postgresql does not search case-insensitive russian regexp unicode
patterns. Postgres is working under user pgsql with logi
ds, but they are with first capital character:
db=> select street from people where street ~* 'Зелен';
street
Зеленая
Зеленоградская
(2 rows)
Search for english values work fine, russian values not. Why could it be?
--
alexander lunyov
[EMAIL PROTECTED]
--
