You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
802 B
20 lines
802 B
# Preparation: Shut server down.
|
|
# 1 First start the server with --initialize and --lower-case-table-names=1.
|
|
# We need to make sure l-c-t-n is set during database initialization.
|
|
# Otherwise the mysql.tables.name do not pick right collation.
|
|
# This test also requires to be run with --character-set-server=utf8
|
|
# 2 Restart the server against DDIR
|
|
set names utf8;
|
|
Warnings:
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
create table `Ö` (id int);
|
|
show tables from test like 'Ö';
|
|
Tables_in_test (Ö)
|
|
ö
|
|
show tables from test like 'ö';
|
|
Tables_in_test (ö)
|
|
ö
|
|
drop table `Ö`;
|
|
# Shut server down.
|
|
#
|
|
# Cleanup: Restarting the server against default datadir.
|
|
|