>>>> 2012/03/27 00:22 +0200, Walter Tross >>>> it looks like it's as simple as this: insert into mytable (mycolumn) values (0xE29C94), (0xE29C98) In some contexts it might be necessary to force the character set like this, though: convert(0xE29C94 using utf8) <<<<<<<< Yes! and with this I can use it for a constant in the middle of a query, which I really want:
IF(IFNULL(ReceivesFlyer, 1), CONVERT(X'E29C94' USING utf8), '') . (I use the old PL1 constructs over the new C-constructs when they work alike.) Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
