French character whith C++ builder+mySql+MyOdbc 8-)

Hello, I have just resolved a problem that I encountered for the first time 1 year ago 8-) 8-) My problem was to store strings with some "french" special characters inside, like "é è à ç". When these characters were entered from a form written in PHP, everything was OK but when they were

My problem with ucase (and lcase too)

Hi everybody, ucase behaviour :-( mysql> select ucase('déjà vu'); +--+ | ucase('déjà vu') | +--+ | DÉJÀ VU | +--+ 1 row in set (0.01 sec) is there a way to make it answer 'DEJA VU' instead of 'DÉJÀ VU' Thanx for your help... -- Franco