View Single Post
Old 2016-08-28, 20:20   #1125
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

285810 Posts
Default

Quote:
Originally Posted by retina View Post
Actually I think it is a sorting thing. They only purpose I know of for informing the DB that some data are in specific text formats is to sort things "logically" so that letters with accents will sort close to the same letter without an accent, and other similar lexicographic reasons. For all other purposes, like display and comparison for example, simple byte data is just fine.
It also matters for LIKE, STRCMP, etc.
Mark Rose is online now   Reply With Quote