The following bug has been logged online: Bug reference: 2193 Logged by: Andras Got Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
