Everybody is lucky sometimes :)

Thank you!

On Tue, Jun 4, 2019, 9:12 AM Anthony <[email protected]> wrote:

> SQLite doesn't make a distinction between string and text nor have a
> length limit, so yes, you're just "lucky" at the moment. If you plan to
> migrate to something like Postgres, either explicitly set a higher limit or
> just use a text field.
>
> Anthony
>
> On Tuesday, June 4, 2019 at 5:30:05 AM UTC-4, Vlad wrote:
>>
>> I've used a string field to keep certain info, and it works just fine,
>> but I've just noticed that the strings I ended up saving in this field were
>> around 1,000 characters long, sometimes even closer to 2,000.
>> According to the docs, the default limit for a string field is 512. The
>> limit doesn't seem to be a problem now, so I am wondering what's the nature
>> of the limit. Is it safe to use longer strings because DAL handles them
>> somehow? Or I'm just lucky at the moment, and should increase the size or
>> switch to a text field? (I am still developing, so using sqlite for the
>> time being)
>>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/D7E75GRRGlA/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/adc52c5a-c85d-44da-8b18-fb67f12c7f42%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/adc52c5a-c85d-44da-8b18-fb67f12c7f42%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CABZ%2BKCCXoXB-fD-L5brd%3DFxXxOvhFK4%3DfMkZXoAUGK9oQXmG7A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to