MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:(Hal Date:March 28 2012 2:43am
Subject:Re: big character constant
View as plain text  
>>>> 2012/03/27 11:20 -0700, Todd Lyons >>>>
This seems backwards from what I expected:

mysql> select convert(0xE29C94 using latin1), convert(0xE29C94 using utf8) \G
*************************** 1. row ***************************
convert(0xE29C94 using latin1):   convert(0xE29C94 using utf8): ?
1 row in set (0.00 sec)

I expected the second one to print the check mark and the first one to
have the problem because there is no heavy check mark in latin1.  What
am I missing, why is it printing out the correct value "using latin1"
but not "using utf8" ?
Correct value? It does not look correct in this message--but maybe you are using a display
that understands UTF8.

The output of
convert(0xE29C94 using latin1)
through the client is three bytes long, sent in order from high to low, and if your
display does UTF8 the check will show, and the ASCII box drawing, which with "\G" is not
used, will not line up. Try it after both
charset latin1
charset utf8

big character constant(Halász Sándor)24 Mar
  • Re: big character constantDavid Turner25 Mar
  • Re: big character constantWalter Tross25 Mar
    • Re: big character constant(Halász Sándor)26 Mar
      • Re: big character constantJohan De Meersman27 Mar
        • Re: big character constant(Halász Sándor)28 Mar
Re: big character constant(Halász Sándor)27 Mar
  • Re: big character constantTodd Lyons27 Mar
    • Re: big character constant(Halász Sándor)28 Mar
      • Re: big character constantNuno Tavares28 Mar
        • Re: big character constantTodd Lyons28 Mar