[Gambas-user] gb.db

Benoit Minisini gambas at ...1...
Wed Oct 8 19:30:41 CEST 2008


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




More information about the User mailing list