From: | alex(dot)shniperson(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7783: lower & upper function incorrect work |
Date: | 2013-01-03 09:07:49 |
Message-ID: | E1TqgmD-0007Fs-JZ@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | smatiz | 2013-01-03 18:20:10 | BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table |
Previous Message | alex.shniperson | 2013-01-03 08:44:17 | BUG #7781: pgagent incorrect installation |