Converting char(36) to binary

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Converting char(36) to binary

Post 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!
jegan.aaodis
Forum Newbie
Posts: 15
Joined: Fri Oct 09, 2009 1:56 am

Re: Converting char(36) to binary

Post by jegan.aaodis »

Hi GeXus,

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

Thanks
Post Reply