--- In ib-support@y..., "Senthil Kumar" <sbsen2000@y...> wrote:

> Hi All,
>
> Iam converting a Mssql2000 database to interbase
> I want to have table names more that 100 char.
> how can set table name size to 256
>
>
> Thanks in advance,
> Senthil Kumar.

Ummm, just a general comment: if you want a database to be portable
(*), you should not use really long names, since they are not
supported by all products.

[(*) Errr, "portable" is a bit of a lofty goal. Perhaps I should have
said "marginally more portable". Whatever.]

The SQL92 standard say that the maximum length of an identifier is
128; for Entry level SQL92 conformance, max length for identifiers is
18.
In SQL99, the maximum length for identifiers is 127.

[Typo? SQL92 says "not greater than 128"; SQL99 says "less than 128"
... poor old 128! ... I guess I'll double-check ...]

And products are all over the map with respect to the maximum length
supported for identifiers.

Cheers,
db