1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
# # Set desired charset_connection and collation_collation # before including this file. # # The next query creates a LONGTEXT column # using the current character_set_connection # and collation_connection. create table t1 select repeat('a',4000) a; delete from t1; insert into t1 values ('a'), ('a '), ('a\t'); select collation(a),hex(a) from t1 order by hex(a); drop table t1; |