Is there a rule when we must use the Unicode types?
I have seen that most of the European languages (German, Italian, English, …) are fine in the same database in VARCHAR columns.
I am looking for something like:
- If you have Chinese –> use NVARCHAR
- If you have German and Arabic –> use NVARCHAR
What about the collation of the server/database?
I don't want to use always NVARCHAR like suggested here
What are the main performance differences between varchar and nvarchar SQL Server data types?