hi all,
i want to migrate from SQLSerevr 2000 to MySQL 5.0.4. i've got a column type varchar(8000) in my source db. the reason of selecting varchar(8000) instead of text type is: we can't compare two text fields in SQLserver and i need to compare them some times.
i don't want to change my application and cause of mysqls limitation in up to 256 char in a varchar,So i can't use varchar.
what should I do in your opinion?

Thanks in advance