Having problem with quote sign.. need help

Discussion in 'PHP' started by LOD, Nov 11, 2009.

  1. #1
    does any of u know the significant or the difference between
    '
    ’
    both of the upper quote sign is found using quote sign but on different program. on word if u type quote u will get the second sign. but on notepad or even here on this textbox that i'm writing on, u will find the first quote sign... i want to know the difference between them...
    everytime im calling a record from mysql by php if the data contains the second quote sign im getting '?' question mark instead of the quote sign...:confused:
    how can i solve this problem using php??
    is it a problem with mysql or with php??
     
    LOD, Nov 11, 2009 IP
  2. travelmoth

    travelmoth Active Member

    Messages:
    153
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    the first is single quote sign.........and the 2nd is NOT...........
     
    travelmoth, Nov 11, 2009 IP
  3. LOD

    LOD Member

    Messages:
    319
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    35
    #3
    for everyones better understanding here is the link of a post. where it shows the same problem that im facing..
    http://stackoverflow.com/questions/836397/php-mysql-encoding-bug
    but i dont understand their solution at all...
    could someone please help me with it...
    btw i'm already using
    <meta http-equiv="Content-type" value="text/html; charset=utf-8">
    so else can i do to make it work??
    i've also tried
    mysql_set_charset('utf8',$link);
    but that doesnt seem to work as well...
    any bright ideas???
     
    LOD, Nov 11, 2009 IP
  4. xenon2010

    xenon2010 Peon

    Messages:
    237
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    convert the table which has the records

    ALTER TABLE `example` DEFAULT CHARSET=utf8
    PHP:
     
    xenon2010, Nov 11, 2009 IP