…` varchar(64) NOT NULL default ”, `email` varchar(64) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar(64…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
…) two varchar columns needed leading nonalpha characters trimmed, so “123 ^&* and some text” would become “and some text“, and (2) same two varchar columns…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…varchar(10) DEFAULT NULL, `TotalAddGTime` varchar(10) DEFAULT NULL, `LongestAddGTime` varchar(10) DEFAULT NULL, `DivAirportLandings` varchar(10) DEFAULT NULL, `DivReachedDest` varchar(10) DEFAULT NULL, `DivActualElapsedTime` varchar… to load text data ( I …really about InfoBright vs MonetDB comparison…
Post: Trailing spaces in MySQL
November 27, 2006 By 7 Comments
… cases. With MySQL 5.0 however things changed so now VARCHAR keeps trailing spaces while CHAR columns do not any more… if you mind trailing spaces stored choosing VARCHAR vs CHAR in addition to fixed length vs dynamic level rows and space spent for…, even if VARCHAR column is used which is pretty counterintuitive. So “a “=”a”=”a ” for all textual column types – CHAR, VARCHAR, TEXT. BLOB…
