>Bug reference: 1576
>Logged by: Sergio Luis SÃÂnchez
>Email address: [EMAIL PROTECTED]
>PostgreSQL version: 7.4.3 and 8.0.1
>Operating system: linux (7.4.3) and WinXP (8.0.1)
>Description: Function UPPER does not give back the
>awaited results
>Details:
>
>Hi.
>
>I'm from Spain, and I am using a PostgreSQL as database
>system. Sorry for my
>English.
>
>I launch a select with the upper function to retrieve a text in capital
>letters. When I launch the function to text with accents
>(Usual in Spanish
>language), I get the marked words in lowercase, and it's wrong.
>
>To test it I launh this query:
>
>select upper('aeiouÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂ');
>
>And the result was: "AEIOUÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂ", when it
>must be
>"AEIOUÃÂÃâÃÂÃâÃÅÃâÃËÃÅÃâÃâ".
>
>I try this function with UNICODE and LATIN1 encodings, and I
>retrieve same result.
It shouldn't work in UNICODE - see
http://pginstaller.projects.postgresql.org/FAQ_windows.html#2.6.
It should work in LATIN1 though. I've never had any problems with that part
(use it for swedish chars all the time). Make sure you really switched the
server side encoding (new initdb), and not just the client side.
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
