MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Walter Tross Date:March 25 2012 9:26pm
Subject:Re: big character constant
View as plain text  
I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and U+2718 'HEAVY
BALLOT X' ( and
Unicode has several encodings, of which the most used are UTF-8 and UTF-16.
The answer to your question depends on the encoding of your column and on your interface
to the database.
As an example, IF your encoding is UTF-8 and you talk to the database using PHP, you need
something like:
$qry = mysql_query("insert into mytable (mycolumn) values ('\xE2\x9C\x94'),
Inside double quotes PHP replaces the hex escape sequences with the bytes that form the
correct UTF-8 encoding of your characters (see the above web pages).

At 19.14 23/03/2012 -0500, Halász Sándor wrote:
>How does one enter characters U02714 and U02718 in a query? or insert them into a
> record?
>MySQL General Mailing List
>For list archives:
>To unsubscribe:

big character constant(Halász Sándor)24 Mar
  • Re: big character constantDavid Turner25 Mar
  • Re: big character constantWalter Tross25 Mar
    • Re: big character constant(Halász Sándor)26 Mar
      • Re: big character constantJohan De Meersman27 Mar
        • Re: big character constant(Halász Sándor)28 Mar
Re: big character constant(Halász Sándor)27 Mar
  • Re: big character constantTodd Lyons27 Mar
    • Re: big character constant(Halász Sándor)28 Mar
      • Re: big character constantNuno Tavares28 Mar
        • Re: big character constantTodd Lyons28 Mar