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 Member Posts: 6
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 Member Posts: 197
    : 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.