Re: [BUGS] problem with Win1251 (Cyrillic)

#1

Dobrena Miteva wrote:

Quote:

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 (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] problem with Win1251 (Cyrillic)

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] problem with Win1251 (Cyrillic) - 04-10-2005 , 06:34 PM