Problem with character entities in HTML_AREA...

We are using Servoy to edit a PHP-based website. The database is in MySQL 4. We’d like to display proper curly quotes in our HTML pages,

If we type in ASCII characters 182 and 183, they display fine in our HTML preview area, but show up as small boxes in the webpage.

If we use ‘ and ‘ entites they display fine in the webpage, but our HTML preview area displays “&lsquo” and “&rsquo”…

Any way around this?

Mac OS X 10.3.3, Servoy 2.0

performance_downgrade.zip (712 Bytes)

can mysql 4 already handly pure unicode?
Then you should try to use that. Because then you have never those kind of conversion problems.

What johan is saying you could alter your html doc type to support unicode,
another option is to try ```
& # 182 ; without the spaces to prevent forum to show only result :slight_smile:

Jan Blok:
try ```
& # 182 ; without the spaces to prevent forum to show only result :slight_smile:

Sorry, I didn’t realise before I ready your reply that my example entities had been replaced…

What you suggest works fine, but the codes are different: I found the following reference for the entities to use:

So my quotes become & # 8216; and & # 8217; They now display correctly in both the HTML_AREA and in the webpage.