Re: BUG #7783: lower & upper function incorrect work

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(dot)shniperson(at)gmail(dot)com>:
>> The following bug has been logged on the website:
>>
>> Bug reference: 7783
>> Logged by: Alexander Shniperson
>> Email address: alex(dot)shniperson(at)gmail(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs