problem with euro sign when database info is echoed out

Discussion in 'PHP' started by saturn100, Mar 13, 2012.

  1. #1
    I have a basic webpage that calls details from a database
    The only problem is its not showing the euro sign instead it shows a diamond with a question mark inside
    I have seen this before is there any setting I need to have to fix it

    Thanks
     
    saturn100, Mar 13, 2012 IP
  2. SoftCloud

    SoftCloud Well-Known Member

    Messages:
    1,060
    Likes Received:
    28
    Best Answers:
    2
    Trophy Points:
    120
    #2
    You could specify the pages Charset - that could fix the problem. Just dump this into your META tags area.
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    Code (markup):
     
    SoftCloud, Mar 13, 2012 IP
  3. Alex Roxon

    Alex Roxon Active Member

    Messages:
    424
    Likes Received:
    11
    Best Answers:
    7
    Trophy Points:
    80
    #3
    You might also want to check the encoding of your database tables to ensure it's being stored properly.
     
    Alex Roxon, Mar 13, 2012 IP
  4. saturn100

    saturn100 Well-Known Member

    Messages:
    465
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    111
    #4
    I have that meta tag but it still doesnt work
    In the database the field is set as
    varchar(60) utf8_general_ci
     
    saturn100, Mar 14, 2012 IP