tallberg Posted May 12, 2010 Share Posted May 12, 2010 Hi I would like to know to properly store and retrieve japanse in a mysql db. Ive changed the field is TEXT ive tryed changing the collation to various different types and this has made no difference. The charater look in in phpmyadmin. Ive tryed changing the connection collation and this has made no difference. I know its to do with the db because my php page can display hard coded charaters. Help? Link to comment https://forums.phpfreaks.com/topic/201537-storing-and-retrieving-japanese-charaters-in-a-mysql-db/ Share on other sites More sharing options...
tallberg Posted May 13, 2010 Author Share Posted May 13, 2010 A solution to my problem http://www.shawnolson.net/a/946/unicode-data-with-php-5-and-mysql-41.html Basically $sql = "SET NAMES 'utf8'"; $rs = mysql_query($sql) or die(); before a query will do the job Link to comment https://forums.phpfreaks.com/topic/201537-storing-and-retrieving-japanese-charaters-in-a-mysql-db/#findComment-1057645 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.