Chinese Yellow Pages | Classifieds | Knowledge | Tax | IME

Category: database

About database

MySQL Binary field how to insert, search

http://www.ovaistariq.net/632/understanding-mysql-binary-and-non-binary-string-data-types/ http://artarmstrong.com/blog/2014/12/07/store-uuid-as-binary16-mysql-data-type/ http://stackoverflow.com/questions/9081216/mysql-insert-statement-to-binary-datatype e.g: CREATE TABLE `Test` ( `myhash` binary(16) DEFAULT NULL ) Insert 10E8400E29B11D4A716446655440000 as HEX representation of some chars Insert into `Test` values ( UNHEX(“110E8400E29B11D4A716446655440000”) ); MySQL standard…