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