PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Japanese support for SqlClient??

Reply

Japanese support for SqlClient??

 
Thread Tools Rate Thread
Old 30-06-2003, 09:51 AM   #1
bpm
Guest
 
Posts: n/a
Default Japanese support for SqlClient??


Hi -

Question : Does the .Net 1.1 framework SqlClient class
support commands that have been encoded in the Shift-JIS
character set?

I'm having a hell of a time getting Shift-JIS inserted into
the DB. Here's what I'm trying to do:

1. All source data is read as UTF-8 (from XML).

2. sourceData is converted from UTF-8 to Shift-JIS via the
Text.Encoding class.

3. SqlClient, SqlCommand, SqlConnection objects are
created. SqlCommand text is set from the sourceData.

4. Execute query -- the data is stored on a SQLServer2000
db in a table with the relevant text fields set as nvarchar
datatype.

Later, I'm calling the data back from Classic ASP. And
it's garbage -- not viewable as UTF-8 or Shift-JIS.

Any help would be MUCH appreciated!

-b

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off