Wednesday, January 20, 2010

About the multilingual language export/import

Hello All,

Recently i am facing the lots of issue while making multilingual sites export/import with MySql database.

I have done certain thing for doing export/import.

1. First make the table which is support UTF-8 format. Generally, utf-8 general_ci.
2. Also set the "SET NAME UTF-8" format for multiple languages.
3. Now ,using php header I have generate the CSV file. but the file is containing the special character so its not readable.
Now , for the solution i have also changed microsoft word language support extension but still getting special character in CSV.

So need the solution for the same. please help me.

Also suggest if we can use other format while export/import with mySql table.

Regards,
sandip

No comments: