how to import text file contain multilanguage text into mysql using php ?

how can i import text file contain multilanguage text into mysql using php where every language is in different charset ?

 

By using iconv (it's in the php docs) you could convert the text to utf8. After that you should have no problem storing it anywhere.

 

Do you want to insert text according to it's language?

 

You can select data type text in the mysql table and you will be able to insert those characters in it

 

yes according to it's language

 

If you have your text somehow formated to differentiate the languages, should be easy. Also, if you can alter your text file you also can format it to be easy to use. Right now, I'm thinking to something like this:

[en] your text block in English[/en]
[fr] your text block in French[/fr]
.
.
.

Code (markup):

What is between [en] and [/en] goes to English part, what is between [fr] and [/fr] goes to French part, and so on ...

 

how can we add more languages, like 50? please explain. thanks