Character translation issue

[kensington43]

I have had major issues in the last two years with my Access 2000 database back end to my Front end Cold Fusion. Whenever someone copies Microsoft Word document information with quotes or apostrophes into my Web Form it translates to squares in the Access 2000 database. I understand I need to translate or eliminate the Microsoft Quotes or Apostrophes but cant seem to find what Ascii character number to use??

Chr(146) is " but doesnt seem to match Microsoft Words quotes
I also tried for loop and on Chr(128) to Chr(160) and still cant get rid of the Microsoft quotes or apostophes before they enter my database!

Please advise because I want to eliminate these weird characters before they get to my database but what are the correct Ascii numbers???

 

[Blorf]

Hi.

Just off memory, 34 is ", not 146. the ' is 39.

When I need to know what the ascii value of something is, what I usually do (and I know there are easier ways), I use Excel, make a column of numbers, 1 - 255, and use the excel function "Char" on those numbers, to see what each one is. Further, if you use excel and enter =Code("'"), it will give you the ascii value of ' or 39.

I hope this helps,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[kensington43]

I tried Chr(39) and it didnt work.

It work with Chr(28) which equals Microsofts Copy of Forward quotes And Chr(29) which equals Microsofts Copy of Backward quotes for translating Ascii on my Cold Fusion front end.

When I substituted my values for the those Ascii values it got rid of the weird characters.

Although the Ascii chart on msdn shows these values as not having any value.

Confused but it works for me. Was wondering if someone can explain why it works with those Ascii values??