Re: [web2py] Re: DAL MySQL text type

[Carlos Cesar Caballero Díaz]

Great, Thanks!!


El 20/08/18 a las 15:49, Anthony escribió:
On Monday, August 20, 2018 at 2:41:22 PM UTC-4, Carlos Cesar Caballero 
wrote:


Thanks Anthony, LONGTEXT is exactly what I need. But in case of
necessity, how "experimental" is that feature? Should I be worried
about unnoticed API changes?.


It's not really experimental (been there for years) -- it's just that 
no one ever updated that heading in the book. I just pushed a commit 
to the book repo removing "experimental".


Anthony
--
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.

Re: [web2py] Re: DAL MySQL text type

[Anthony]

On Monday, August 20, 2018 at 2:41:22 PM UTC-4, Carlos Cesar Caballero 
wrote:
>
> Thanks Anthony, LONGTEXT is exactly what I need. But in case of necessity, 
> how "experimental" is that feature? Should I be worried about unnoticed API 
> changes?.
>

It's not really experimental (been there for years) -- it's just that no 
one ever updated that heading in the book. I just pushed a commit to the 
book repo removing "experimental".

Anthony

-- 
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.

Re: [web2py] Re: DAL MySQL text type

[Carlos Cesar Caballero Díaz]

Thanks Anthony, LONGTEXT is exactly what I need. But in case of 
necessity, how "experimental" is that feature? Should I be worried about 
unnoticed API changes?.


Greetings.


El 18/08/18 a las 17:48, Anthony escribió:
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.


--
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.

Re: [web2py] Re: DAL MySQL text type

[Anthony]

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.

Re: [web2py] Re: DAL MySQL text type

[Carlos Cesar Caballero Díaz]

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.

[web2py] Re: DAL MySQL text type

[Erik]

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.