MySQL Forums
Forum List  »  Stored Procedures

Charset
Posted by: Jorge Ferreira
Date: November 24, 2005 12:04PM

Hi everyone,

I was trying the stored procedures in MySQL (Thank God They're here) and i noticed something that looks real strange.
When i executed a query like "Select * FROM names WHERE name='António'" the query returned 8 results. Once again, when i run "Select count(id) as num FROM names WHERE name='António'", it returns "num=8".

When i run this query inside a SP or Function, it returns 0 results. If i search for any other name with special characters it will return always 0 results. If no special characters are present, it runs ok.

The table is the same, with the same Charset(Latin1), etc...
Changing the names of people is out of question ;-) so what can i do?

Regards,

Jorge Ferreira

Options: ReplyQuote


Subject
Views
Written By
Posted
Charset
2232
November 24, 2005 12:04PM
1380
November 24, 2005 07:23PM


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.