How to save Spanish and Arabic characters in SQL Server 2008 R2 from a C# Windows application?

Question

If you have chosen a database access technology such as ADO.NET, LINQ-to-SQL, or Entity Framework, please indicate that. Then, the answers can be more specific. — Tom Blodget, Mar 20 '17 at 16:51

score 0 · Answer 1 · edited May 23 '17 at 12:25

0

In sql server, use the nvarchar() data type instead of varchar() to support unicode.

In your application, specify the parameter as SqlDbType.NVarChar as shown here: How to create NVarchar(max) Sqlparameter in C#?

edited May 23 '17 at 12:25

Community

answered Mar 20 '17 at 14:50

SqlZim

score 0 · Answer 2 · answered Mar 20 '17 at 16:16

0

In SQL Server, use nvarchar()data type instead of varchar()to support Unicode.

answered Mar 20 '17 at 16:16

Akhatran

2 Answers2