Re: [BUGS] BUG #1925: upper() and lower() fails with non-english char.

[Magnus Hagander]

> The following bug has been logged online:
> 
> Bug reference:      1925
> Logged by:          Søren Vainio
> Email address:      [EMAIL PROTECTED]
> PostgreSQL version: j2sdk1.4.2_07
> Operating system:   win XP
> Description:        upper() and lower() fails with non-english char.
> Details: 
> 
> upper(string) and lower(string) does not work on danish, 
> swedish and german letters like æ, ø, å, ü, and ö 
> (&#230, &#248, &#229, &#252, &#246).

What encoding are you using?
This sounds a lot like what shows up when you use UNICODE (UTF8) encoding on a 
Win32 PostgreSQL 8.0. This is not supported. It will be supported in 8.1, but 
for 8.0 you need to go with a different encoding such as LATIN1.


//Magnus

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend