Problem when save unicode to NVARCHAR field... - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Problem when save unicode to NVARCHAR field...

vndpvndp Posts: 6Member
I use this C# codes to save unicode text into NVARCHAR field (SQL SERVER 2005 EXPRESS):

[b] DataRow row;
row = cData.DatTable.Rows[i];

row.BeginEdit();

row["CompanyName"] = txtCompanyName.Text;
//...

row.EndEdit();

cData.DatAdaptor.Update(cData.DatSet, TableSelect);
cData.DatSet.AcceptChanges();[/b]

When I input some unicode text into txtCompanyName,
it is save SQL SERVER like that: "B?n ph?i nang d?ng"

How can I solve this problem?
Thanks for reading!

Comments

  • bradwangbradwang Posts: 197Member
    : I use this C# codes to save unicode text into NVARCHAR field (SQL
    : SERVER 2005 EXPRESS):
    :
    : [b] DataRow row;
    : row = cData.DatTable.Rows[i];
    :
    : row.BeginEdit();
    :
    : row["CompanyName"] = txtCompanyName.Text;
    : //...
    :
    : row.EndEdit();
    :
    : cData.DatAdaptor.Update(cData.DatSet, TableSelect);
    : cData.DatSet.AcceptChanges();[/b]
    :
    : When I input some unicode text into txtCompanyName,
    : it is save SQL SERVER like that: "B?n ph?i nang d?ng"
    :
    : How can I solve this problem?
    : Thanks for reading!


    Did you specify the column data type in your code? And if so, what is it?



    Brad Wang
    .NET Freelancer from China
Sign In or Register to comment.