> Agreed, but you cannot every kind of data type, for that you > will probably need the various databases... and hopefully a > continuous integration server to run the tests... >
Sqldb converts databases types to the internal ftxxx datatypes. So, yes, you can everything without external databases. > But yes, you're then testing the fcl-db drivers/framework as > much as the export functionality. Not a completely bad thing. > Testing multiple layers at the same time is always dificult since interpreting errors is complex. Unit testing was invented for that purpose. > Whenever you have time, could you send me a dump of the table > definition with or without data? That would save me doing that... > No problem. Here it comes: CREATE TABLE `testodbc` ( `id` int(11) NOT NULL auto_increment, `s_int` int(11) default NULL, `u_int` int(10) unsigned default NULL, `s_tinyint` tinyint(4) default NULL, `u_tinyint` tinyint(3) unsigned default NULL, `s_smallint` smallint(6) default NULL, `u_smallint` smallint(5) unsigned default NULL, `s_mediumint` mediumint(9) default NULL, `u_mediumint` mediumint(8) unsigned default NULL, `s_bigint` bigint(20) default NULL, `u_bigint` bigint(20) unsigned default NULL, `t_float` float default NULL, `t_double` double default NULL, `t_decimal` decimal(10,4) default NULL, `t_datetime` datetime default NULL, `t_date` date default NULL, `t_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `t_time` time default NULL, `t_year` year(4) default NULL, `l_char1` char(1) character set latin1 collate latin1_general_cs default NULL, `u_char1` char(1) character set utf8 collate utf8_bin default NULL, `l_char20` char(20) character set latin1 collate latin1_general_cs default NULL, `u_char20` char(20) character set utf8 collate utf8_bin default NULL, `l_varchar10` varchar(10) character set latin1 collate latin1_general_cs default NULL, `u_varchar10` varchar(10) character set utf8 collate utf8_bin default NULL, `l_varchar300` varchar(300) character set latin1 collate latin1_general_cs default NULL, `u_varchar300` varchar(300) character set utf8 collate utf8_bin default NULL, `l_tinytext` tinytext character set latin1 collate latin1_general_cs, `u_tinytext` tinytext character set utf8 collate utf8_bin, `u_mediumtext` mediumtext character set utf8 collate utf8_bin, `u_text` text character set utf8 collate utf8_bin, `u_longtext` longtext character set utf8 collate utf8_bin, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci Note the u_char1 which is too small to hold a multiple byte utf character! Ludo > Reinier > _______________________________________________ > fpc-pascal maillist - fpc-pascal@lists.freepascal.org > http://lists.freepascal.org/mailman/listinfo/fpc-pascal > _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
