Saving ANSI Character into SQL Server's varchar field

[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

[Cor]

Hi Norton,

One of the things that will led to the solution in my idea is asking this
too in a more specialized newsgroup.

One of them is
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

However because you only want the Varchar format, maybe you can ask it too
in a newsgroup more specialized in SQL server

I hope you get your results?

Cor

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 ?

[Cor]

Hi Norton,

One of the things that will led to the solution in my idea is asking this
too in a more specialized newsgroup.

One of them is
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

However because you only want the Varchar format, maybe you can ask it too
in a newsgroup more specialized in SQL server

I hope you get your results?

Cor

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 ?

[Norton]

o......sorry for cross posting

Thx for your help
"Cor" <no*@non.com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...

Hi Norton,

One of the things that will led to the solution in my idea is asking this
too in a more specialized newsgroup.

One of them is
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof t.public.dotnet.framework.adonet>

However because you only want the Varchar format, maybe you can ask it too
in a newsgroup more specialized in SQL server

I hope you get your results?

Cor

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 ?

[Norton]

o......sorry for cross posting

Thx for your help
"Cor" <no*@non.com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...

Hi Norton,

One of the things that will led to the solution in my idea is asking this
too in a more specialized newsgroup.

One of them is
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof t.public.dotnet.framework.adonet>

However because you only want the Varchar format, maybe you can ask it too
in a newsgroup more specialized in SQL server

I hope you get your results?

Cor

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 ?