Re: character encoding

[Warren Young]

Karima Velasquez wrote:
> i know about the null terminating character, but i don't think this is the 
> problem. 

It might not be your immediate problem, but you will run into it eventually.

> rigth data: <82>
> wrong data: 
> 
> rigth data: ^
> wrong data: 

That should only happen if your column is set as a non-binary type, 
which is a bad idea, for the reasons I've pointed out already. 
Character set conversions do not affect binary columns.  See:

http://dev.mysql.com/doc/mysql/en/blob.html