Saving ANSI Character into SQL Server's varchar field

  • Thread starter Thread starter Norton
  • Start date Start date
N

Norton

I am trying to type some chinese character into a datagrid then update them
into SQL server using SQLDataAdapter, however it always store??? in the
database.

As my data type in SQL'server is in Varchar format (i cannot change it into
nvarchar format), what should i do ?

Thx a lot
 
Not a globalization expert, but IMO the change to the nvarchar datatype is
the proper way to deal with this.

Using tricky things such as storing the data using a format such as utf-8
will be more work and a nightmare on the long run compared with updating to
the appropriate data type...

Patrice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How could you explain this? 1
SqlCommand Parameters with SqlDbType and VarChar(MAX) 1
Strange error with different SQL Server versions 2
Access to SQL Server 2
Scripts failing without error 3
Determining field type CHAR vs VARCHAR 3
Non English Characters 4
Data Type nvarchar or varchar 13

Back
Top