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
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