Strange mysql - php problem

Discussion in 'PHP' started by CommuniTriper, Dec 11, 2008.

  1. #1
    I have a table with a some fields including a boolean, when I query from PHP and try to work with the data, everything's fine, except for the booleans, they don't response (for example if (!$boolean) echo "false";)

    When I print_r the $row, I can clearly see that all the fields are fine but the booleans - they show strange characters one for true and one for false.

    I hope they get through here:  and �

    My database is set to latin1 - latin1_swedish_ci.

    tried changing the connection to UTF, didn't matter...

    What am I missing?
     
    CommuniTriper, Dec 11, 2008 IP
  2. misbah

    misbah Active Member

    Messages:
    265
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    68
    #2
    boolean type using tinyint
     
    misbah, Dec 11, 2008 IP
  3. CommuniTriper

    CommuniTriper Peon

    Messages:
    52
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks it worked, is it a known problem? I would still like to resolve it other than walking around the problem..
     
    CommuniTriper, Dec 12, 2008 IP