SQLTeam.com | Weblogs | Forums

Sql server 2012 data column used for 7 different languages

In a sql server 2012 database, I want to store some messages in the database for the following languages:
Karen, Arabic, Nepali, Burmese, and Kiswahili. This would be in a column called stringtemplate that is currently defined
as varchar(max).
**note: this column currently stores messages in English and Spanish.
Can you tell me if I need to change anything about the column in the database? If so, would you show me what I need to change so that
I can store all the language messages in the same column if possible.

alter table #sample alter column stringtemplate nvarchar(max)

1 Like

Also look into server level, database level and table level collation

Why would I need to look into 'Also look into server level, database level and table level collation'? What would I be looking for?

Because it can affect you being able to save or not save certain languages with diacritics èê and ability to search for them

1 Like