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 Link to comment https://forums.phpfreaks.com/topic/183151-mysql-and-foreign-characters/ Share on other sites More sharing options...
Vivid Lust Posted November 28, 2009 Author Share Posted November 28, 2009 Anyone? Link to comment https://forums.phpfreaks.com/topic/183151-mysql-and-foreign-characters/#findComment-966911 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? Link to comment https://forums.phpfreaks.com/topic/183151-mysql-and-foreign-characters/#findComment-966917 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 Link to comment https://forums.phpfreaks.com/topic/183151-mysql-and-foreign-characters/#findComment-966962 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.