Spanish character issue

Discussion in 'PHP' started by chanakya, Sep 6, 2008.

  1. #1
    Guys , I recently developed a site, Whose backend was completely managed by a cms.

    http://www dot tarjetas-animadas dot com/

    Now the site is not showing spanish accent characters , I tried setting meta header <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

    and putting a header in php file for this charset, None working :(

    Any pointers... ?
     
    chanakya, Sep 6, 2008 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    These characters can be a pain. If playing with the charset didn't work, try converting them to HTML entities. You won't have problems with these...
     
    nico_swd, Sep 7, 2008 IP
  3. giorgioarmani

    giorgioarmani Well-Known Member

    Messages:
    2,634
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    160
    #3
    giorgioarmani, Sep 7, 2008 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Use the following query after making connection to database
    mysql_query("SET character_set_results = NULL");
    Code (markup):
     
    mwasif, Sep 7, 2008 IP
  5. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #5
    I have only tested this when selecting data from MySQL. Test it for data insertion.
     
    mwasif, Sep 7, 2008 IP
  6. chanakya

    chanakya Peon

    Messages:
    361
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Plain html entities are working fine , problem is when there is some dynamic data either from rss or from mysql
     
    chanakya, Sep 7, 2008 IP
  7. chanakya

    chanakya Peon

    Messages:
    361
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Will try thanks
     
    chanakya, Sep 7, 2008 IP
  8. giorgioarmani

    giorgioarmani Well-Known Member

    Messages:
    2,634
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    160
    #8
    Ok that sounds interesting... How do I "make" that query?
     
    giorgioarmani, Sep 7, 2008 IP
  9. chanakya

    chanakya Peon

    Messages:
    361
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    No effects :(, I doubt that has to do anything with mysql, because i am getting same issues with the rss feeds , :(
     
    chanakya, Sep 8, 2008 IP
  10. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #10
    nico_swd, Sep 9, 2008 IP
  11. krampus

    krampus Active Member

    Messages:
    29
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    88
    #11
    ok, why don't you try with UTF8 page coding. Put on charset UTF-8 and that PHP page should be also saved as UTF-8 document. Then it should be fine.
     
    krampus, Sep 9, 2008 IP