Search code examples
sql-serverunicodemultilingualnvarchar

SQL Server how to store multilingual data?

I created a database with collation: default & a table with a column has nvarchar(50) as its data type. But when I select the data I got "???". Can anybody tell me what's wrong?

Solution

  • You must always declare N before inserting any values.

    INSERT INTO MYTABLE (Col1) VALUES (N'your text')