Characters unrecognized in database

[hb]

How do I prevent an apostrophe or double quote copied from Word and pasted
into a textbox on my webform from being converted to upside down question
marks in my database?

I set the content type of the page with
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
- but this doesn't help.

 

[Cliff Harris]

While I'm not sure if it's possible to prevent those characters from being
sent to the server, I did a quick check and found that the codes for those
characters were:
single quote: 8216
double quote: 8221
while the ones you want are:
single quote: 39
double quote: 34

so, I would just go ahead and do a replace one the string I got back from
the user:

TextBox1.Text = TextBox1.Text.Replace((char)8216, (char)39);
TextBox1.Text = TextBox1.Text.Replace((char)8221, (char)34);

HTH,
-Cliff

 

[Cliff Harris]

forgot:
remember that if you are using an insert statement within your C#, you need
to replace single quote with two of them:

TextBox1.Text = TextBox1.Replace("'", "''");

-Cliff

 

[hb]

Good info. How can I look up these codes myself? Your example got me
going, but it doesn't catch the opening double quotes (does get the closing
ones, though).

 

[hb]

Nevermind, I found a good article
http://en.wikipedia.org/wiki/Quotation_mark

 

[Cliff Harris]

Nice find with the article... I'll have to keep a bookmark to that..

-Cliff