Subject | Re: [firebird-support] Max identifier length? |
---|---|
Author | Kjell Rilbe |
Post date | 2009-04-07T20:55:48Z |
Milan Babuskov wrote:
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
> Kjell Rilbe wrote:For those who lost track: the problem is that if one or more characters
> > 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.
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