Page 1 of 1

Converting char(36) to binary

Posted: Tue Oct 20, 2009 10:17 am
by GeXus
I want to convert a column from char(36) to binary... from what I've read binary(16) should be what I want, however when I change to binary(16) the data get's truncated, it only works if I use binary(36), but then what's the point?

Any ideas?

Thanks!

Re: Converting char(36) to binary

Posted: Wed Oct 21, 2009 12:14 am
by jegan.aaodis
Hi GeXus,

Please see this link,
http://www.mysqlperformanceblog.com/200 ... cter-sets/

Thanks