Jump to content


Strange Character

  • Please log in to reply
1 reply to this topic

#1 energylevel



  • 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



  • Members
  • Pip
  • 1 posts

Posted 02 December 2016 - 07:29 AM



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