Subject Re: [firebird-support] Max identifier length?
Author Kjell Rilbe
Milan Babuskov wrote:

> Kjell Rilbe wrote:
> > Try this in a DB with default charset UTF8:
> >
> > // Table name is 31 ASCII characters.
> > // Works fine.
> > create table "X234567890123456789012345678901" (
> > "Dummy" int
> > );
>
> I just tried the same with Cyrillic characters and ISQL and it looks
> like a bug in Firebird. Maybe you should submit a bug report in the tracker.

For those who lost track: the problem is that if one or more characters
in the table name above is changed into a character that takes up more
than one byte, the max identifier length decreases proportionally.

But is it a bug?

I thought this was as designed? I seem to recall that the system table
holds max 31 8 byte characters, and if a different character encoding is
used, the max length depends on hos many bytes each "codepoint" requires.

If it really is a bug, then of course I'd like to submit it to get it
fixed, but I'm hoping someone can say if it is a bug or not...?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64