The DAL uses LONGTEXT for text fields in MySQL. If you'd like to use an alternative, you can create a custom type via SQLCustomType: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Custom-Field-types-experimental-.
Anthony On Saturday, August 18, 2018 at 3:49:35 PM UTC-4, Carlos Cesar Caballero wrote: > > Hi, Erick, thanks for your answer, there are the DAL types and the default > validators, but there are no mention about the adapters field types, for > example, in MySQL text can be stored in fields of types TEXT, MEDIUMTEXT or > LONGTEXT. I am asking for the type used in the MySQL DB, and if is possible > to set a different one. > > Greetings. > > El 17/08/18 a las 23:35, Erik escribió: > > This section has the types: > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Field-types > > > > On Thursday, August 16, 2018 at 9:59:13 AM UTC-7, Carlos Cesar Caballero > wrote: >> >> Hi guys, what kind of data type uses pydal in MySQL for "text" type?, if >> it is TEXT, is possible to set it for using MEDIUMTEXT or LONGTEXT? >> >> >> Greetings. >> >> >> -- > 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. > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
