Menu
What is the maximum length for a table comment in Oracle and SQL Server? For MySQL this is 60 chars.
336
For logical table names stored within an Entry table, you can have up to 40 characters. Form names are limited to 100 characters, which is also the Library manager limit on any file name. Section names are limited to 64 characters.
The maximum length of the table and column name is 128 bytes or 128 characters.
Oracle has a limit of 4000 bytes for a VARCHAR2 column and there is no way to workaround that limit. So you can only store 4000 characters in a VARCHAR2 column if you are using a single-byte characterset.
Oracle limit on comment size is 4000 characters.
165
A quick google search lead to the comments being stored in user_tab_comments, so just check the size of that column in your DB.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
