problem with Win1251 (Cyrillic)
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@fullsoft.net
www.fullsoft.net
Dobrena Miteva wrote:
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()
These are controlled by your locale defined by initdb (look for
LC_COLLATE and LC_CTYPE output from the command pg_controldata) _and_
the encoding you used to create the database. For the above to work
both have to be Win1251. Our documentation goes into detail about this.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073