SQL-92 varchar maxlength

9 Jun 2006 12:18 PM

Svenne

Hi!
I want to design a database that is compatible with SQL-92 standard.
Does anybody know what the SQL-92 standard says about the maximal length of
the varchar datatype?

Thanx in advance
/Svenne

9 Jun 2006 12:54 PM

Anith Sen

Standards generally do not specify capacity limits for data types. They are
defined by implementations.

You can get a draft version of SQL-92 standards at:
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

On a related note, to validate the standard compliance:
http://developer.mimer.com/validator/index.htm

--
Anith

10 Jun 2006 12:36 AM

Farmer

If you use SQL Server, just make it MS SQL compliant. If you use Oracle,
make it Oracle compliant.
People that think they can be compatible with some standard and that would
make their future super bright,
live in a dream world and loose havily by not taking advantage of platform
performance.
I lived with such database designs; what a disaster!
What is the point anyhow? Will you be porting to DB2, Oracle shortly after?
Show quote

:)

"Svenne" <sasoderg***@hotmail.com> wrote in message
news:OBdXo77iGHA.836@TK2MSFTNGP02.phx.gbl...
> Hi!
> I want to design a database that is compatible with SQL-92 standard.
> Does anybody know what the SQL-92 standard says about the maximal length
> of the varchar datatype?
>
> Thanx in advance
> /Svenne
>

10 Jun 2006 7:59 PM

--CELKO--

>> Does anybody know what the SQL-92 standard says about the maximal length of

the VARCHAR(n) data type? <<

Such limits are implementaiton defined in the Standards. However, you
should worry about finding the right length for your problem. Too
short and it does not work. Too long and you will accumlate garbage.
CHAR(n) is usually better for constraint checking.