Need help importing to mysql ( language problem )

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
wpsd
Forum Newbie
Posts: 6
Joined: Thu May 22, 2008 8:53 am

Need help importing to mysql ( language problem )

Post by wpsd »

Here is my problem
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 :( )
User avatar
pavanpuligandla
Forum Contributor
Posts: 130
Joined: Thu Feb 07, 2008 8:25 am
Location: Hyderabad, India

Re: Need help importing to mysql ( language problem )

Post by pavanpuligandla »

@ above..

why converting ur excel spreadsheet to another format like .csv?
dun ever do like that.
import excel itself to the database.
i wolud like to hear more frm u. so tht i can help u out..
Post Reply