1select @@collation_connection; 2select hex(weight_string(cast(_latin1 0x80 as char))); 3select hex(weight_string(cast(_latin1 0x808080 as char))); 4select hex(weight_string(cast(_latin1 0x808080 as char) as char(2))); 5select hex(weight_string(cast(_latin1 0x808080 as char) as char(3))); 6select hex(weight_string(cast(_latin1 0x808080 as char) as char(5))); 7 8# Read 2 characters from the source string (the last character is not used). 9select hex(weight_string(cast(_latin1 0x808080 as char), 1, 2, 0xC0)); 10select hex(weight_string(cast(_latin1 0x808080 as char), 2, 2, 0xC0)); 11select hex(weight_string(cast(_latin1 0x808080 as char), 3, 2, 0xC0)); 12select hex(weight_string(cast(_latin1 0x808080 as char), 4, 2, 0xC0)); 13select hex(weight_string(cast(_latin1 0x808080 as char), 5, 2, 0xC0)); 14select hex(weight_string(cast(_latin1 0x808080 as char),25, 2, 0xC0)); 15 16# Read 3 characters from the source string (the entire string is used). 17select hex(weight_string(cast(_latin1 0x808080 as char), 1, 3, 0xC0)); 18select hex(weight_string(cast(_latin1 0x808080 as char), 2, 3, 0xC0)); 19select hex(weight_string(cast(_latin1 0x808080 as char), 3, 3, 0xC0)); 20select hex(weight_string(cast(_latin1 0x808080 as char), 4, 3, 0xC0)); 21select hex(weight_string(cast(_latin1 0x808080 as char), 5, 3, 0xC0)); 22select hex(weight_string(cast(_latin1 0x808080 as char),25, 3, 0xC0)); 23 24# Read 4 characters from the source string (extra space is added) 25select hex(weight_string(cast(_latin1 0x808080 as char), 1, 4, 0xC0)); 26select hex(weight_string(cast(_latin1 0x808080 as char), 2, 4, 0xC0)); 27select hex(weight_string(cast(_latin1 0x808080 as char), 3, 4, 0xC0)); 28select hex(weight_string(cast(_latin1 0x808080 as char), 4, 4, 0xC0)); 29select hex(weight_string(cast(_latin1 0x808080 as char), 5, 4, 0xC0)); 30select hex(weight_string(cast(_latin1 0x808080 as char),25, 4, 0xC0)); 31