首先问题来源于这里:
http://stackoverflow.com/questions/2032239/binary-data-in-mysql/13511985#13511985
可能并没有完全解决问题,但至少是个解决方案
mysql表字段设置为int 或者bigint,那么这个字段至少有31位/63位可以用来表示不同的需求
下面是回复内容
Hope, this code can help you:
for select:
select conv(column_name, from_base, to_base) from table_name
//example:
select conv(column1, 10, 2) from table1;
for insert:
insert into table_name(column1) values( B'binary_data') ;
//example :
insert into table1(column1) values( B'1110000');
for query:
select column1,column2 from table_name where column1 & B('binary_data');
//example:
select column1, column2 from table1 where column1 & B('1110000');