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 the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/adc52c5a-c85d-44da-8b18-fb67f12c7f42%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
