View Single Post
Old 2016-08-28, 20:20   #1125
Mark Rose
Mark Rose's Avatar
Jan 2013

23·359 Posts

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