From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | alex(dot)shniperson(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #7783: lower & upper function incorrect work |
Date: | 2013-01-03 18:27:48 |
Message-ID: | CAFj8pRBr50FiOVQHeqggtpEh8Wuaot+NEtbrpYdMP8Mr6KWcGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksander Shniperson | 2013-01-03 19:52:03 | Re: BUG #7783: lower & upper function incorrect work |
Previous Message | smatiz | 2013-01-03 18:20:10 | BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table |