>
> Finally I will go with something hand made but would be great to think on
> this :)
> Just a thing, in mysql unsigned exists, that's one of the column
> properties.
>
who said the opposite ? the thing is, it's just mysql and firebird that the
support can be added, it's a small list comp
Finally I will go with something hand made but would be great to think on this
:)
Just a thing, in mysql unsigned exists, that's one of the column properties.
On 17 Nov 2012, at 15:57, Niphlod wrote:
> ps: checked a little and probably found out because web2py doesn't have a
> default type for
ps: checked a little and probably found out because web2py doesn't have a
default type for unsigned ints.
SQLite --> unsigned integer doesn't exist. Only integer
Postgresql --> same as above
MSSQL --> same as above
Oracle --> can be used in t-sql only, so, for table columns no support
Mysql --> s
> BigInt -> twice the same space required, I'am not sure that's why they
> exists..
>
they exist to support signed integer larger than int. That's what you can
do now to continue developing your app with web2py.
> sql.log -> indeed, could do it this way, but, why is everything else
> possib
BigInt -> twice the same space required, I'am not sure that's why they exists..
sql.log -> indeed, could do it this way, but, why is everything else possible
with the DAL (up to now)?
On 17 Nov 2012, at 14:09, Niphlod wrote:
>
> I know 2**31, I meant the value: 2147483648 :)
> And while the I
On Friday, November 16, 2012 5:56:18 PM UTC+1, Joseph.Piron wrote:
>
> I am working with mysql, there's no way to do this without an alter table
> ? (Which would be executed at each request moreover)
>
PS: once the table is altered "externally" there's no need to perform
anything on web2py. it'
I am working with mysql, there's no way to do this without an alter table ?
(Which would be executed at each request moreover)
On Nov 16, 2012 5:25 PM, "Marin Pranjić" wrote:
> You can use integer for development. In production, you can alter the
> database with raw sql to change the field.
> DAL
You can use integer for development. In production, you can alter the
database with raw sql to change the field.
DAL will still think it's an integer. If needed, you can add validators to
make sure you're not working with negative numbers.
On Fri, Nov 16, 2012 at 5:15 PM, Richard Vézina wrote:
Which backend do you use? I think that this feature is database specific...
Richard
On Fri, Nov 16, 2012 at 11:12 AM, Joseph.Piron wrote:
> Hi all!
>
> I have quite a problematic issue, I would like to know how to define a
> Field as unsigned in the DAL ?
> I tested:
> Field('triggerValue',
Hi all!
I have quite a problematic issue, I would like to know how to define a
Field as unsigned in the DAL ?
I tested:
Field('triggerValue', 'unsigned integer', requires=IS_NOT_EMPTY(),notnull
=True),
and
Field('triggerValue', 'integer', unsigned=True,
requires=IS_NOT_EMPTY(),notnull
=
10 matches
Mail list logo
