Groups | Blog | Home
all groups > dotnet ado.net > september 2007 >

dotnet ado.net : Unicode with SQL Server


Hamilton Colyer-Long
9/29/2007 9:51:27 PM
Hi all,

I have a TableAdapter with a connection to an SQL Server database that uses
stored procedures to insert and update records. Problems occur when I
attempt to insert unicode (Chinese) characters in the database; all that
comes through is question marks. The parameter to insert the string with
Chinese characters uses DBType "String". This works fine with Jet (Access)
but fails for SQL Server. I've tried all the obvious DBTypes but nothing
works with SQL Server. Has anyone experienced this before?

Regards,
Hamilton Colyer-Long

Janusys
www.janusys.com.au

Hamilton Colyer-Long
9/29/2007 10:32:28 PM
Fixed now.
Solution: Have you tried turning it off then on again?

AddThis Social Bookmark Button