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
 
Back
Top