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
