[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
RE: [stellation-res] SQL name length question
|
> >-----Original Message-----
> >From: stellation-res-admin@xxxxxxxxxxxxxxx
> >[mailto:stellation-res-admin@xxxxxxxxxxxxxxx]On Behalf Of Mark C.
> >Chu-Carroll
> >Sent: September 1, 2002 8:35 AM
> >To: stellation-res@xxxxxxxxxxxxxxx
> >Subject: [stellation-res] SQL name length question
> >
> >
> >
> >I did a quick look to check how long names can be in SQL, since
> >prefixing is increasing the name length. What I found was that
> >officially, SQL names can be up to 30 characters, but that some DB2
> >utilities will fail on column names that are not unique within the first
> >10 characters.
> >
> >I'm tentatively making the assumption that table names can be up to
> >30 characters, and column names can be up to 10 characters. Does anyone
> >know if any of the databases out there are more restrictive than this?
MySQL allows up to 64 characters for both table and column names. It also
allows the
use of restricted names as column names by quoting the name. Opens up the
possibility of using quoted names with databases that support them and
prefixes otherwise. The down-side is an extra level of indirection that will
generate column names appropriately for each database type.
Jonathan
> >
> > -Mark
> >
> >--
> >Mark Craig Chu-Carroll, IBM T.J. Watson Research Center
> >*** The Stellation project: Advanced SCM for Collaboration
> >*** http://www.eclipse.org/stellation
> >*** Work Email: mcc@xxxxxxxxxxxxxx ------- Personal Email:
> >markcc@xxxxxxxxxxx
> >
> >
> >_______________________________________________
> >stellation-res mailing list
> >stellation-res@xxxxxxxxxxxxxxx
> >http://dev.eclipse.org/mailman/listinfo/stellation-res
