SQL Insert multilingual characters
- by Usman Akram
I am trying to create a table in my MS SQL database for Languages.
I want to store an English name of Language and a local name of language in the database.
i.e.
Language, Language(local)
English, English
German, Deutsch
Italian, Italiano
Japanese, ???
...
...
I have 279 languages that I want to import, but when I import it shows '?????' for some like japanese, Russian and arabic etc
The database Collation is Latin1_General_CI_AS.
I would also like advise on multilingual websites; if i have a database of product descriptions and I want to have translation in multiple languages, should I go for separate databases or Can I have translation in one databse? (I prefer not to duplicate data!). Anything else to make sure users are able to write comments in different languages (char encoding on web?) and can be stored in database.