MySQL Forums
Forum List  »  General

Problem with upper and lower functions
Posted by: Denitsa Pelova
Date: October 08, 2004 01:10AM

Hi,
I've been working with mysql for a while, but now I have a problem and I can't find the solution for it.
Here is the problem:
When making query like: 'select upper(name) from my_table where name like '%für Kinder%';
I get results like:
...
|SPIEL UND SPASS FüR KINDER |
|SPIELSHOW FüR KINDER |
|SPIEL UND SPASS FüR KINDER |
|QUIZSHOW FüR KINDER |
|QUIZSHOW FüR KINDER |
|SPIELSHOW FüR KINDER |
|SPIEL UND SPASS FüR KINDER |
|SPIELSHOW FüR KINDER |
|SPIEL UND SPASS FüR KINDER |
...
As you can see the 'ü' is still in lower case. Is there any way to get 'ü' in upper case?
I read about character sets and collation, but I couldn't find the answer. If someone encountered this problem before and could help me,
Thank you!

Options: ReplyQuote


Subject
Written By
Posted
Problem with upper and lower functions
October 08, 2004 01:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.