On 18 Apr 2014, at 7:29pm, Donald Griggs wrote:
> I tried a simple test with recent [Postgres] (9.3.4) version (using default
> settings,
> if that matters) and verified that an insert with oversized string will
> fail to insert, unless the overage characters are spaces only, in which
> case it
I know very little about Postgres, but I see this interesting page in their
documentation:
http://www.postgresql.org/docs/8.0/interactive/datatype-character.html
Excerpt:
*An attempt to store a longer string into a column of these types will
result in an error, unless the excess characters are a
On 18-4-2014 18:56, Simon Slavin wrote:
On 18 Apr 2014, at 5:28pm, Dominique Devienne wrote:
I'm not sure where you get that declaring a column as varchar()
implicitly truncate
While I can't find any reference one way or another in a SQL standard, all
implementations I've seen that underst
On 18 Apr 2014, at 5:28pm, Dominique Devienne wrote:
> I'm not sure where you get that declaring a column as varchar()
> implicitly truncate
While I can't find any reference one way or another in a SQL standard, all
implementations I've seen that understand VARCHAR(n) truncate for any column
On Fri, Apr 18, 2014 at 4:42 PM, Simon Slavin wrote:
> On 18 Apr 2014, at 3:21pm, Dominique Devienne wrote:
>> No need to resort to triggers. A simple check constraint will do
>
> A constraint can prevent you from putting too-long values in the field. A
> trigger can truncate the value to the c
On 18 Apr 2014, at 3:21pm, Dominique Devienne wrote:
> On Fri, Apr 18, 2014 at 12:53 AM, Simon Slavin wrote:
>> There are ways to enforce field length limits entirely within SQLite but
>> they're complicated so post again if you want me to explain TRIGGERs.
>
> No need to resort to triggers.
On Fri, Apr 18, 2014 at 12:53 AM, Simon Slavin wrote:
> On 17 Apr 2014, at 11:24pm, David Clark wrote:
>> If I have a table of
>> field1 varchar(25)
>> field2 varchar(50)
>> field3 varchar(75)
>
> You don't. SQLite does not support a datatype of varchar(). Fields you
> declare like that will b
On 17 Apr 2014, at 11:24pm, David Clark wrote:
> If I have a table of
> field1 varchar(25)
> field2 varchar(50)
> field3 varchar(75)
You don't. SQLite does not support a datatype of varchar(). Fields you
declare like that will be implemented as TEXT fields and handled the same as
any other
On 4/17/2014 6:24 PM, David Clark wrote:
If I have a table of
field1 varchar(25)
field2 varchar(50)
field3 varchar(75)
I know sqlite does not enforce limits, but in my program it would be useful if
I could find the declared lengths of
25, 50 and 75 in this case. How might I do that in sqlite?
If I have a table of
field1 varchar(25)
field2 varchar(50)
field3 varchar(75)
I know sqlite does not enforce limits, but in my program it would be useful if
I could find the declared lengths of
25, 50 and 75 in this case. How might I do that in sqlite?
Thank you,
David Clark
__
10 matches
Mail list logo