arbalest06 <[EMAIL PROTECTED]> wrote:
i want to create a database with a table that has a column which is a
TEXT..i want to specify the maximum length of the text..but i cant do
TEXT(20)( ie., 20 characters max )..how can i do this?..
create table t (a text check(length(a) <= 20));
also i wou
arbalest06 <[EMAIL PROTECTED]> wrote:
i got it working already..thank you so much!..would this
check(length(a) <= 3 also work if the datatype is integer?
If you want to limit an integer, just write check(a <= maxValue)
Igor Tandetnik
---
Igor Tandetnik wrote:
arbalest06 <[EMAIL PROTECTED]> wrote:
i want to create a database with a table that has a column which is a
TEXT..i want to specify the maximum length of the text..but i cant do
TEXT(20)( ie., 20 characters max )..how can i do this?..
create table t (a text check(length(a
3 matches
Mail list logo