newbie in C# 2003, saving Asian characters to database problem

  • Thread starter Thread starter HibernatingBear
  • Start date Start date
H

HibernatingBear

Hope I'm posting in the right place. Have spent more hours than i
would like on this problem and still have not solved it. I'm using
SQL Server for the db.

I have a GUI application with 2 multi-line textboxes that can be
populated with Asian characters. I can't get the Asian characters to
save to the database. (Bizarrely enough, when I manually saved a few
Asian characters in the database table, they displayed on the GUI with
no problems, and without using extra code, either. Thought I could do
a Save without problems, but got "???")


In trying to Save, I've initialized and used StreamReader with the
"using System.IO" namespace. That didn't work, seems the application
went looking for a file with the character name. Also tried an Int32
conversion(?) for the textbox, which turned it into a byte array.

Can anyone point me in the right direction? Hints? Anything?

Thanks in advance.
 
HibernatingBear said:
Hope I'm posting in the right place. Have spent more hours than i
would like on this problem and still have not solved it. I'm using
SQL Server for the db.

I have a GUI application with 2 multi-line textboxes that can be
populated with Asian characters. I can't get the Asian characters to
save to the database. (Bizarrely enough, when I manually saved a few
Asian characters in the database table, they displayed on the GUI with
no problems, and without using extra code, either. Thought I could do
a Save without problems, but got "???")
Click to expand...

See http://pobox.com/~skeet/csharp/debuggingunicode.html
 
Hope I'm posting in the right place. Have spent more hours than i
would like on this problem and still have not solved it. I'm using
SQL Server for the db.

I have a GUI application with 2 multi-line textboxes that can be
populated with Asian characters. I can't get the Asian characters to
save to the database. (Bizarrely enough, when I manually saved a few
Asian characters in the database table, they displayed on the GUI with
no problems, and without using extra code, either. Thought I could do
a Save without problems, but got "???")

In trying to Save, I've initialized and used StreamReader with the
"using System.IO" namespace. That didn't work, seems the application
went looking for a file with the character name. Also tried an Int32
conversion(?) for the textbox, which turned it into a byte array.

Can anyone point me in the right direction? Hints? Anything?

Thanks in advance.
Click to expand...

You should look at the encoding that the StreamWriter is using. Some
encodings like ASCII will drop asian characters because they are
larger than 16-bit. As far as I know UTF-8 should not drop characters.
 
You should look at the encoding that the StreamWriter is using. Some
encodings like ASCII will drop asian characters because they are
larger than 16-bit. As far as I know UTF-8 should not drop characters.- Hide quoted text -

- Show quoted text -
Click to expand...

Thought asian chars required at least 16-bit? Had the same problem
with 16-bit, anyway. Application won't do System.Convert.ToInt8,
unfortunately.

Will take a look at Jon Skeet's link above.

Thanks to both of you!
 
HibernatingBear said:
Thought asian chars required at least 16-bit? Had the same problem
with 16-bit, anyway. Application won't do System.Convert.ToInt8,
unfortunately.
Click to expand...

You shouldn't need to use any type of Convert.ToIntXXX.

Just keep everything as text, and it should be okay.
 
Changed from converting to bytes to using the following sql string to
insert text, and I'm still getting the "???"

string sql = "INSERT INTO MyTable"
+ " (Comment1)"
+ " VALUES (" txtComment.Text + "')";

It works fine for English. At this point, I'm just plain out of
ideas. On another bulletin board, found one guy who had a similar
problem, but the helper chose to delete his solution -- the post was
dated 2002, but looked like it would've helped if it was left up.
 
HibernatingBear said:
Changed from converting to bytes to using the following sql string to
insert text, and I'm still getting the "???"

string sql = "INSERT INTO MyTable"
+ " (Comment1)"
+ " VALUES (" txtComment.Text + "')";

It works fine for English. At this point, I'm just plain out of
ideas. On another bulletin board, found one guy who had a similar
problem, but the helper chose to delete his solution -- the post was
dated 2002, but looked like it would've helped if it was left up.
Click to expand...

Don't put the parameter in the command directly in the SQL like that -
use a parameterised command. That may well help.
 
Sorry to say, it didn't. :(

string strComment = this.txtComment.Text;
string sql = "INSERT INTO MyTable"
+ " (Comment1)"
+ " VALUES ("strComment+ "')";
 
HibernatingBear said:
Sorry to say, it didn't. :(

string strComment = this.txtComment.Text;
string sql = "INSERT INTO MyTable"
+ " (Comment1)"
+ " VALUES ("strComment+ "')";
Click to expand...

Um, that's still not a parameterised command.

I mean using a SqlCommand and its Parameters property.
 
Back
Top