Re: [GENERAL] Huge problem with upper/lower and foreign chars

2005-05-13 Thread Stephan Szabo
On Fri, 13 May 2005, [ISO-8859-1] Victor Spång Arthursson wrote: > Ciao again! > > I just ran into a huge problem with the functions upper and lower… > > It turns out, that when converting the case of foreign characters, > like åäö, they stay as they were from the beginning… To help people try to

[GENERAL] Huge problem with upper/lower and foreign chars

2005-05-13 Thread Victor Spång Arthursson
Ciao again! I just ran into a huge problem with the functions upper and lower… It turns out, that when converting the case of foreign characters, like åäö, they stay as they were from the beginning… Example: SQL = select 'test åÄöØ', upper('test åÄöØ'), lower('test åÄöØ') Result: ?column?upp