I have new sql server database which need to have support in 3 differnt languages which collation i need to choose if i want my database to support both hebrew or arabic and also english and also french?
migrated from stackoverflow.com Feb 16 '12 at 14:23
This question came from our site for professional and enthusiast programmers.
So, one column can store all languages, but it can have only one collation. You can "add" extra collations using computed columns, or coerce it during a sort/compare using the COLLATE clause:
|show 5 more comments|
You should use UTF8
On this link you will see hebrew, arabic, and french language encoded with UTF8 : http://www.unics.uni-hannover.de/nhtcapri/multilingual1.html