Subject | key size too big for index |
---|---|
Author | Robert DiFalco |
Post date | 2003-04-08T19:05:20Z |
I guess I'm not understanding the size of index keys.
CREATE TableFoo (
id INTEGER,
foo VARCHAR(120),
bar VARCHAR(120) );
CREATE INDEX tableFoo_foo ON TableFoo(foo);
This fails telling me that the key size is too big. What exactly is the
limit for VARCHAR keys?
TIA,
R.
[Non-text portions of this message have been removed]
CREATE TableFoo (
id INTEGER,
foo VARCHAR(120),
bar VARCHAR(120) );
CREATE INDEX tableFoo_foo ON TableFoo(foo);
This fails telling me that the key size is too big. What exactly is the
limit for VARCHAR keys?
TIA,
R.
[Non-text portions of this message have been removed]