BUG #7783: lower & upper function incorrect work
От | alex.shniperson@gmail.com |
---|---|
Тема | BUG #7783: lower & upper function incorrect work |
Дата | |
Msg-id | E1TqgmD-0007Fs-JZ@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #7783: lower & upper function incorrect work
Re: BUG #7783: lower & upper function incorrect work |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 7783 Logged by: Alexander Shniperson Email address: alex.shniperson@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 =3D 'UTF8' LC_COLLATE =3D 'C' LC_CTYPE =3D '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, '=D0=97=D0=B0=D0=BB=D0=BE=D0=B3= '); 4) try to select data with upper & lower functions with 'like' operator = select *, lower(name), upper(name) from testtable where lower(name) like '%=D0=B7=D0=B0=D0=BB=D0=BE=D0=B3%' 5) as result you must see nothing, just fields without data fix it please, thanks.
В списке pgsql-bugs по дате отправления: