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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
