Subject | Re: [firebird-support] Re: Firebird 2.5 maximum length for each type of identifier |
---|---|
Author | Kjell Rilbe |
Post date | 2010-11-12T10:19:05Z |
Kjell Rilbe skriver:
transliterate the received UTF-8 string at all, but expects it encoded
in such a way that it appears to be 32 characters, as displayed in the
error message above. So who's getting it wrong?
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
[Non-text portions of this message have been removed]
> -- 31 characters, one of which requires 2 byte in UTF-8.In fact, it's more likely that FR, ibpp or fbclient doesn't
> create table "�234567890123456789012345678901" (
> "�234567890123456789012345678901" int
> )
>
> Error: *** IBPP::SQLException ***
> Context: Statement::Execute( create table
> "��234567890123456789012345678901" (
> "��234567890123456789012345678901" int
> )
> )
> Message: isc_dsql_execute2 failed
>
> SQL Message : -607
> This operation is not defined for system tables.
>
> Engine Code : 335544351
> Engine Message :
> unsuccessful metadata update
> Name longer than database column size
>
> This was executed over a UTF-8 connection, so maybe it's FlameRobin or
> IBPP that transliterates from UTF-8 to iso-8859-1 or whatever, resulting
> in 32 characters, that are later transliterated to UNICODE-FSS resulting
> in 32 * 3 byte.
>
> Seems convoluted. Does fbclient expect identifiers to be passed already
> encoded in UNICODE-FSS or what char encoding does it expect? Is it the
> connection charset that determines this? If so, then fbclient seems to
> fail in transliterating the above strings directly to UNICODE-FSS.
transliterate the received UTF-8 string at all, but expects it encoded
in such a way that it appears to be 32 characters, as displayed in the
error message above. So who's getting it wrong?
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
[Non-text portions of this message have been removed]