Hi Massimo

I use Firebird.  Take a look at this:
http://ibexpert.net/ibe/index.php?n=Doc.TheFirebirdServerAndVARCHARs

Executive summary:  Think and plan your varchar size carefully.

On Aug 26, 4:07 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> These are always stored as varchar therefore it should not affect
> space. It would be nice to make an experiment and check if it does.
>
> Massimo
>
> On Aug 26, 8:41 am, villas <villa...@gmail.com> wrote:
>
>
>
> > I suppose that upload and password fields may be special cases.
>
> > However,  it seems to me that 512 default is way too big for normal
> > string fields.   Why so big?  Have space considerations become
> > irrelevant?
>
> > In my apps 90% of strings are less than 128.  As field sizes can
> > always be increased,  why not 128 or even 256 for now and simply
> > increase when necessary?
>
> > On Aug 25, 5:53 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > I have a radical proposal of changing the default length of string,
> > > upload, password fields to 512. This will cause a migration in all
> > > existing apps.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to