MySQL™: The World’s Most Popular Open Source Database 167 4.1: UNICODE Support • CREATE TABLE t (field_list) [CHARSET=latin1]; • SELECT Last_name FROM Customer ORDER BY Last_name COLLATE latin1_de; • SELECT MAX(Last_name COLLATE latin1_de); • SELECT * FROM Customer WHERE (Last_name COLLATE latin1_de)=”Müller”; • CONVERT(Last_name USING utf8); • UCS2 support (two byte Unicode) • UTF8 support RFC2279, 1..3 bytes Copyright 2003 MySQL AB