character encoding pound signs

character encoding pound signs

by dan attwood -
Number of replies: 4

Hi

I have an issue where when some records are saved in the database £ and , are encoded incorrectly and show as black diamonds with a question mark in them.

I have checked the tables they are saving into and they are utf8-default

 

Any ideas please what could be causing this?

 

 

 

Average of ratings: -
In reply to dan attwood

Re: character encoding pound signs

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

It sounds like the data you tried to store in the DB was not UTF-8.

Average of ratings: -
In reply to dan attwood

Re: character encoding pound signs

by Guillermo Madero -

Hi Dan,

If you have checked and are sure that they are correctly saved in the db, then the problem is in the page where they are being displayed. Check the encoding of the web page, you should be have something like this almost at the beginning:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

Average of ratings: -
In reply to Guillermo Madero

Re: character encoding pound signs

by dan attwood -

just double checked that it's set right.

I'm to try and rerun the conversion to utf8 at the weekend as per http://docs.moodle.org/23/en/Converting_your_MySQL_database_to_UTF8 to see if that picks up anything.

Average of ratings: -