table name and column length limits

Classic Servoy
1

Hi

for portability reasons I am interested in hearing about table name and column length limits, especially of PostgreSQL, MySQL and (the next version of) Oracle. Has anybody a list of databases and the above mentioned limits associated with the db. Does anybody know if there is still the 30 character limit on table name? What is the current column length limit?
By the way, are there any length limit problems to deal with on relationship names on the various db’s?

Thanks for support!

Best regards, Robert

2

Oracle (at least) has a limit of 30. I don’t know of any plans to change that.

3

Hi patrick

What about the columnname length limit in 10g? (Unfortunatly, I have no access to an Oracle db at the moment).

These limits disappeared in OS’es, so we (hopefully) have a good chance they disappear in DBes, too.
There exists the Beta 11g. Are you trying this already?

Best regards, Robert

patrick:
Oracle (at least) has a limit of 30. I don’t know of any plans to change that.

4

No, but you can be pretty sure that for the next 10 years they will have this limit…

5

Yeahh, I can easily agree with you, as I worked many many years with Oracle DBs (I even can’t remember which version I started with, but I think 4 or 5) and Oracle CASE Tools and Oracle CASE*Method.

Still, Richard Barker from Oracle wrote one of the best book about Entity Relationship Modelling (in my opinion), first printed in 1989.

Regards, Robert

patrick:
No, but you can be pretty sure that for the next 10 years they will have this limit…

6

Hi Robert,

PostgreSQL 8.x uses a 63 character limit (NAMEDATALEN-1) on keywords and identifiers.
(See first paragraph under chapter 4.1.1 at http://www.postgresql.org/docs/8.2/stat … xical.html)
But if you want you can rebuild the server to use any length you want by changing the NAMEDATALEN in the source.

MySQL seems to have a 64 character limit for databases, tables, columns and indices. Aliases can be 256 characters.
At least that is what I can find on the web (but not on the MySQL website)

Hope this helps.

7

Hi Robert

Thanks for your answer. My longest column names are (at the moment) 64 characters (just by accident that they have these length).

Best regards, Robert

ROCLASI:
Hi Robert,

PostgreSQL 8.x uses a 63 character limit (NAMEDATALEN-1) on keywords and identifiers.
(See first paragraph under chapter 4.1.1 at http://www.postgresql.org/docs/8.2/stat … xical.html)
But if you want you can rebuild the server to use any length you want by changing the NAMEDATALEN in the source.

MySQL seems to have a 64 character limit for databases, tables, columns and indexes. Aliases can be 256 characters.
At least that is what I can find on the web (but not on the MySQL website)

Hope this helps.

8

Special mySQL gimmick: table names are case sensitive (column names are not)!