MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such … 
I would also like to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5… is quite inconvenient to deal with strings like that in MySQL. Either you store them as strings and waste space or you…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
Post: Data Recovery Toolkit for InnoDB Version 0.1 Released
November 26, 2007 By 6 Comments
… recover data even when processed InnoDB page has been reassigned to another table and/or was partially destroyed Supports all MySQL data types except BLOBs, SETs and BITs (will be implemented in next releases) Has really great set of data filters to define data ranges (for numbers), field lengths (for variable length fields), character sets (for strings), date periods…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… text to mediumtext. This approach can result in modified data types and silent data truncation, which makes it unacceptable for our purposes. Approach… it is feature complete. Outstanding issues include: – Proper handling of string foreign keys (currently fails, but you probably shouldn’t be…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… data transfer – query was sent as text and result returned back as text. For example number 123 would be sent as string… to the strings on server side and back on the client side, which is pretty expensive especially for certain data types. Furthermore BLOBs…+ performance improvements when really large amounts of data needed to be retrieved from localhost – data conversion can really take most of the…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
October 31, 2009 By 50 Comments
… does, however, use the minimal data types required to store information. – MonetDB automatically builds a dictionary system for strings string heaps = 64KB are opportunistically… comes from the logical references (8bytes) into the dictionary(short strings) – Q7 would be a target for us to run with…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… week but the features are there. When it comes to data types – Redis supports simple key-value storage just as memcache but… to the linked list data type you would have as well as sets which allow to store sets of strings with support of various set operations. I kind of miss support for something like associative array/hash/map in the data types…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… will use key compression for character column type but not for numerical and other column types. Also according to my tests it… testing 4 types of queries: select count(*) from t1, t1 t2 where t1.c=t2.c – simple join by string column select… on the string index. It is interesting to see PACK_KEYS=0 does not always improve performance even if data fits in…
Post: Integers in PHP, running with scissors, and portability
March 27, 2007 By 32 Comments
… function called unpack() which essentially allows to convert different types of data from binary strings to PHP variables. What if you try to… large unsigned 32bit numbers would be converted to float, or string, or something, but handled properly. However, a couple or so… binary stream, you have to: convert it to float or string manually, do that depending on int size on current platform…
Post: Picking datatype for STATUS fields
August 9, 2008 By 24 Comments
…can be used lets talk about two important types of these status fields. First is BOOLEAN …- not according to their string values. So make sure to add values specify strings for ENUM in sorted…you plan to extend statuses with further meta data, for example descriptive help message, information when …
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…? In fact we can – by using CHAR(0) type (without NOT NULL flag) – this will be pretty…store one of two values – NULL or Empty String. Lets see how these 3 different table format… Avg_row_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data_free: 0 Auto_increment:…
