Chenri J <[EMAIL PROTECTED]> wrote on 26/11/2004 10:52:51: > What is 'binary' in column type stand for? > is it describe how the data is stored (in biner value)? > what do we want use it for? > - encryption ? > - space efficiency ? > - fast index ? > - or ....? > > > I've searched the mysql manual but didn't find any clue about it > thanks for your help before.
BINARY is usually used on character columns to tell MySQL to do an case-dependent rather than case-independent indexing and selection. By default, character columns use case-independent ordering. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]