Page 1 of 1

Unable to sort on Longvarchar field

Posted: Fri Feb 18, 2011 2:08 am
by smart2786
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