1select @@collation_connection; 2select collation(cast(_latin1 0xDF as char)); 3select hex(weight_string('s')); 4select hex(weight_string(cast(_latin1 0xDF as char))); 5select hex(weight_string(cast(_latin1 0xDF as char) as char(1))); 6select hex(weight_string('c')); 7select hex(weight_string('h')); 8select hex(weight_string('ch')); 9select hex(weight_string('i')); 10# contraction 'ch' plus expansion 'sharp s' 11select hex(weight_string(cast(_latin1 0x6368DF as char))); 12select hex(weight_string(cast(_latin1 0x6368DF as char) as char(1))); 13select hex(weight_string(cast(_latin1 0x6368DF as char) as char(2))); 14select hex(weight_string(cast(_latin1 0x6368DF as char) as char(3))); 15select hex(weight_string(cast(_latin1 0x6368DF as char) as char(4))); 16# expansion 'sharp s' plus contraction 'ch' 17select hex(weight_string(cast(_latin1 0xDF6368 as char))); 18select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1))); 19select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2))); 20select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3))); 21select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4))); 22 23# contraction 'ch' plus expansion 'sharp s' 24select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 2, 0xC0)); 25select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 2, 0xC0)); 26select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 2, 0xC0)); 27select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 2, 0xC0)); 28select hex(weight_string(cast(_latin1 0x6368DF as char),25, 2, 0xC0)); 29 30select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 3, 0xC0)); 31select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 3, 0xC0)); 32select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 3, 0xC0)); 33select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 3, 0xC0)); 34select hex(weight_string(cast(_latin1 0x6368DF as char),25, 3, 0xC0)); 35 36select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 4, 0xC0)); 37select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 4, 0xC0)); 38select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 4, 0xC0)); 39select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 4, 0xC0)); 40select hex(weight_string(cast(_latin1 0x6368DF as char),25, 4, 0xC0)); 41 42# expansion 'sharp s' plus contraction 'ch' 43select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 2,0xC0)); 44select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 2,0xC0)); 45select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 2,0xC0)); 46select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 2,0xC0)); 47select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 2,0xC0)); 48 49select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 3,0xC0)); 50select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 3,0xC0)); 51select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 3,0xC0)); 52select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 3,0xC0)); 53select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 3,0xC0)); 54 55select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 4,0xC0)); 56select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 4,0xC0)); 57select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 4,0xC0)); 58select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 4,0xC0)); 59select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 4,0xC0)); 60