#enable after fix MDEV-29290
--disable_view_protocol
select collation(cast(0 x8FA2C3 as char ));
select hex(weight_string(cast(0 x6141 as char )));
select hex(weight_string(cast(0 x8FA2C3 as char )));
select hex(weight_string(cast(0 x8FA2C3 as char ) as char (1 )));
select hex(weight_string(cast(0 x8FA2C38FA2C3 as char ) as char (1 )));
select hex(weight_string(cast(0 x8FA2C3 as char ) as char (3 )));
select hex(weight_string(cast(0 x8FA2C38FA2C3 as char ) as char (3 )));
select hex(weight_string(cast(0 x408FA2C3 as char ) as char (3 )));
select hex(weight_string(cast(0 x408FA2C38FA2C3 as char ) as char (3 )));
select hex(weight_string(cast(0 x408FA2C38FA2C38FA2C3 as char ) as char (3 )));
select hex(weight_string(cast(0 x40408FA2C38FA2C38FA2C3 as char ) as char (3 )));
# Read 2 characters from the source string (the last character is not used)
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 1 , 2 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 2 , 2 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 3 , 2 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 4 , 2 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 5 , 2 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ),25 , 2 , 0 xC0));
# Read 3 characters from the source string (the entire string is used)
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 1 , 3 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 2 , 3 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 3 , 3 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 4 , 3 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 5 , 3 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ),25 , 3 , 0 xC0));
# Read 4 characters from the source string (extra space is added)
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 1 , 4 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 2 , 4 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 3 , 4 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 4 , 4 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ), 5 , 4 , 0 xC0));
select hex(weight_string(cast(0 x8FA2C38FA2C38FA2C3 as char ),25 , 4 , 0 xC0));
--enable_view_protocol
Messung V0.5 in Prozent C=86 H=86 G=85
¤ Dauer der Verarbeitung: 0.2 Sekunden
¤
*© Formatika GbR, Deutschland