Perhaps, as a workaround, you can create separate columns that split the strings using LEFT() and MID() functions, then you can sort by first column (left 255 chars) and then second column (remaining chars)?