English
- #
- # 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 '), ('at');
- select collation(a),hex(a) from t1 order by a;
- drop table t1;
