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