On mercredi 08 octobre 2008, Kari Laine wrote: > Hi, > > I am writing a test program and I am little stuck with the big fields in > gb.db. Could someone tell me please? > > what type I define to use the following MySQL fields? > > VARCHAR(*M*), VARBINARY(*M*) *L* + 1 bytes if column values require 0 – 255 > bytes, *L* + 2 bytes if values may require more than 255 bytes > TINYBLOB, TINYTEXT *L* + 1 bytes, where *L* < 28 BLOB, TEXT *L* + 2 bytes, > where *L* < 216 > MEDIUMBLOB, MEDIUMTEXT *L* + 3 bytes, where *L* < 224 > LONGBLOB, LONGTEXT *L* + 4 bytes, where *L* < 232 > > > > Best Regards > Kari Laine
There is a document about that on the wiki named "database datatype mapping". Regards, -- Benoit Minisini ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
