From: Todd Lyons
Date: March 28 2012 3:00pm
Subject: Re: big character constant
List-Archive: http://lists.mysql.com/mysql/227071
Message-Id: <CAFG21ojv6L99K7atK_Ruiwd-=4g4-tJaw7WkQ9JOyX_NHQ0T=g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 28, 2012 at 1:47 AM, Nuno Tavares <nuno.tavares@stripped> wrote:
> Hal=C3=A1sz, not sure if I understood correcly, but you "mysql" console/c=
lient
> may have different charsets. This means you should set it accordingly. Ch=
eck

Good catch, I had not considered that.

> mysql> set names utf8;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> select convert(0xE29C94 using latin1), convert(0xE29C94 using utf8=
)
> \G
> *************************** 1. row ***************************
> convert(0xE29C94 using latin1): =C3=A2=C5=93=E2=80=9D
>
> =C2=A0convert(0xE29C94 using utf8): =E2=9C=94
> 1 row in set (0.00 sec)

And THAT was what I expected.  Thank you so much for clearing that up.

...Todd
--=20
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding