What SQL collation should I use to store multi-language character?

Question

I have a Database and my users are from all around the world because of this I should store the inputs in any language type.

By default my SQL collation is SQL_Latin1_General_CP1_CA_AS but this collation can not store Russian language.

What SQL collation I should use to store any language type like Japanese, Persian, English,Russian and ....?

What makes you think you can't use Russian with that collation? (PS It's collation, not collection) — DavidG, Jan 21 '18 at 15:07
i saved one and look at my table and i saw that has been converted to "????????" — motevalizadeh, Jan 21 '18 at 15:08
What data type do you have in the table? I'm going to guess it's `VARCHAR` instead of `NVARCHAR`? — DavidG, Jan 21 '18 at 15:09

score 6 · Accepted Answer · answered Jan 21 '18 at 15:11

The problem isn't the collation you are using, but the data type you are using to store text.

Your table is using VARCHAR type when you should be using NVARCHAR. For example:

CREATE TABLE MyTable
(
    SomeColumn VARCHAR(50)
)

Should be:

CREATE TABLE MyTable
(
    SomeColumn NVARCHAR(50)
)

For more info on the difference, see here.

1 Answers1