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 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