Hi. I have an old MSDE database with fields defined as varchar (not nvarchar!). It was capable of storing Chinese or Russian characters. The application was able to read/write these characters from MSDE. I can create a new SQLExpress
database in SQL Management Studio, using the same schema. But the newly created database can't read or write the same data as before. It seems to store the unicode as "????" now. MSDE behaved more like Access with its "text"
datatype. I need Express to do the same.
I want to be able to store data like MSDE used to. Is there a setting or property in Express where I can force the same behavior I see in the MSDE database engine? Is this property or setting available in SQL 2012 Express?
Thanks!
Go to the complete details ...