|
-
March 13th, 2008, 02:28 PM
#1
MySQL Collation issue
I have a mysql database with one table 'data' and one field in that table 'news'. This field 'news' contains a record 'pájaro'
The database collation is utf8_spanish_ci
The field collation is utf8_spanish_ci
I do a query from php.
Why this simple query, SELECT * FROM data WHERE news='pajaro', is not working and however SELECT * FROM data WHERE news='pájaro' is working?
The collation should force to obtain the same result with both queries.
What's wrong with this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|