I have a ton of data in excel way and i want to import it to my database ( using phpmysql )
since phpmysql cant import excel i change it to csv but unable to import cause... i dont know what the cause is
so i use second method excel to access than convert it to text base a .txt file
and i use some simple code that read ( fopen ) from the .txt file and do an insert loop
the data that i need to import has number, text and chinese text
the chinese text never show up correctly neither in phpmysql nor in the web ( but it show ok in the array when insert looping )
can anybody help me i'm stuck now
my database and all the table use utf8_general_ci
than i set in my small php :
mysql_query("SET_NAME UTF8")... something like this im positive i write it correct in the php
than use some php mb extension to set to utf8 also
but no luck at all
if i use a form an input box it than submit it will show nicely in the database and web ( 1000 more data i dont think so