What DBType supports unicode with SQL Server

  • Thread starter Hamilton Colyer-Long
  • 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unicode with SQL Server 1
Excel OLEDB reading Chinese characters unicode problem 1
Beginning .Net : Insert data into SQL Server Database with C#Examples and VB.Net Examples 2
Problem with UNICODE 1
about sql server 1
problem with displaying Unicode strings 1
Unicode Data into a PostgreSQL DB? 3
connection with Sql Server 5

Top