From: Roland Kaber [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 11:24 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Erro 1406 Data too long
It looks like it is really a character set conflict. The copyright character ©
is ascii 169 and is part of latin-1
In the INSERT, I used the CHAR function, rather than the ASCII, sorry
for the mistake.
Thanks again
Roland
Roland Kaber wrote:
It looks like it is really a character set conflict. The copyright
character © is ascii 169 and is part of latin-1. However, there is a
similar character, (C) the cir
It looks like it is really a character set conflict. The copyright
character © is ascii 169 and is part of latin-1. However, there is a
similar character, (C) the circled latin capital letter c which is not
in the latin-1 character set. I have found two solutions:
1. setting the column's cha
It is a character set conflict between the source of the data and the
column. I run into this all of the time when using the CLI. Programmatically
it can be avoided.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 /
