Storing unicode strings to SQL Server via ActiveRecord

Question

I am using Castle ActiveRecord as my ORM. When I try to store unicode strings, I get question marks instead.

Saving unicode strings worked perfectly when I was using mysql, but when I recently switch to SQL Server it broke. How should I go about fixing this?

Answer 1

You're most likely using the incorrect SQL Server data type. varchar is meant for a plain-old character while nvarchar is meant for Unicode characters. The same applies for char & nchar and text and ntext.

MSDN for SQL Server data type
MSDN for SQL Server Unicode data