So, what does the form do that the mass conversion script doesn't?  It 
sounds like, if you can detect the Japanese characters and have the 
script store them in the proper data type, you're set.  (I wish I could 
read Japanese.)  I'd like to see the solution once you find it.  8-)

>Yes I can view the text in spreadsheet. If i copy the text and paste it in 
>a form which save the data into the mysql it stores unicode for those 
>text. and when i agian retieve the data from the db and show it in the 
>page it shows japanese. But my problem is i cannot enter these huge data 
>(140 col, 55 row) every day manyally into the form. so i read the data 
>automatically from the spread sheet and store it in the db.
>