Special Characters

Hello,

I am having problems with dataassist not showing my special characters. I have attached an example. (C), (TM), & (R) symbols do not show up properly.

Any suggestions?

Originally Said By: garry.wilmeth268291

  Hello,

I am having problems with dataassist not showing my special characters. I have attached an example. (C), (TM), & (R) symbols do not show up properly.

Any suggestions?  

The code that DataAssist generates simply outputs the content from the database. If the characters output are not correct, then they are likely incorrect in the database columns. How were those rows entered into the database? Did they happen to come from copy and paste from Word, or some other external program?

If they came from Word, then it sometimes uses characters that do not translate well into HTML characters.

Do you have access to database content directly from the database to see what characters are actually being stored in the database?

Another possibility is that your charset settings for either the page where you inserted the data or where you are displaying it does not support that character.

See if you have a chartype definition like:
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">

on both or either of the pages. Try adding one if you don't or try using UTF-8 if another charset is specified.

Originally Said By: Ray Borduin

  Another possibility is that your charset settings for either the page where you inserted the data or where you are displaying it does not support that character.

See if you have a chartype definition like:
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">

on both or either of the pages. Try adding one if you don't or try using UTF-8 if another charset is specified.  

UTF-8 was specified, and wasn't working. It works if I use the following:

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />