Subject | index key size |
---|---|
Author | sugi |
Post date | 2003-04-17T00:16:11Z |
Dear all,
I asked a question some time in the past (IB 5.x) about the maximum
allowed size of the PK, which was limited to around 200 characters in
the default charset. I ran into another similar problem today, this time
I have a varchar(255) field, and when I try to create a unique index on
this field, FB complained about 'key size too large'.
1. Is this the same pk/index limitations? Or did I do something wrong?
2. Is there any workaround/fixes on the issue?
TIA,
sugi.
I asked a question some time in the past (IB 5.x) about the maximum
allowed size of the PK, which was limited to around 200 characters in
the default charset. I ran into another similar problem today, this time
I have a varchar(255) field, and when I try to create a unique index on
this field, FB complained about 'key size too large'.
1. Is this the same pk/index limitations? Or did I do something wrong?
2. Is there any workaround/fixes on the issue?
TIA,
sugi.