About the char set: DEFAULT CHARACTER SET NONE; About the firebird version: I was working with version 2.0.0.12748 and now with version 2.0.3.12981
About the forum: I did a mistake and I sent this message to Delphi group instead of Firebird. I apologize for this but if anyone knows anything about this just reply. Thank you --- Dennis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Kennedy Sent: Tuesday, December 11, 2007 7:03 PM To: [email protected] Subject: [delphi-en] Re: Does 2.0.3.12981 version requires smaller instead or bigger index keys? ref/ --- In [email protected] <mailto:delphi-en%40yahoogroups.com> , "dennis" <[EMAIL PROTECTED]> wrote: > The follow index didn't have problem prior to firebird version 2.0.3.12981 Precisely what version did you have before? Is there anything in the change log or the release notes that hints at what changed? > CREATE INDEX CODES_IDX2 ON CODES (KEY_, RES_); > > The error message is: > > This operation is not defined for system tables. > > unsuccessful metadata update. > > key size exceeds implementation restriction for index "CODES_IDX2". > > > > Key_ and res_ fields are varchar(100). Doesn't the size that that represents vary based on the character set you're using? > What happen? Does 2.0.3.12981 version requires smaller instead or bigger > index keys? Where am I wrong? Your question seems to be one about Firebird, not Delphi. Have you tried asking in a Firebird forum? -- Rob [Non-text portions of this message have been removed]
