dsdsdsdsd Posted February 7, 2011 Share Posted February 7, 2011 hello ... I have a table with european characters in it. when I query the table and echo the result to html, I get strange results. in the attached image you can see the special character in the db ( on the left ) that gets converted ( on the right ). my table is set to collation = utf8_general_ci and the column in question = utf8_general_ci my php script calls: mysql_set_charset( 'utf8' , $my_db_connection ) ; any thoughts? [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/226937-getting-special-characters-out-of-database-to-html/ Share on other sites More sharing options...
bh Posted February 7, 2011 Share Posted February 7, 2011 Hi, Is your php file also in UTF-8? Link to comment https://forums.phpfreaks.com/topic/226937-getting-special-characters-out-of-database-to-html/#findComment-1170924 Share on other sites More sharing options...
dsdsdsdsd Posted February 7, 2011 Author Share Posted February 7, 2011 to be honest I don't know ... didn't know php files could have a collation setting Link to comment https://forums.phpfreaks.com/topic/226937-getting-special-characters-out-of-database-to-html/#findComment-1170925 Share on other sites More sharing options...
dsdsdsdsd Posted February 7, 2011 Author Share Posted February 7, 2011 bingo... added: <meta http-equiv = 'Content-Type' content = 'text/html; charset=UTF-8' " > this particular script was not intended as a public webpage, but rather just as a dashboard for me, and so I did not have <html/head/metas> in there. thanks, Shannon Link to comment https://forums.phpfreaks.com/topic/226937-getting-special-characters-out-of-database-to-html/#findComment-1170927 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.