Vivid Lust Posted November 27, 2009 Share Posted November 27, 2009 Hi all, This mysql query is finding no rows when used in a php file BUT does find a row when used in phpMyAdmin - this happens ONLY when there is a foreign character is in the phrase to be matched with a prhase that doesnt have a foreign character either , such as: á,ú,í,ó,é. Here is the query: SELECT * FROM films WHERE name=''Luna nueva, La saga Crepúsculo" Could anyone please help? Find the row in phpmyadmin but not in php file? Thanks. This is the query Quote Link to comment Share on other sites More sharing options...
Vivid Lust Posted November 28, 2009 Author Share Posted November 28, 2009 Anyone? Quote Link to comment Share on other sites More sharing options...
phant0m Posted November 28, 2009 Share Posted November 28, 2009 have you set your connection charset properly? What encoding does your PHP file have? What charset does your table use? Quote Link to comment Share on other sites More sharing options...
Vivid Lust Posted November 28, 2009 Author Share Posted November 28, 2009 the row has utf-bin, how do I change the encoding of the php? and the charset of the connection? thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.