BUG #2193: INITCAP and LOWER/UPPER string conversion error
От | Andras Got |
---|---|
Тема | BUG #2193: INITCAP and LOWER/UPPER string conversion error |
Дата | |
Msg-id | 20060121005337.342AAF0B02@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2193: INITCAP and LOWER/UPPER string conversion error
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2193 Logged by: Andras Got Email address: andrej1981@gmail.com PostgreSQL version: 8.0.4, 8.1.1 Operating system: FreeBSD and Linux Description: INITCAP and LOWER/UPPER string conversion error Details: Hi, 8.0.4 I'm trying to select with LOWER/UPPER and INITCAP but they return bad values after hungarian accentuated letters (e.g: é á ű ú Šó ü). The bad is value is a capital letter. This makes almost impossible to compare strings from an input with ones in the table. Also LOWER returns a big capital letter for the first letter of the word. UPPER doesn't really converts some chars to uppercase, e.g: ó, á, é. I'd like to something like this with PHP: "SELECT id FROM table WHERE LOWER(name) = '".strtolower($name)."'; I tried with LATIN2 encoding and the same happened. 8.1.1 The first capital letter probleml looks like to be solved, but the accentuated letter problem still exists. Thank you for your time, Andrej
В списке pgsql-bugs по дате отправления: