List:General Discussion« Previous MessageNext Message »
From:(Hal Date:March 27 2012 1:54pm
Subject:Re: big character constant
View as plain text  
>>>> 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.

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