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/ regards Pavel Stehule 2013/1/3 <alex.shniper...@gmail.com>: > The following bug has been logged on the website: > > Bug reference: 7783 > Logged by: Alexander Shniperson > Email address: alex.shniper...@gmail.com > PostgreSQL version: 9.1.7 > Operating system: osx lion 10.7.5 > Description: > > Hi. > > I have problem at my project, try to do simple steps: > 1) create DataBase with > ENCODING = 'UTF8' > LC_COLLATE = 'C' > LC_CTYPE = 'C' > > 2) create new table at just created database > > CREATE TABLE testtable > ( > id serial NOT NULL, > name character varying(50) NOT NULL, > CONSTRAINT testtable_pkey PRIMARY KEY (id ) > ) > > 3) insert one simple record with Russian word > > INSERT INTO testtable (id, name) VALUES (1, 'Залог'); > > 4) try to select data with upper & lower functions with 'like' operator > > select *, lower(name), upper(name) from testtable where lower(name) like > '%залог%' > > 5) as result you must see nothing, just fields without data > > fix it please, thanks. > > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
