July 4, 2008 at 12:52 am
hi,
I have a problem storing Chinese text in an sql server express 2005
database which runs on a western version of XP.
There is no binding in my app. The data is typed in a user form and
in a button_click event stored in a table using the command object
of the sqlclient, executing sql statements like insert or update.
Everything's fine, except that Chinese text will not be stored in
the tables correctly, instead of the characters I only get question
marks.
In the sql server express managing tool, I am not able to type in
Chinese characters into the fields directly either, but I am able to
copy and paste them there. That way the Chinese characters are being
stored well in the db.
That's why I am thinking, the sql server is able to store Chinese
characters, the GUI of my app is able to display Chinese charaters
as well, only within the storing process using sqlclient something
is going wrong.
Can anybody help me here. Actually I am quite disappointed, I
thought these kind of problems belong to the past, when early access
db showed similar behavior.
Thanks for your help
July 5, 2008 at 3:30 am
I am guessing issues with the datatype of the field.
In the insert or update statements when you are updating this particular text column let it be a nvarchar column and also in the insert/update statements of the stored procedures type N'text'
Let me know if you still have issues as i solved this issue couple of months back in one of my projects...
July 6, 2008 at 11:33 pm
Thank you for your reply.
i follow your suggestion, now its working fine....
Thanks & Regards
Tamil
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply