Re: big character constant

[(Hal]

>>>> 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.