GDA: string lengths (was Re: GDA save missing records)

Graham Leggett minfrin at sharp.fm
Mon Feb 18 17:01:00 EST 2008


Keith Bellairs wrote:

> I think that depends on the DB. Using VARCHAR at least gives the engine 
> a chance to optimize storage. CHAR is good for truly fixed length strings.

This is true, I mixed up the varchar with the char. Adding a limit to 
varchar is entirely arbitrary though, if the varchar can support a 2 
byte string length, then why not choose the biggest size available?

Regards,
Graham
--
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3287 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20080219/8f87b858/attachment.bin 


More information about the gnucash-devel mailing list