PDA

View Full Version : Apostrophe viewed as ? in a diamond

vanroojdotcom
04-25-2009, 01:50 PM
Hi there

A client is pasting his articles into iRite everything works fine but the Apostrophe is shown as a 'question mark in a diamond' in my mac browser and as a 'question mark' in his PC.

I have looked at the database in phpMyadmin and the Apostrophe is there looking fine, so it's going into the database OK but is being echoed wrong.

Any ideas?
vanrooj
Sades
04-25-2009, 05:10 PM
check you pages settings, the ones that add and edit and also the one that shows the data, also check what collision your tables in the database are set.

Why this for special characters example Spanish you need to use on the beginning of the page these lines of codes

<html xmlns="http://www.w3.org/1999/xhtml" xmlns:wdg="http://ns.adobe.com/addt">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

the colored line is the most important for special characters i use that one or the charset = UTF-8

Also check your database it should tell you what type of characters its using.

Example if your database settings are latin1_general_ci or latin1_german_ci or latin1_spanish_ci or any other latin settings you need to use on the top of your page charset=iso-8859-1, if its utf then u have to use utf-8 and so on depending on your lengauje.

Hope this helps :)
vanroojdotcom
04-26-2009, 06:42 AM
Yes that helped a lot, thanks for that answer. Absolutely correct.

~ this was the setting I needed:
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

~ changed from:
charset = UTF-8


many thanks
vanrooj