storing and retrieving japanese charaters in a mysql db

[tallberg]

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?

 

[tallberg]

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