Professional Web Applications Themes

Strange characters in MYSQL? - MySQL

The following string: "US generals ‘will quit’ if Bush orders Iran attack" is being stored in my table as: "US generals ‘will quit’ if Bushorders Iran attack" The only PHP function I'm applying to the string is mysql_real_escape_string, and that doesn't appear to be the root of the problem. I'm using utf8_general_ci as my collation. Forgive my ignorance....

  1. #1

    Default Strange characters in MYSQL?

    The following string:
    "US generals ‘will quit’ if Bush orders Iran attack"

    is being stored in my table as:

    "US generals ‘will quit’ if Bushorders Iran attack"

    The only PHP function I'm applying to the string is
    mysql_real_escape_string, and that doesn't appear to be the root of
    the problem. I'm using utf8_general_ci as my collation.

    Forgive my ignorance.

    matthud@gmail.com Guest

  2. #2

    Default Re: Strange characters in MYSQL?

    com wrote: 

    Thats how an UTF-8 string looks like when displayed with ISO8859-1.

    --

    //Aho
    J.O. Guest

  3. #3

    Default Re: Strange characters in MYSQL?

    > "US generals ‘will quit’ if Bush orders Iran attack" 

    If you view the page in your browser, check if the browser selects utf-8
    ("view" menu under IE and firefox). If not, then you can either convert
    the string (using the mb_string functions, for instance), or use utf-8
    in both php and MySQL. You can set the encoding in PHP.INI. In MySQL,
    check the output of:
    SHOW VARIABLES LIKE 'char%'

    Best regards
    Dikkie Guest

Similar Threads

  1. CFMAIL - HTML and HOTMAIL - Strange Characters
    By A.J.cfm in forum Macromedia ColdFusion
    Replies: 2
    Last Post: August 2nd, 09:17 AM
  2. certain characters being replaced with strange symbolson INSERT
    By 6ftandglassy in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: July 28th, 03:58 PM
  3. MySQL characters
    By FmC in forum PHP Development
    Replies: 2
    Last Post: July 18th, 12:56 PM
  4. Strange characters
    By Chetak Sasalu in forum PERL Beginners
    Replies: 12
    Last Post: November 24th, 08:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139