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' (http://www.fileformat.info/info/unicode/char/2714/index.htm and
http://www.fileformat.info/info/unicode/char/2718/index.htm).
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'),
('\xE2\x9C\x98')");
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).
ciao
Walter

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: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql

Thread
big character constanthsv24 Mar
  • Re: big character constantDavid Turner25 Mar
  • Re: big character constantWalter Tross25 Mar
    • Re: big character constanthsv26 Mar
      • Re: big character constantJohan De Meersman27 Mar
        • Re: big character constanthsv28 Mar
Re: big character constanthsv27 Mar
  • Re: big character constantTodd Lyons27 Mar
    • Re: big character constanthsv28 Mar
      • Re: big character constantNuno Tavares28 Mar
        • Re: big character constantTodd Lyons28 Mar