I have a varchar column 1000 characters in length but am unable to create an index on it. also i need to make this column unique aswell. does a fulltext index allow me to make this column unique aswell?If so whats the syntax?
try declaring your (normal) index on only a portion of the column
whats the max number of characters i can index?
whats the the syntax to declare the above (portion of column) and to make it unique? Please note the entire string needs to be unique not just a portion of it.