SQL Server Collation for Arabic, Hebrew, English and French
Language support comes from datatype: use nvarchar/nchar (which stored unicode basically)
Collation is sorting + comparing + non-unicode code page


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:

Example

ORDER BY
    LatinCollationCol COLLATE Arabic_CI_AI_KS = N'عربي/عربى';