MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I think it… 
I would also like to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5… would allow to avoid having COMPRESS()/UNCOMPRESS() everywhere which clobbers things or compressing/uncompressing on the client. It would be best…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
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… official way to know what’s int size. To make things even better, 5.2.1 introduced a nice bug in… that part perfectly. However, designers of PHP 5 (released in 2004) type system were either not aware of this change, or decided to…
Post: Picking datatype for STATUS fields
August 9, 2008 By 24 Comments
… later. Perhaps worst, though quite common thing is to define such field as VARCHAR(255…of variants which can be used lets talk about two important types of these status fields. First is BOOLEAN or YES/NO type…not according to their string values. So make sure to add values specify strings for ENUM …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… let me walk you through the installation and configuration because things changed along the way. Installation In order to use the… allowed in a comma-separated string. [microtime, query_plan, innodb] msl patch currently can log three types of information: query timings, execution plan…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 25 Comments
… different thing – conversion from string. First of all, I don’t see any strings there. I can see a float converted to a string in… third thing: even though PHP tries to handle this in a crossplatform way (because it uses its own float-to-string and string…, surely “designers of PHP 5 (released in 2004) type system were either not aware of” long long. As well as designers of MySQL (released…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
…team not only many of these things remain unfixed but things are still done similar way…string and integer values, which would allow to preserve compatibility. Look for example on query_cache_type…”, “consecutive” and “interleaved” ? Using string values would make things much more friendly with my….
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… I would like to see couple of things here. To have kind of middle point insertion so full table…that from any blob/string in the page. Which gives you the nice surprise of row being …it otherwise with raise of MultiCores Innodb will become unusable for more and more types of workloads What would…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
…the byte-size of values, not the character-size. This means if you insert a 500 character string with …a lot of places. How much you can win with this approach depends a lot on the type of data …read/write more data at once, while one of the interesting things about overflow blob storage is that if …
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… *************************** 2. row *************************** id: 1 select_type: SIMPLE table: t2 type: ref possible_keys: j key: j… decided to check if using longer strings slows down things significantly and so I replaced … range from few percent to couple of times for Innodb tables MyISAM Tables …
Comment: Be careful when joining on CONCAT
October 17, 2007 By 10 Comments
… more thing about it – generally this choice of making Number a binary string is counter intuitive to me. The number is a string and… CONCAT to simply handle numbers by converting them to the type of other argument. Though I do not know may be this…
