Re: [BUGS] BUG #7783: lower & upper function incorrect work

2013-01-03 Thread Tom Lane
alex.shniper...@gmail.com writes: > PostgreSQL version: 9.1.7 > Operating system: osx lion 10.7.5 > 1) create DataBase with > ENCODING = 'UTF8' > LC_COLLATE = 'C' > LC_CTYPE = 'C' > 3) insert one simple record with Russian word > INSERT INTO testtable (id, name) VALUES (1, 'Залог'); > 4)

Re: [BUGS] BUG #7783: lower & upper function incorrect work

2013-01-03 Thread Aleksander Shniperson
Hi, thanks for answer. Yes this may help, but Postgres must convert it automatically. 03.01.2013, в 22:27, Pavel Stehule написал(а): > Hello > > maybe this is same problem > > http://postgresql.1045698.n5.nabble.com/PostgreSQL-UTF-8-and-Mac-OS-X-td1852185.html > > please, try to use different

Re: [BUGS] BUG #7783: lower & upper function incorrect work

2013-01-03 Thread Pavel Stehule
Hello maybe this is same problem http://postgresql.1045698.n5.nabble.com/PostgreSQL-UTF-8-and-Mac-OS-X-td1852185.html please, try to use different collate - maybe this advice should to help to you http://yzisin.wordpress.com/2012/01/09/how-to-fix-locale-issues-in-mac-os-x-lion-terminal/ regard