Subject | Key size too big?! |
---|---|
Author | ivoras |
Post date | 2004-06-04T14:32:22Z |
I have this table, FILES with a field FILENAME of type varchar(300),
character set win1250, collation coll_slov, and when I try to create
an ordinary index on it, I get this error:
SQL> create index files_filename on files(filename);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-key size too big for index FILES_FILENAME
I'm trying it on firebird 1.5 on win32. My question is: what is this
and how can I get rid of it? :) The same happens when the field is
declared with width 100, but not with width 50. Database page size iz
4096.
Thanks!
character set win1250, collation coll_slov, and when I try to create
an ordinary index on it, I get this error:
SQL> create index files_filename on files(filename);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-key size too big for index FILES_FILENAME
I'm trying it on firebird 1.5 on win32. My question is: what is this
and how can I get rid of it? :) The same happens when the field is
declared with width 100, but not with width 50. Database page size iz
4096.
Thanks!