Dear Postgre team,
My name is Mladen Mitev.
I downloaded and installed Postgre SQL 8.0.1 and I found that it did not work with Win1251 (Cyrillic). It did not translate the capital and small letters.
These commands did not work:
ILIKE
lower()
upper()
By example:
1.
create table t1 (c1 varchar(15) )
2.
insert into t1( c1) values ('Проба')
3.
select lower( c1), c1 from t1
output :
'Проба'
it should be:
'проба'
I would like to consult me how to solve this problem?
I am looking forward your prompt reply.
Thank you in advance,
Mladen Mitev
mitev(at)fullsoft(dot)net
www.fullsoft.net