I am using MySQL and it work if I set the index manually:
CREATE INDEX xxx ON yyy (zzzz(A_NUMBER));
But I understand that this is not a SQL standard way of doing this and
as not all DBs (I think Oracle has a way of doing this) support it it is
nothing Ofbiz can solve. Period.
/ Hans
David E Jones skrev:
I don't know which database you're using, but most databases do not
support having a BLOB or CLOB type column in an index or foreign key
or primary key, period.
My guess is that the error message is leading you to believe something
might be possible, but it really isn't possible.
The first step is to research this more in the database.
-David
On Dec 7, 2006, at 10:22 AM, Hans Holmlund wrote:
I want to create an index on a TEXT column. When doing this the
key-length to use for the index must be specified, otherwise I get
the following error message:
"BLOB/TEXT column 'ABSOLUTE_PATH' used in key specification without a
key length".
How do I specify the key-length in the entitymodel definition?
Thanks,
Hans Holmlund
