Small script needed to input Chinese data (UTF-8) from excel sheet into mysql5.0 database(UTF-8). Please refer to the attached excel sheet as example.
New mysql server just installed, supports utf8 encoding.
New php version, also support utf8.
I have tried many methods but it seems that I cannot convert the chinese text into UTF-8 encoding properly so that I can input in mysql database.
I have tried using C# via JET OLEDB4.0 to input into mysql.
I have also tried outputting in txt format and using php to parse the text file and input into mysql.
The finished program can be in Visual Basic, C#, PHP, Excel Macro. However, the finished result MUST BE GOOD UTF-8 ENCODING data inserted into mysql database WITHOUT any information loss.
Please contact for further information.
7 freelancers are bidding on average $54 for this job
I am chinese live in Hong Kong and I always write such programs. See the screen capture in the PM and you can see your requirement was fullfilled!! pls PM me for further discussion
Please try to convert the xls into Ms Sql Server,then use the Mysql Migration tool to convert Sqlserver into [url removed, login to view] any question,PM [url removed, login to view] doesn't need any [url removed, login to view]'s enough to use exist tools. Btw ,I am also a Ch Mere
hi, we are a group of Chinese professionals. We can handle your requirements with solution that is easy to operate and independent of your working environment. Please check PMB.