Unicode with SQL Server

microsoft.public.dotnet.framework.adonet

29 Sep 2007 1:51 PM

Hamilton Colyer-Long

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

29 Sep 2007 2:32 PM

Hamilton Colyer-Long

Fixed now.
Solution: Have you tried turning it off then on again?