Jump to content


Photo

Strange Character


  • Please log in to reply
1 reply to this topic

#1 energylevel

energylevel

    Member

  • Members
  • PipPip
  • 26 posts

Posted 02 December 2016 - 12:17 AM

I'm getting these strange charcaters in a DB, seems to happen with a UK currency sign is entered like this: Â£

 

Tables and DB are set to UTF-8

 

PHP Pages are set UTF-8

 

Is there something else I should check?



#2 Aadarsh

Aadarsh

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 02 December 2016 - 07:29 AM

Hi,

 

The UTF-8 character set supports the UK currency sign. If the table and database are set to UTF-8, you can try entering the data directly into tables through SQLyog and check if it converts it to Â£.

 

I guess the data is being entered from somewhere else or where it is being fetched, there is some character set mismatch. Somewhere character set is ISO-8859-1 (most probably ) . If you are fetching the data on a HTML page, then check the encoding( content type )  in the head of the page or the content type in the header which the server is sending. 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users