Unicode with SQL Server

  • Thread starter Thread starter Hamilton Colyer-Long
  • Start date Start date
H

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
 
Back
Top