Unable to sort on Longvarchar field
Posted: Fri Feb 18, 2011 2:08 am
Hi Experts,
i am getting an error when i am trying to sort longvarchar (99999999) filed.
here is the fatal error from log:
"Trouble encoding sort keys: Variable-length key "MASTER_KEYS" length too large (32779), limit is 32767"
i defined field with longvarchar but i do not why job log giving error massage with varchar
Can any one suggest best method to over come this issue??
Thanks lot
i am getting an error when i am trying to sort longvarchar (99999999) filed.
here is the fatal error from log:
"Trouble encoding sort keys: Variable-length key "MASTER_KEYS" length too large (32779), limit is 32767"
i defined field with longvarchar but i do not why job log giving error massage with varchar
Can any one suggest best method to over come this issue??
Thanks lot