The following bug has been logged online:
Bug reference: 2540
Logged by: radoslaw wisniewski
Email address: radzimir@freenet.de
PostgreSQL version: 8.1.4-2
Operating system: Linux
Description: function upper(..) and operator 'like' problem
Details:
function upper combined with like opertaor and german umlauts (db encoding
UTF8) fails.
Working example in some query:
select * from test where upper( name ) like upper('%Störk%')
Not working example:
select * from test where upper( name ) like '%STÃRK%'
function lower seems to have the same problem.
radoslaw wisniewski wrote:
> function upper combined with like opertaor and german umlauts (db
> encoding UTF8) fails.
You have probably configured the wrong locale, but you have not given
nearly enough information to reproduce your problem.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.