Y4yS4AKz

1$dbh->do("drop table if exists $test_table_name");                                                                                                                                                                                                                                                                             
2my $create_query = qq{                                                                                                                                                                                                                                                                                                         
3CREATE TABLE $test_table_name (                                                                                                                                                                                                                                                                                                
4  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,                                                                                                                                                                                                                                                                                  
5  uchar VARCHAR(1),                                                                                                                                                                                                                                                                                                            
6  uchar_text TEXT,                                                                                                                                                                                                                                                                                                             
7  uchar_char CHAR(1),                                                                                                                                                                                                                                                                                                          
8  code_value VARCHAR(6),                                                                                                                                                                                                                                                                                                       
9  character_name VARCHAR(64)                                                                                                                                                                                                                                                                                                   
10) character set 'utf8mb4' collate 'utf8mb4_unicode_520_ci';                                                                                                                                                                                                                                                                    
11};                                                                                                                                                                                                                                                                                                                             
12$dbh->do($create_query);