encoding format of multilingual text while saving to database
One suggestion would be to use nvarchar(n) type column. You can then store UCS2 data in that column. The width of the column can be decided based on the data.