1set sql_mode=""; 2set names koi8r; 3 4------------------------------------------------------------------- 5Views 6------------------------------------------------------------------- 7 8DROP DATABASE IF EXISTS mysqltest1| 9CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 10use mysqltest1| 11CREATE TABLE t1(��� INT)| 12INSERT INTO t1 VALUES(1)| 13 14CREATE VIEW v1 AS 15SELECT '����' AS c1, ��� AS c2 16FROM t1| 17 18CREATE VIEW v2 AS SELECT _utf8'тест' as c1| 19 20CREATE VIEW v3 AS SELECT _utf8'тест'| 21 22 23 24SHOW CREATE VIEW v1| 25View Create View character_set_client collation_connection 26v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select '����' AS `c1`,`t1`.`���` AS `c2` from `t1` koi8r koi8r_general_ci 27 28SHOW CREATE VIEW v2| 29View Create View character_set_client collation_connection 30v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select _utf8'тест' AS `c1` koi8r koi8r_general_ci 31 32SHOW CREATE VIEW v3| 33View Create View character_set_client collation_connection 34v3 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select _utf8'тест' AS `����` koi8r koi8r_general_ci 35 36 37SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v1'| 38TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 39def mysqltest1 v1 select '����' AS `c1`,`mysqltest1`.`t1`.`���` AS `c2` from `mysqltest1`.`t1` NONE YES root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 40 41SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v2'| 42TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 43def mysqltest1 v2 select '����' AS `c1` NONE NO root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 44 45SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v3'| 46TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 47def mysqltest1 v3 select '����' AS `����` NONE NO root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 48 49 50SELECT COLLATION(c1), COLLATION(c2) FROM v1| 51COLLATION(c1) COLLATION(c2) 52koi8r_general_ci binary 53 54SELECT COLLATION(c1) FROM v2| 55COLLATION(c1) 56utf8_general_ci 57 58SELECT * FROM v3| 59���� 60���� 61 62 63ALTER DATABASE mysqltest1 COLLATE cp866_general_ci| 64connect con2,localhost,root,,; 65SET @@character_set_client= cp1251| 66SET @@character_set_results= cp1251| 67SET @@collation_connection= cp1251_general_ci| 68SELECT * FROM mysqltest1.v1| 69SELECT * FROM mysqltest1.v2| 70SELECT * FROM mysqltest1.v3| 71use mysqltest1| 72set names koi8r| 73 74 75SHOW CREATE VIEW v1| 76View Create View character_set_client collation_connection 77v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select '����' AS `c1`,`t1`.`���` AS `c2` from `t1` koi8r koi8r_general_ci 78 79SHOW CREATE VIEW v2| 80View Create View character_set_client collation_connection 81v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select _utf8'тест' AS `c1` koi8r koi8r_general_ci 82 83SHOW CREATE VIEW v3| 84View Create View character_set_client collation_connection 85v3 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select _utf8'тест' AS `����` koi8r koi8r_general_ci 86 87 88SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v1'| 89TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 90def mysqltest1 v1 select '����' AS `c1`,`mysqltest1`.`t1`.`���` AS `c2` from `mysqltest1`.`t1` NONE YES root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 91 92SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v2'| 93TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 94def mysqltest1 v2 select '����' AS `c1` NONE NO root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 95 96SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v3'| 97TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 98def mysqltest1 v3 select '����' AS `����` NONE NO root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 99 100 101SELECT COLLATION(c1), COLLATION(c2) FROM v1| 102COLLATION(c1) COLLATION(c2) 103koi8r_general_ci binary 104 105SELECT COLLATION(c1) FROM v2| 106COLLATION(c1) 107utf8_general_ci 108 109SELECT * FROM v3| 110���� 111���� 112 113---> Dumping mysqltest1 to ddl_i18n_koi8r.views.mysqltest1.sql 114 115 116DROP DATABASE mysqltest1| 117 118 119---> Restoring mysqltest1... 120connect con3,localhost,root,,; 121SET @@character_set_client= cp1251| 122SET @@character_set_results= cp1251| 123SET @@collation_connection= cp1251_general_ci| 124SELECT * FROM mysqltest1.v1| 125SELECT * FROM mysqltest1.v2| 126SELECT * FROM mysqltest1.v3| 127use mysqltest1| 128set names koi8r| 129 130 131SHOW CREATE VIEW v1| 132View Create View character_set_client collation_connection 133v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select '����' AS `c1`,`t1`.`���` AS `c2` from `t1` koi8r koi8r_general_ci 134 135SHOW CREATE VIEW v2| 136View Create View character_set_client collation_connection 137v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select _utf8'тест' AS `c1` koi8r koi8r_general_ci 138 139SHOW CREATE VIEW v3| 140View Create View character_set_client collation_connection 141v3 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select _utf8'тест' AS `����` koi8r koi8r_general_ci 142 143 144SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v1'| 145TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 146def mysqltest1 v1 select '����' AS `c1`,`mysqltest1`.`t1`.`���` AS `c2` from `mysqltest1`.`t1` NONE YES root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 147 148SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v2'| 149TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 150def mysqltest1 v2 select '����' AS `c1` NONE NO root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 151 152SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v3'| 153TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION ALGORITHM 154def mysqltest1 v3 select '����' AS `����` NONE NO root@localhost DEFINER koi8r koi8r_general_ci UNDEFINED 155 156 157SELECT COLLATION(c1), COLLATION(c2) FROM v1| 158COLLATION(c1) COLLATION(c2) 159koi8r_general_ci binary 160 161SELECT COLLATION(c1) FROM v2| 162COLLATION(c1) 163utf8_general_ci 164 165SELECT * FROM v3| 166���� 167���� 168connection default; 169disconnect con2; 170disconnect con3; 171use test| 172DROP DATABASE mysqltest1| 173 174------------------------------------------------------------------- 175Stored procedures/functions 176------------------------------------------------------------------- 177 178DROP DATABASE IF EXISTS mysqltest1| 179DROP DATABASE IF EXISTS mysqltest2| 180CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 181CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 182use mysqltest1| 183 184CREATE PROCEDURE p1( 185INOUT �����1 CHAR(10), 186OUT �����2 CHAR(10)) 187BEGIN 188DECLARE �����1 CHAR(10); 189SELECT 190COLLATION(�����1) AS c1, 191COLLATION(�����1) AS c2, 192COLLATION(�����2) AS c3; 193SELECT 194COLLATION('�����') AS c4, 195COLLATION(_koi8r '�����') AS c5, 196COLLATION(_utf8 'текст') AS c6, 197@@collation_connection AS c7, 198@@character_set_client AS c8; 199SET �����1 = 'a'; 200SET �����2 = 'b'; 201END| 202 203CREATE PROCEDURE p2( 204INOUT �����1 CHAR(10) CHARACTER SET utf8, 205OUT �����2 CHAR(10) CHARACTER SET utf8) 206BEGIN 207DECLARE �����1 CHAR(10) CHARACTER SET utf8; 208SELECT 209COLLATION(�����1) AS c1, 210COLLATION(�����1) AS c2, 211COLLATION(�����2) AS c3; 212SELECT 213COLLATION('�����') AS c4, 214COLLATION(_koi8r '�����') AS c5, 215COLLATION(_utf8 'текст') AS c6, 216@@collation_connection AS c7, 217@@character_set_client AS c8; 218SET �����1 = 'a'; 219SET �����2 = 'b'; 220END| 221 222CREATE PROCEDURE mysqltest2.p3( 223INOUT �����1 CHAR(10), 224OUT �����2 CHAR(10)) 225BEGIN 226DECLARE �����1 CHAR(10); 227SELECT 228COLLATION(�����1) AS c1, 229COLLATION(�����1) AS c2, 230COLLATION(�����2) AS c3; 231SELECT 232COLLATION('�����') AS c4, 233COLLATION(_koi8r '�����') AS c5, 234COLLATION(_utf8 'текст') AS c6, 235@@collation_connection AS c7, 236@@character_set_client AS c8; 237SET �����1 = 'a'; 238SET �����2 = 'b'; 239END| 240 241CREATE PROCEDURE mysqltest2.p4( 242INOUT �����1 CHAR(10) CHARACTER SET utf8, 243OUT �����2 CHAR(10) CHARACTER SET utf8) 244BEGIN 245DECLARE �����1 CHAR(10) CHARACTER SET utf8; 246SELECT 247COLLATION(�����1) AS c1, 248COLLATION(�����1) AS c2, 249COLLATION(�����2) AS c3; 250SELECT 251COLLATION('�����') AS c4, 252COLLATION(_koi8r '�����') AS c5, 253COLLATION(_utf8 'текст') AS c6, 254@@collation_connection AS c7, 255@@character_set_client AS c8; 256SET �����1 = 'a'; 257SET �����2 = 'b'; 258END| 259 260 261SHOW CREATE PROCEDURE p1| 262Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 263p1 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`( 264INOUT �����1 CHAR(10), 265OUT �����2 CHAR(10)) 266BEGIN 267DECLARE �����1 CHAR(10); 268SELECT 269COLLATION(�����1) AS c1, 270COLLATION(�����1) AS c2, 271COLLATION(�����2) AS c3; 272SELECT 273COLLATION('�����') AS c4, 274COLLATION(_koi8r '�����') AS c5, 275COLLATION(_utf8 'текст') AS c6, 276@@collation_connection AS c7, 277@@character_set_client AS c8; 278SET �����1 = 'a'; 279SET �����2 = 'b'; 280END koi8r koi8r_general_ci utf8_unicode_ci 281 282SHOW CREATE PROCEDURE p2| 283Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 284p2 CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`( 285INOUT �����1 CHAR(10) CHARACTER SET utf8, 286OUT �����2 CHAR(10) CHARACTER SET utf8) 287BEGIN 288DECLARE �����1 CHAR(10) CHARACTER SET utf8; 289SELECT 290COLLATION(�����1) AS c1, 291COLLATION(�����1) AS c2, 292COLLATION(�����2) AS c3; 293SELECT 294COLLATION('�����') AS c4, 295COLLATION(_koi8r '�����') AS c5, 296COLLATION(_utf8 'текст') AS c6, 297@@collation_connection AS c7, 298@@character_set_client AS c8; 299SET �����1 = 'a'; 300SET �����2 = 'b'; 301END koi8r koi8r_general_ci utf8_unicode_ci 302 303SHOW CREATE PROCEDURE mysqltest2.p3| 304Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 305p3 CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`( 306INOUT �����1 CHAR(10), 307OUT �����2 CHAR(10)) 308BEGIN 309DECLARE �����1 CHAR(10); 310SELECT 311COLLATION(�����1) AS c1, 312COLLATION(�����1) AS c2, 313COLLATION(�����2) AS c3; 314SELECT 315COLLATION('�����') AS c4, 316COLLATION(_koi8r '�����') AS c5, 317COLLATION(_utf8 'текст') AS c6, 318@@collation_connection AS c7, 319@@character_set_client AS c8; 320SET �����1 = 'a'; 321SET �����2 = 'b'; 322END koi8r koi8r_general_ci utf8_unicode_ci 323 324SHOW CREATE PROCEDURE mysqltest2.p4| 325Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 326p4 CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`( 327INOUT �����1 CHAR(10) CHARACTER SET utf8, 328OUT �����2 CHAR(10) CHARACTER SET utf8) 329BEGIN 330DECLARE �����1 CHAR(10) CHARACTER SET utf8; 331SELECT 332COLLATION(�����1) AS c1, 333COLLATION(�����1) AS c2, 334COLLATION(�����2) AS c3; 335SELECT 336COLLATION('�����') AS c4, 337COLLATION(_koi8r '�����') AS c5, 338COLLATION(_utf8 'текст') AS c6, 339@@collation_connection AS c7, 340@@character_set_client AS c8; 341SET �����1 = 'a'; 342SET �����2 = 'b'; 343END koi8r koi8r_general_ci utf8_unicode_ci 344 345 346SHOW PROCEDURE STATUS LIKE 'p1'| 347Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 348mysqltest1 p1 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 349 350SHOW PROCEDURE STATUS LIKE 'p2'| 351Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 352mysqltest1 p2 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 353 354SHOW PROCEDURE STATUS LIKE 'p3'| 355Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 356mysqltest2 p3 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 357 358SHOW PROCEDURE STATUS LIKE 'p4'| 359Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 360mysqltest2 p4 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 361 362 363SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p1'| 364SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 365p1 def mysqltest1 p1 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 366DECLARE �����1 CHAR(10); 367SELECT 368COLLATION(�����1) AS c1, 369COLLATION(�����1) AS c2, 370COLLATION(�����2) AS c3; 371SELECT 372COLLATION('�����') AS c4, 373COLLATION( '�����') AS c5, 374COLLATION( '�����') AS c6, 375@@collation_connection AS c7, 376@@character_set_client AS c8; 377SET �����1 = 'a'; 378SET �����2 = 'b'; 379END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 380 381SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p2'| 382SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 383p2 def mysqltest1 p2 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 384DECLARE �����1 CHAR(10) CHARACTER SET utf8; 385SELECT 386COLLATION(�����1) AS c1, 387COLLATION(�����1) AS c2, 388COLLATION(�����2) AS c3; 389SELECT 390COLLATION('�����') AS c4, 391COLLATION( '�����') AS c5, 392COLLATION( '�����') AS c6, 393@@collation_connection AS c7, 394@@character_set_client AS c8; 395SET �����1 = 'a'; 396SET �����2 = 'b'; 397END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 398 399SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p3'| 400SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 401p3 def mysqltest2 p3 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 402DECLARE �����1 CHAR(10); 403SELECT 404COLLATION(�����1) AS c1, 405COLLATION(�����1) AS c2, 406COLLATION(�����2) AS c3; 407SELECT 408COLLATION('�����') AS c4, 409COLLATION( '�����') AS c5, 410COLLATION( '�����') AS c6, 411@@collation_connection AS c7, 412@@character_set_client AS c8; 413SET �����1 = 'a'; 414SET �����2 = 'b'; 415END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 416 417SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p4'| 418SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 419p4 def mysqltest2 p4 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 420DECLARE �����1 CHAR(10) CHARACTER SET utf8; 421SELECT 422COLLATION(�����1) AS c1, 423COLLATION(�����1) AS c2, 424COLLATION(�����2) AS c3; 425SELECT 426COLLATION('�����') AS c4, 427COLLATION( '�����') AS c5, 428COLLATION( '�����') AS c6, 429@@collation_connection AS c7, 430@@character_set_client AS c8; 431SET �����1 = 'a'; 432SET �����2 = 'b'; 433END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 434 435 436SET @a = '1'| 437SET @b = '2'| 438 439 440CALL p1(@a, @b)| 441c1 c2 c3 442utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 443c4 c5 c6 c7 c8 444koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 445SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 446ca cb 447utf8_unicode_ci utf8_unicode_ci 448 449CALL p2(@a, @b)| 450c1 c2 c3 451utf8_general_ci utf8_general_ci utf8_general_ci 452c4 c5 c6 c7 c8 453koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 454SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 455ca cb 456utf8_general_ci utf8_general_ci 457 458CALL mysqltest2.p3(@a, @b)| 459c1 c2 c3 460utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 461c4 c5 c6 c7 c8 462koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 463SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 464ca cb 465utf8_unicode_ci utf8_unicode_ci 466 467CALL mysqltest2.p4(@a, @b)| 468c1 c2 c3 469utf8_general_ci utf8_general_ci utf8_general_ci 470c4 c5 c6 c7 c8 471koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 472SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 473ca cb 474utf8_general_ci utf8_general_ci 475 476 477ALTER DATABASE mysqltest1 COLLATE cp866_general_ci| 478ALTER DATABASE mysqltest2 COLLATE cp866_general_ci| 479connect con2,localhost,root,,mysqltest1; 480SET @@character_set_client= cp1251| 481SET @@character_set_results= cp1251| 482SET @@collation_connection= cp1251_general_ci| 483CALL p1(@a, @b)| 484c1 c2 c3 485utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 486c4 c5 c6 c7 c8 487koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 488CALL p2(@a, @b)| 489c1 c2 c3 490utf8_general_ci utf8_general_ci utf8_general_ci 491c4 c5 c6 c7 c8 492koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 493CALL mysqltest2.p3(@a, @b)| 494c1 c2 c3 495utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 496c4 c5 c6 c7 c8 497koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 498CALL mysqltest2.p4(@a, @b)| 499c1 c2 c3 500utf8_general_ci utf8_general_ci utf8_general_ci 501c4 c5 c6 c7 c8 502koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 503set names koi8r| 504 505 506SHOW CREATE PROCEDURE p1| 507Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 508p1 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`( 509INOUT �����1 CHAR(10), 510OUT �����2 CHAR(10)) 511BEGIN 512DECLARE �����1 CHAR(10); 513SELECT 514COLLATION(�����1) AS c1, 515COLLATION(�����1) AS c2, 516COLLATION(�����2) AS c3; 517SELECT 518COLLATION('�����') AS c4, 519COLLATION(_koi8r '�����') AS c5, 520COLLATION(_utf8 'текст') AS c6, 521@@collation_connection AS c7, 522@@character_set_client AS c8; 523SET �����1 = 'a'; 524SET �����2 = 'b'; 525END koi8r koi8r_general_ci utf8_unicode_ci 526 527SHOW CREATE PROCEDURE p2| 528Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 529p2 CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`( 530INOUT �����1 CHAR(10) CHARACTER SET utf8, 531OUT �����2 CHAR(10) CHARACTER SET utf8) 532BEGIN 533DECLARE �����1 CHAR(10) CHARACTER SET utf8; 534SELECT 535COLLATION(�����1) AS c1, 536COLLATION(�����1) AS c2, 537COLLATION(�����2) AS c3; 538SELECT 539COLLATION('�����') AS c4, 540COLLATION(_koi8r '�����') AS c5, 541COLLATION(_utf8 'текст') AS c6, 542@@collation_connection AS c7, 543@@character_set_client AS c8; 544SET �����1 = 'a'; 545SET �����2 = 'b'; 546END koi8r koi8r_general_ci utf8_unicode_ci 547 548SHOW CREATE PROCEDURE mysqltest2.p3| 549Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 550p3 CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`( 551INOUT �����1 CHAR(10), 552OUT �����2 CHAR(10)) 553BEGIN 554DECLARE �����1 CHAR(10); 555SELECT 556COLLATION(�����1) AS c1, 557COLLATION(�����1) AS c2, 558COLLATION(�����2) AS c3; 559SELECT 560COLLATION('�����') AS c4, 561COLLATION(_koi8r '�����') AS c5, 562COLLATION(_utf8 'текст') AS c6, 563@@collation_connection AS c7, 564@@character_set_client AS c8; 565SET �����1 = 'a'; 566SET �����2 = 'b'; 567END koi8r koi8r_general_ci utf8_unicode_ci 568 569SHOW CREATE PROCEDURE mysqltest2.p4| 570Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 571p4 CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`( 572INOUT �����1 CHAR(10) CHARACTER SET utf8, 573OUT �����2 CHAR(10) CHARACTER SET utf8) 574BEGIN 575DECLARE �����1 CHAR(10) CHARACTER SET utf8; 576SELECT 577COLLATION(�����1) AS c1, 578COLLATION(�����1) AS c2, 579COLLATION(�����2) AS c3; 580SELECT 581COLLATION('�����') AS c4, 582COLLATION(_koi8r '�����') AS c5, 583COLLATION(_utf8 'текст') AS c6, 584@@collation_connection AS c7, 585@@character_set_client AS c8; 586SET �����1 = 'a'; 587SET �����2 = 'b'; 588END koi8r koi8r_general_ci utf8_unicode_ci 589 590 591SHOW PROCEDURE STATUS LIKE 'p1'| 592Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 593mysqltest1 p1 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 594 595SHOW PROCEDURE STATUS LIKE 'p2'| 596Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 597mysqltest1 p2 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 598 599SHOW PROCEDURE STATUS LIKE 'p3'| 600Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 601mysqltest2 p3 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 602 603SHOW PROCEDURE STATUS LIKE 'p4'| 604Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 605mysqltest2 p4 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 606 607 608SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p1'| 609SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 610p1 def mysqltest1 p1 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 611DECLARE �����1 CHAR(10); 612SELECT 613COLLATION(�����1) AS c1, 614COLLATION(�����1) AS c2, 615COLLATION(�����2) AS c3; 616SELECT 617COLLATION('�����') AS c4, 618COLLATION( '�����') AS c5, 619COLLATION( '�����') AS c6, 620@@collation_connection AS c7, 621@@character_set_client AS c8; 622SET �����1 = 'a'; 623SET �����2 = 'b'; 624END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 625 626SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p2'| 627SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 628p2 def mysqltest1 p2 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 629DECLARE �����1 CHAR(10) CHARACTER SET utf8; 630SELECT 631COLLATION(�����1) AS c1, 632COLLATION(�����1) AS c2, 633COLLATION(�����2) AS c3; 634SELECT 635COLLATION('�����') AS c4, 636COLLATION( '�����') AS c5, 637COLLATION( '�����') AS c6, 638@@collation_connection AS c7, 639@@character_set_client AS c8; 640SET �����1 = 'a'; 641SET �����2 = 'b'; 642END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 643 644SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p3'| 645SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 646p3 def mysqltest2 p3 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 647DECLARE �����1 CHAR(10); 648SELECT 649COLLATION(�����1) AS c1, 650COLLATION(�����1) AS c2, 651COLLATION(�����2) AS c3; 652SELECT 653COLLATION('�����') AS c4, 654COLLATION( '�����') AS c5, 655COLLATION( '�����') AS c6, 656@@collation_connection AS c7, 657@@character_set_client AS c8; 658SET �����1 = 'a'; 659SET �����2 = 'b'; 660END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 661 662SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p4'| 663SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 664p4 def mysqltest2 p4 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 665DECLARE �����1 CHAR(10) CHARACTER SET utf8; 666SELECT 667COLLATION(�����1) AS c1, 668COLLATION(�����1) AS c2, 669COLLATION(�����2) AS c3; 670SELECT 671COLLATION('�����') AS c4, 672COLLATION( '�����') AS c5, 673COLLATION( '�����') AS c6, 674@@collation_connection AS c7, 675@@character_set_client AS c8; 676SET �����1 = 'a'; 677SET �����2 = 'b'; 678END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 679 680 681SET @a = '1'| 682SET @b = '2'| 683 684 685CALL p1(@a, @b)| 686c1 c2 c3 687utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 688c4 c5 c6 c7 c8 689koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 690SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 691ca cb 692utf8_unicode_ci utf8_unicode_ci 693 694CALL p2(@a, @b)| 695c1 c2 c3 696utf8_general_ci utf8_general_ci utf8_general_ci 697c4 c5 c6 c7 c8 698koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 699SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 700ca cb 701utf8_general_ci utf8_general_ci 702 703CALL mysqltest2.p3(@a, @b)| 704c1 c2 c3 705utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 706c4 c5 c6 c7 c8 707koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 708SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 709ca cb 710utf8_unicode_ci utf8_unicode_ci 711 712CALL mysqltest2.p4(@a, @b)| 713c1 c2 c3 714utf8_general_ci utf8_general_ci utf8_general_ci 715c4 c5 c6 c7 c8 716koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 717SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 718ca cb 719utf8_general_ci utf8_general_ci 720 721---> Dump of mysqltest1 722 723CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp866 */; 724 725USE `mysqltest1`; 726ALTER DATABASE `mysqltest1` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 727/*!50003 SET @saved_cs_client = @@character_set_client */ ; 728/*!50003 SET @saved_cs_results = @@character_set_results */ ; 729/*!50003 SET @saved_col_connection = @@collation_connection */ ; 730/*!50003 SET character_set_client = koi8r */ ; 731/*!50003 SET character_set_results = koi8r */ ; 732/*!50003 SET collation_connection = koi8r_general_ci */ ; 733/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 734/*!50003 SET sql_mode = '' */ ; 735DELIMITER ;; 736CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`( 737INOUT �����1 CHAR(10), 738OUT �����2 CHAR(10)) 739BEGIN 740DECLARE �����1 CHAR(10); 741SELECT 742COLLATION(�����1) AS c1, 743COLLATION(�����1) AS c2, 744COLLATION(�����2) AS c3; 745SELECT 746COLLATION('�����') AS c4, 747COLLATION(_koi8r '�����') AS c5, 748COLLATION(_utf8 'текст') AS c6, 749@@collation_connection AS c7, 750@@character_set_client AS c8; 751SET �����1 = 'a'; 752SET �����2 = 'b'; 753END ;; 754DELIMITER ; 755/*!50003 SET sql_mode = @saved_sql_mode */ ; 756/*!50003 SET character_set_client = @saved_cs_client */ ; 757/*!50003 SET character_set_results = @saved_cs_results */ ; 758/*!50003 SET collation_connection = @saved_col_connection */ ; 759ALTER DATABASE `mysqltest1` CHARACTER SET cp866 COLLATE cp866_general_ci ; 760ALTER DATABASE `mysqltest1` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 761/*!50003 SET @saved_cs_client = @@character_set_client */ ; 762/*!50003 SET @saved_cs_results = @@character_set_results */ ; 763/*!50003 SET @saved_col_connection = @@collation_connection */ ; 764/*!50003 SET character_set_client = koi8r */ ; 765/*!50003 SET character_set_results = koi8r */ ; 766/*!50003 SET collation_connection = koi8r_general_ci */ ; 767/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 768/*!50003 SET sql_mode = '' */ ; 769DELIMITER ;; 770CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`( 771INOUT �����1 CHAR(10) CHARACTER SET utf8, 772OUT �����2 CHAR(10) CHARACTER SET utf8) 773BEGIN 774DECLARE �����1 CHAR(10) CHARACTER SET utf8; 775SELECT 776COLLATION(�����1) AS c1, 777COLLATION(�����1) AS c2, 778COLLATION(�����2) AS c3; 779SELECT 780COLLATION('�����') AS c4, 781COLLATION(_koi8r '�����') AS c5, 782COLLATION(_utf8 'текст') AS c6, 783@@collation_connection AS c7, 784@@character_set_client AS c8; 785SET �����1 = 'a'; 786SET �����2 = 'b'; 787END ;; 788DELIMITER ; 789/*!50003 SET sql_mode = @saved_sql_mode */ ; 790/*!50003 SET character_set_client = @saved_cs_client */ ; 791/*!50003 SET character_set_results = @saved_cs_results */ ; 792/*!50003 SET collation_connection = @saved_col_connection */ ; 793ALTER DATABASE `mysqltest1` CHARACTER SET cp866 COLLATE cp866_general_ci ; 794 795---> Dumping mysqltest1 to ddl_i18n_koi8r.sp.mysqltest1.sql 796 797---> Dump of mysqltest2 798 799CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest2` /*!40100 DEFAULT CHARACTER SET cp866 */; 800 801USE `mysqltest2`; 802ALTER DATABASE `mysqltest2` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 803/*!50003 SET @saved_cs_client = @@character_set_client */ ; 804/*!50003 SET @saved_cs_results = @@character_set_results */ ; 805/*!50003 SET @saved_col_connection = @@collation_connection */ ; 806/*!50003 SET character_set_client = koi8r */ ; 807/*!50003 SET character_set_results = koi8r */ ; 808/*!50003 SET collation_connection = koi8r_general_ci */ ; 809/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 810/*!50003 SET sql_mode = '' */ ; 811DELIMITER ;; 812CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`( 813INOUT �����1 CHAR(10), 814OUT �����2 CHAR(10)) 815BEGIN 816DECLARE �����1 CHAR(10); 817SELECT 818COLLATION(�����1) AS c1, 819COLLATION(�����1) AS c2, 820COLLATION(�����2) AS c3; 821SELECT 822COLLATION('�����') AS c4, 823COLLATION(_koi8r '�����') AS c5, 824COLLATION(_utf8 'текст') AS c6, 825@@collation_connection AS c7, 826@@character_set_client AS c8; 827SET �����1 = 'a'; 828SET �����2 = 'b'; 829END ;; 830DELIMITER ; 831/*!50003 SET sql_mode = @saved_sql_mode */ ; 832/*!50003 SET character_set_client = @saved_cs_client */ ; 833/*!50003 SET character_set_results = @saved_cs_results */ ; 834/*!50003 SET collation_connection = @saved_col_connection */ ; 835ALTER DATABASE `mysqltest2` CHARACTER SET cp866 COLLATE cp866_general_ci ; 836ALTER DATABASE `mysqltest2` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 837/*!50003 SET @saved_cs_client = @@character_set_client */ ; 838/*!50003 SET @saved_cs_results = @@character_set_results */ ; 839/*!50003 SET @saved_col_connection = @@collation_connection */ ; 840/*!50003 SET character_set_client = koi8r */ ; 841/*!50003 SET character_set_results = koi8r */ ; 842/*!50003 SET collation_connection = koi8r_general_ci */ ; 843/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 844/*!50003 SET sql_mode = '' */ ; 845DELIMITER ;; 846CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`( 847INOUT �����1 CHAR(10) CHARACTER SET utf8, 848OUT �����2 CHAR(10) CHARACTER SET utf8) 849BEGIN 850DECLARE �����1 CHAR(10) CHARACTER SET utf8; 851SELECT 852COLLATION(�����1) AS c1, 853COLLATION(�����1) AS c2, 854COLLATION(�����2) AS c3; 855SELECT 856COLLATION('�����') AS c4, 857COLLATION(_koi8r '�����') AS c5, 858COLLATION(_utf8 'текст') AS c6, 859@@collation_connection AS c7, 860@@character_set_client AS c8; 861SET �����1 = 'a'; 862SET �����2 = 'b'; 863END ;; 864DELIMITER ; 865/*!50003 SET sql_mode = @saved_sql_mode */ ; 866/*!50003 SET character_set_client = @saved_cs_client */ ; 867/*!50003 SET character_set_results = @saved_cs_results */ ; 868/*!50003 SET collation_connection = @saved_col_connection */ ; 869ALTER DATABASE `mysqltest2` CHARACTER SET cp866 COLLATE cp866_general_ci ; 870 871---> Dumping mysqltest2 to ddl_i18n_koi8r.sp.mysqltest2.sql 872 873 874DROP DATABASE mysqltest1| 875DROP DATABASE mysqltest2| 876 877 878---> Restoring mysqltest1... 879---> Restoring mysqltest2... 880connect con3,localhost,root,,mysqltest1; 881SET @@character_set_client= cp1251| 882SET @@character_set_results= cp1251| 883SET @@collation_connection= cp1251_general_ci| 884CALL p1(@a, @b)| 885c1 c2 c3 886utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 887c4 c5 c6 c7 c8 888koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 889CALL p2(@a, @b)| 890c1 c2 c3 891utf8_general_ci utf8_general_ci utf8_general_ci 892c4 c5 c6 c7 c8 893koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 894CALL mysqltest2.p3(@a, @b)| 895c1 c2 c3 896utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 897c4 c5 c6 c7 c8 898koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 899CALL mysqltest2.p4(@a, @b)| 900c1 c2 c3 901utf8_general_ci utf8_general_ci utf8_general_ci 902c4 c5 c6 c7 c8 903koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 904set names koi8r| 905 906 907SHOW CREATE PROCEDURE p1| 908Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 909p1 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`( 910INOUT �����1 CHAR(10), 911OUT �����2 CHAR(10)) 912BEGIN 913DECLARE �����1 CHAR(10); 914SELECT 915COLLATION(�����1) AS c1, 916COLLATION(�����1) AS c2, 917COLLATION(�����2) AS c3; 918SELECT 919COLLATION('�����') AS c4, 920COLLATION(_koi8r '�����') AS c5, 921COLLATION(_utf8 'текст') AS c6, 922@@collation_connection AS c7, 923@@character_set_client AS c8; 924SET �����1 = 'a'; 925SET �����2 = 'b'; 926END koi8r koi8r_general_ci utf8_unicode_ci 927 928SHOW CREATE PROCEDURE p2| 929Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 930p2 CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`( 931INOUT �����1 CHAR(10) CHARACTER SET utf8, 932OUT �����2 CHAR(10) CHARACTER SET utf8) 933BEGIN 934DECLARE �����1 CHAR(10) CHARACTER SET utf8; 935SELECT 936COLLATION(�����1) AS c1, 937COLLATION(�����1) AS c2, 938COLLATION(�����2) AS c3; 939SELECT 940COLLATION('�����') AS c4, 941COLLATION(_koi8r '�����') AS c5, 942COLLATION(_utf8 'текст') AS c6, 943@@collation_connection AS c7, 944@@character_set_client AS c8; 945SET �����1 = 'a'; 946SET �����2 = 'b'; 947END koi8r koi8r_general_ci utf8_unicode_ci 948 949SHOW CREATE PROCEDURE mysqltest2.p3| 950Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 951p3 CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`( 952INOUT �����1 CHAR(10), 953OUT �����2 CHAR(10)) 954BEGIN 955DECLARE �����1 CHAR(10); 956SELECT 957COLLATION(�����1) AS c1, 958COLLATION(�����1) AS c2, 959COLLATION(�����2) AS c3; 960SELECT 961COLLATION('�����') AS c4, 962COLLATION(_koi8r '�����') AS c5, 963COLLATION(_utf8 'текст') AS c6, 964@@collation_connection AS c7, 965@@character_set_client AS c8; 966SET �����1 = 'a'; 967SET �����2 = 'b'; 968END koi8r koi8r_general_ci utf8_unicode_ci 969 970SHOW CREATE PROCEDURE mysqltest2.p4| 971Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation 972p4 CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`( 973INOUT �����1 CHAR(10) CHARACTER SET utf8, 974OUT �����2 CHAR(10) CHARACTER SET utf8) 975BEGIN 976DECLARE �����1 CHAR(10) CHARACTER SET utf8; 977SELECT 978COLLATION(�����1) AS c1, 979COLLATION(�����1) AS c2, 980COLLATION(�����2) AS c3; 981SELECT 982COLLATION('�����') AS c4, 983COLLATION(_koi8r '�����') AS c5, 984COLLATION(_utf8 'текст') AS c6, 985@@collation_connection AS c7, 986@@character_set_client AS c8; 987SET �����1 = 'a'; 988SET �����2 = 'b'; 989END koi8r koi8r_general_ci utf8_unicode_ci 990 991 992SHOW PROCEDURE STATUS LIKE 'p1'| 993Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 994mysqltest1 p1 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 995 996SHOW PROCEDURE STATUS LIKE 'p2'| 997Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 998mysqltest1 p2 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 999 1000SHOW PROCEDURE STATUS LIKE 'p3'| 1001Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 1002mysqltest2 p3 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 1003 1004SHOW PROCEDURE STATUS LIKE 'p4'| 1005Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation 1006mysqltest2 p4 PROCEDURE root@localhost MODIFIED CREATED DEFINER koi8r koi8r_general_ci utf8_unicode_ci 1007 1008 1009SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p1'| 1010SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1011p1 def mysqltest1 p1 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 1012DECLARE �����1 CHAR(10); 1013SELECT 1014COLLATION(�����1) AS c1, 1015COLLATION(�����1) AS c2, 1016COLLATION(�����2) AS c3; 1017SELECT 1018COLLATION('�����') AS c4, 1019COLLATION( '�����') AS c5, 1020COLLATION( '�����') AS c6, 1021@@collation_connection AS c7, 1022@@character_set_client AS c8; 1023SET �����1 = 'a'; 1024SET �����2 = 'b'; 1025END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1026 1027SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p2'| 1028SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1029p2 def mysqltest1 p2 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 1030DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1031SELECT 1032COLLATION(�����1) AS c1, 1033COLLATION(�����1) AS c2, 1034COLLATION(�����2) AS c3; 1035SELECT 1036COLLATION('�����') AS c4, 1037COLLATION( '�����') AS c5, 1038COLLATION( '�����') AS c6, 1039@@collation_connection AS c7, 1040@@character_set_client AS c8; 1041SET �����1 = 'a'; 1042SET �����2 = 'b'; 1043END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1044 1045SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p3'| 1046SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1047p3 def mysqltest2 p3 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 1048DECLARE �����1 CHAR(10); 1049SELECT 1050COLLATION(�����1) AS c1, 1051COLLATION(�����1) AS c2, 1052COLLATION(�����2) AS c3; 1053SELECT 1054COLLATION('�����') AS c4, 1055COLLATION( '�����') AS c5, 1056COLLATION( '�����') AS c6, 1057@@collation_connection AS c7, 1058@@character_set_client AS c8; 1059SET �����1 = 'a'; 1060SET �����2 = 'b'; 1061END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1062 1063SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p4'| 1064SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1065p4 def mysqltest2 p4 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN 1066DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1067SELECT 1068COLLATION(�����1) AS c1, 1069COLLATION(�����1) AS c2, 1070COLLATION(�����2) AS c3; 1071SELECT 1072COLLATION('�����') AS c4, 1073COLLATION( '�����') AS c5, 1074COLLATION( '�����') AS c6, 1075@@collation_connection AS c7, 1076@@character_set_client AS c8; 1077SET �����1 = 'a'; 1078SET �����2 = 'b'; 1079END NULL NULL SQL NO CONTAINS SQL NULL DEFINER CREATED ALTERED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1080 1081 1082SET @a = '1'| 1083SET @b = '2'| 1084 1085 1086CALL p1(@a, @b)| 1087c1 c2 c3 1088utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 1089c4 c5 c6 c7 c8 1090koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 1091SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 1092ca cb 1093utf8_unicode_ci utf8_unicode_ci 1094 1095CALL p2(@a, @b)| 1096c1 c2 c3 1097utf8_general_ci utf8_general_ci utf8_general_ci 1098c4 c5 c6 c7 c8 1099koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 1100SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 1101ca cb 1102utf8_general_ci utf8_general_ci 1103 1104CALL mysqltest2.p3(@a, @b)| 1105c1 c2 c3 1106utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 1107c4 c5 c6 c7 c8 1108koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 1109SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 1110ca cb 1111utf8_unicode_ci utf8_unicode_ci 1112 1113CALL mysqltest2.p4(@a, @b)| 1114c1 c2 c3 1115utf8_general_ci utf8_general_ci utf8_general_ci 1116c4 c5 c6 c7 c8 1117koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r 1118SELECT COLLATION(@a) AS ca, COLLATION(@b) cb| 1119ca cb 1120utf8_general_ci utf8_general_ci 1121connection default; 1122disconnect con2; 1123disconnect con3; 1124use test| 1125DROP DATABASE mysqltest1| 1126DROP DATABASE mysqltest2| 1127 1128------------------------------------------------------------------- 1129Triggers 1130------------------------------------------------------------------- 1131 1132DROP DATABASE IF EXISTS mysqltest1| 1133DROP DATABASE IF EXISTS mysqltest2| 1134CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 1135CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 1136use mysqltest1| 1137CREATE TABLE t1(c INT)| 1138CREATE TABLE mysqltest2.t1(c INT)| 1139CREATE TABLE log(msg VARCHAR(255))| 1140CREATE TABLE mysqltest2.log(msg VARCHAR(255))| 1141 1142CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW 1143BEGIN 1144DECLARE �����1 CHAR(10); 1145INSERT INTO log VALUES(COLLATION(�����1)); 1146INSERT INTO log VALUES(COLLATION('�����')); 1147INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1148INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1149INSERT INTO log VALUES(@@collation_connection); 1150INSERT INTO log VALUES(@@character_set_client); 1151SET @a1 = '�����'; 1152SET @a1 = _koi8r '�����'; 1153SET @a2 = _utf8 'текст'; 1154END| 1155 1156CREATE TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW 1157BEGIN 1158DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1159INSERT INTO log VALUES(COLLATION(�����1)); 1160INSERT INTO log VALUES(COLLATION('�����')); 1161INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1162INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1163INSERT INTO log VALUES(@@collation_connection); 1164INSERT INTO log VALUES(@@character_set_client); 1165SET @b1 = '�����'; 1166SET @b1 = _koi8r '�����'; 1167SET @b2 = _utf8 'текст'; 1168END| 1169 1170CREATE TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW 1171BEGIN 1172DECLARE �����1 CHAR(10); 1173INSERT INTO log VALUES(COLLATION(�����1)); 1174INSERT INTO log VALUES(COLLATION('�����')); 1175INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1176INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1177INSERT INTO log VALUES(@@collation_connection); 1178INSERT INTO log VALUES(@@character_set_client); 1179SET @a1 = '�����'; 1180SET @a1 = _koi8r '�����'; 1181SET @a2 = _utf8 'текст'; 1182END| 1183 1184CREATE TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW 1185BEGIN 1186DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1187INSERT INTO log VALUES(COLLATION(�����1)); 1188INSERT INTO log VALUES(COLLATION('�����')); 1189INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1190INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1191INSERT INTO log VALUES(@@collation_connection); 1192INSERT INTO log VALUES(@@character_set_client); 1193SET @b1 = '�����'; 1194SET @b1 = _koi8r '�����'; 1195SET @b2 = _utf8 'текст'; 1196END| 1197 1198 1199 1200SHOW CREATE TRIGGER trg1| 1201Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1202trg1 CREATE DEFINER=`root`@`localhost` TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW 1203BEGIN 1204DECLARE �����1 CHAR(10); 1205INSERT INTO log VALUES(COLLATION(�����1)); 1206INSERT INTO log VALUES(COLLATION('�����')); 1207INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1208INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1209INSERT INTO log VALUES(@@collation_connection); 1210INSERT INTO log VALUES(@@character_set_client); 1211SET @a1 = '�����'; 1212SET @a1 = _koi8r '�����'; 1213SET @a2 = _utf8 'текст'; 1214END koi8r koi8r_general_ci utf8_unicode_ci # 1215 1216SHOW CREATE TRIGGER trg2| 1217Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1218trg2 CREATE DEFINER=`root`@`localhost` TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW 1219BEGIN 1220DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1221INSERT INTO log VALUES(COLLATION(�����1)); 1222INSERT INTO log VALUES(COLLATION('�����')); 1223INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1224INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1225INSERT INTO log VALUES(@@collation_connection); 1226INSERT INTO log VALUES(@@character_set_client); 1227SET @b1 = '�����'; 1228SET @b1 = _koi8r '�����'; 1229SET @b2 = _utf8 'текст'; 1230END koi8r koi8r_general_ci utf8_unicode_ci # 1231 1232SHOW CREATE TRIGGER mysqltest2.trg3| 1233Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1234trg3 CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW 1235BEGIN 1236DECLARE �����1 CHAR(10); 1237INSERT INTO log VALUES(COLLATION(�����1)); 1238INSERT INTO log VALUES(COLLATION('�����')); 1239INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1240INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1241INSERT INTO log VALUES(@@collation_connection); 1242INSERT INTO log VALUES(@@character_set_client); 1243SET @a1 = '�����'; 1244SET @a1 = _koi8r '�����'; 1245SET @a2 = _utf8 'текст'; 1246END koi8r koi8r_general_ci utf8_unicode_ci # 1247 1248SHOW CREATE TRIGGER mysqltest2.trg4| 1249Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1250trg4 CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW 1251BEGIN 1252DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1253INSERT INTO log VALUES(COLLATION(�����1)); 1254INSERT INTO log VALUES(COLLATION('�����')); 1255INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1256INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1257INSERT INTO log VALUES(@@collation_connection); 1258INSERT INTO log VALUES(@@character_set_client); 1259SET @b1 = '�����'; 1260SET @b1 = _koi8r '�����'; 1261SET @b2 = _utf8 'текст'; 1262END koi8r koi8r_general_ci utf8_unicode_ci # 1263 1264 1265SHOW TRIGGERS| 1266Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 1267trg1 INSERT t1 BEGIN 1268DECLARE �����1 CHAR(10); 1269INSERT INTO log VALUES(COLLATION(�����1)); 1270INSERT INTO log VALUES(COLLATION('�����')); 1271INSERT INTO log VALUES(COLLATION( '�����')); 1272INSERT INTO log VALUES(COLLATION( '�����')); 1273INSERT INTO log VALUES(@@collation_connection); 1274INSERT INTO log VALUES(@@character_set_client); 1275SET @a1 = '�����'; 1276SET @a1 = '�����'; 1277SET @a2 = '�����'; 1278END BEFORE # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1279trg2 INSERT t1 BEGIN 1280DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1281INSERT INTO log VALUES(COLLATION(�����1)); 1282INSERT INTO log VALUES(COLLATION('�����')); 1283INSERT INTO log VALUES(COLLATION( '�����')); 1284INSERT INTO log VALUES(COLLATION( '�����')); 1285INSERT INTO log VALUES(@@collation_connection); 1286INSERT INTO log VALUES(@@character_set_client); 1287SET @b1 = '�����'; 1288SET @b1 = '�����'; 1289SET @b2 = '�����'; 1290END AFTER # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1291 1292use mysqltest2| 1293 1294SHOW TRIGGERS| 1295Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 1296trg3 INSERT t1 BEGIN 1297DECLARE �����1 CHAR(10); 1298INSERT INTO log VALUES(COLLATION(�����1)); 1299INSERT INTO log VALUES(COLLATION('�����')); 1300INSERT INTO log VALUES(COLLATION( '�����')); 1301INSERT INTO log VALUES(COLLATION( '�����')); 1302INSERT INTO log VALUES(@@collation_connection); 1303INSERT INTO log VALUES(@@character_set_client); 1304SET @a1 = '�����'; 1305SET @a1 = '�����'; 1306SET @a2 = '�����'; 1307END BEFORE # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1308trg4 INSERT t1 BEGIN 1309DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1310INSERT INTO log VALUES(COLLATION(�����1)); 1311INSERT INTO log VALUES(COLLATION('�����')); 1312INSERT INTO log VALUES(COLLATION( '�����')); 1313INSERT INTO log VALUES(COLLATION( '�����')); 1314INSERT INTO log VALUES(@@collation_connection); 1315INSERT INTO log VALUES(@@character_set_client); 1316SET @b1 = '�����'; 1317SET @b1 = '�����'; 1318SET @b2 = '�����'; 1319END AFTER # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1320use mysqltest1| 1321 1322 1323SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'| 1324TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1325def mysqltest1 trg1 INSERT def mysqltest1 t1 1 NULL BEGIN 1326DECLARE �����1 CHAR(10); 1327INSERT INTO log VALUES(COLLATION(�����1)); 1328INSERT INTO log VALUES(COLLATION('�����')); 1329INSERT INTO log VALUES(COLLATION( '�����')); 1330INSERT INTO log VALUES(COLLATION( '�����')); 1331INSERT INTO log VALUES(@@collation_connection); 1332INSERT INTO log VALUES(@@character_set_client); 1333SET @a1 = '�����'; 1334SET @a1 = '�����'; 1335SET @a2 = '�����'; 1336END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1337 1338SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'| 1339TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1340def mysqltest1 trg2 INSERT def mysqltest1 t1 1 NULL BEGIN 1341DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1342INSERT INTO log VALUES(COLLATION(�����1)); 1343INSERT INTO log VALUES(COLLATION('�����')); 1344INSERT INTO log VALUES(COLLATION( '�����')); 1345INSERT INTO log VALUES(COLLATION( '�����')); 1346INSERT INTO log VALUES(@@collation_connection); 1347INSERT INTO log VALUES(@@character_set_client); 1348SET @b1 = '�����'; 1349SET @b1 = '�����'; 1350SET @b2 = '�����'; 1351END ROW AFTER NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1352 1353SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'| 1354TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1355def mysqltest2 trg3 INSERT def mysqltest2 t1 1 NULL BEGIN 1356DECLARE �����1 CHAR(10); 1357INSERT INTO log VALUES(COLLATION(�����1)); 1358INSERT INTO log VALUES(COLLATION('�����')); 1359INSERT INTO log VALUES(COLLATION( '�����')); 1360INSERT INTO log VALUES(COLLATION( '�����')); 1361INSERT INTO log VALUES(@@collation_connection); 1362INSERT INTO log VALUES(@@character_set_client); 1363SET @a1 = '�����'; 1364SET @a1 = '�����'; 1365SET @a2 = '�����'; 1366END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1367 1368SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'| 1369TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1370def mysqltest2 trg4 INSERT def mysqltest2 t1 1 NULL BEGIN 1371DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1372INSERT INTO log VALUES(COLLATION(�����1)); 1373INSERT INTO log VALUES(COLLATION('�����')); 1374INSERT INTO log VALUES(COLLATION( '�����')); 1375INSERT INTO log VALUES(COLLATION( '�����')); 1376INSERT INTO log VALUES(@@collation_connection); 1377INSERT INTO log VALUES(@@character_set_client); 1378SET @b1 = '�����'; 1379SET @b1 = '�����'; 1380SET @b2 = '�����'; 1381END ROW AFTER NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1382 1383 1384SET @a1 = '1'| 1385SET @a2 = '1'| 1386SET @a3 = '1'| 1387SET @b1 = '2'| 1388SET @b2 = '2'| 1389SET @b3 = '2'| 1390 1391 1392INSERT INTO t1 VALUES(1)| 1393 1394---> Log: 1395SELECT msg FROM log| 1396msg 1397koi8r 1398koi8r 1399koi8r_general_ci 1400koi8r_general_ci 1401koi8r_general_ci 1402koi8r_general_ci 1403koi8r_general_ci 1404koi8r_general_ci 1405utf8_general_ci 1406utf8_general_ci 1407utf8_general_ci 1408utf8_unicode_ci 1409 1410SELECT 1411COLLATION(@a1) AS ca1, 1412COLLATION(@a2) AS ca2, 1413COLLATION(@a3) AS ca3, 1414COLLATION(@b1) AS cb1, 1415COLLATION(@b2) AS cb2, 1416COLLATION(@b3) AS cb3| 1417ca1 ca2 ca3 cb1 cb2 cb3 1418koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci 1419 1420DELETE FROM log| 1421 1422 1423INSERT INTO mysqltest2.t1 VALUES(1)| 1424 1425---> Log: 1426SELECT msg FROM mysqltest2.log| 1427msg 1428koi8r 1429koi8r 1430koi8r_general_ci 1431koi8r_general_ci 1432koi8r_general_ci 1433koi8r_general_ci 1434koi8r_general_ci 1435koi8r_general_ci 1436utf8_general_ci 1437utf8_general_ci 1438utf8_general_ci 1439utf8_unicode_ci 1440 1441SELECT 1442COLLATION(@a1) AS ca1, 1443COLLATION(@a2) AS ca2, 1444COLLATION(@a3) AS ca3, 1445COLLATION(@b1) AS cb1, 1446COLLATION(@b2) AS cb2, 1447COLLATION(@b3) AS cb3| 1448ca1 ca2 ca3 cb1 cb2 cb3 1449koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci 1450 1451DELETE FROM mysqltest2.log| 1452 1453 1454ALTER DATABASE mysqltest1 COLLATE cp866_general_ci| 1455ALTER DATABASE mysqltest2 COLLATE cp866_general_ci| 1456ALTER TABLE t1 ADD COLUMN fake INT| 1457ALTER TABLE t1 DROP COLUMN fake| 1458ALTER TABLE mysqltest2.t1 ADD COLUMN fake INT| 1459ALTER TABLE mysqltest2.t1 DROP COLUMN fake| 1460connect con2,localhost,root,,; 1461SET @@character_set_client= cp1251| 1462SET @@character_set_results= cp1251| 1463SET @@collation_connection= cp1251_general_ci| 1464INSERT INTO mysqltest1.t1 VALUES(0)| 1465INSERT INTO mysqltest2.t1 VALUES(0)| 1466DELETE FROM mysqltest1.log| 1467DELETE FROM mysqltest2.log| 1468set names koi8r| 1469use mysqltest1| 1470 1471 1472SHOW CREATE TRIGGER trg1| 1473Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1474trg1 CREATE DEFINER=`root`@`localhost` TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW 1475BEGIN 1476DECLARE �����1 CHAR(10); 1477INSERT INTO log VALUES(COLLATION(�����1)); 1478INSERT INTO log VALUES(COLLATION('�����')); 1479INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1480INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1481INSERT INTO log VALUES(@@collation_connection); 1482INSERT INTO log VALUES(@@character_set_client); 1483SET @a1 = '�����'; 1484SET @a1 = _koi8r '�����'; 1485SET @a2 = _utf8 'текст'; 1486END koi8r koi8r_general_ci utf8_unicode_ci # 1487 1488SHOW CREATE TRIGGER trg2| 1489Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1490trg2 CREATE DEFINER=`root`@`localhost` TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW 1491BEGIN 1492DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1493INSERT INTO log VALUES(COLLATION(�����1)); 1494INSERT INTO log VALUES(COLLATION('�����')); 1495INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1496INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1497INSERT INTO log VALUES(@@collation_connection); 1498INSERT INTO log VALUES(@@character_set_client); 1499SET @b1 = '�����'; 1500SET @b1 = _koi8r '�����'; 1501SET @b2 = _utf8 'текст'; 1502END koi8r koi8r_general_ci utf8_unicode_ci # 1503 1504SHOW CREATE TRIGGER mysqltest2.trg3| 1505Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1506trg3 CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW 1507BEGIN 1508DECLARE �����1 CHAR(10); 1509INSERT INTO log VALUES(COLLATION(�����1)); 1510INSERT INTO log VALUES(COLLATION('�����')); 1511INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1512INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1513INSERT INTO log VALUES(@@collation_connection); 1514INSERT INTO log VALUES(@@character_set_client); 1515SET @a1 = '�����'; 1516SET @a1 = _koi8r '�����'; 1517SET @a2 = _utf8 'текст'; 1518END koi8r koi8r_general_ci utf8_unicode_ci # 1519 1520SHOW CREATE TRIGGER mysqltest2.trg4| 1521Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1522trg4 CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW 1523BEGIN 1524DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1525INSERT INTO log VALUES(COLLATION(�����1)); 1526INSERT INTO log VALUES(COLLATION('�����')); 1527INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1528INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1529INSERT INTO log VALUES(@@collation_connection); 1530INSERT INTO log VALUES(@@character_set_client); 1531SET @b1 = '�����'; 1532SET @b1 = _koi8r '�����'; 1533SET @b2 = _utf8 'текст'; 1534END koi8r koi8r_general_ci utf8_unicode_ci # 1535 1536 1537SHOW TRIGGERS| 1538Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 1539trg1 INSERT t1 BEGIN 1540DECLARE �����1 CHAR(10); 1541INSERT INTO log VALUES(COLLATION(�����1)); 1542INSERT INTO log VALUES(COLLATION('�����')); 1543INSERT INTO log VALUES(COLLATION( '�����')); 1544INSERT INTO log VALUES(COLLATION( '�����')); 1545INSERT INTO log VALUES(@@collation_connection); 1546INSERT INTO log VALUES(@@character_set_client); 1547SET @a1 = '�����'; 1548SET @a1 = '�����'; 1549SET @a2 = '�����'; 1550END BEFORE # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1551trg2 INSERT t1 BEGIN 1552DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1553INSERT INTO log VALUES(COLLATION(�����1)); 1554INSERT INTO log VALUES(COLLATION('�����')); 1555INSERT INTO log VALUES(COLLATION( '�����')); 1556INSERT INTO log VALUES(COLLATION( '�����')); 1557INSERT INTO log VALUES(@@collation_connection); 1558INSERT INTO log VALUES(@@character_set_client); 1559SET @b1 = '�����'; 1560SET @b1 = '�����'; 1561SET @b2 = '�����'; 1562END AFTER # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1563 1564use mysqltest2| 1565 1566SHOW TRIGGERS| 1567Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 1568trg3 INSERT t1 BEGIN 1569DECLARE �����1 CHAR(10); 1570INSERT INTO log VALUES(COLLATION(�����1)); 1571INSERT INTO log VALUES(COLLATION('�����')); 1572INSERT INTO log VALUES(COLLATION( '�����')); 1573INSERT INTO log VALUES(COLLATION( '�����')); 1574INSERT INTO log VALUES(@@collation_connection); 1575INSERT INTO log VALUES(@@character_set_client); 1576SET @a1 = '�����'; 1577SET @a1 = '�����'; 1578SET @a2 = '�����'; 1579END BEFORE # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1580trg4 INSERT t1 BEGIN 1581DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1582INSERT INTO log VALUES(COLLATION(�����1)); 1583INSERT INTO log VALUES(COLLATION('�����')); 1584INSERT INTO log VALUES(COLLATION( '�����')); 1585INSERT INTO log VALUES(COLLATION( '�����')); 1586INSERT INTO log VALUES(@@collation_connection); 1587INSERT INTO log VALUES(@@character_set_client); 1588SET @b1 = '�����'; 1589SET @b1 = '�����'; 1590SET @b2 = '�����'; 1591END AFTER # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1592use mysqltest1| 1593 1594 1595SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'| 1596TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1597def mysqltest1 trg1 INSERT def mysqltest1 t1 1 NULL BEGIN 1598DECLARE �����1 CHAR(10); 1599INSERT INTO log VALUES(COLLATION(�����1)); 1600INSERT INTO log VALUES(COLLATION('�����')); 1601INSERT INTO log VALUES(COLLATION( '�����')); 1602INSERT INTO log VALUES(COLLATION( '�����')); 1603INSERT INTO log VALUES(@@collation_connection); 1604INSERT INTO log VALUES(@@character_set_client); 1605SET @a1 = '�����'; 1606SET @a1 = '�����'; 1607SET @a2 = '�����'; 1608END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1609 1610SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'| 1611TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1612def mysqltest1 trg2 INSERT def mysqltest1 t1 1 NULL BEGIN 1613DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1614INSERT INTO log VALUES(COLLATION(�����1)); 1615INSERT INTO log VALUES(COLLATION('�����')); 1616INSERT INTO log VALUES(COLLATION( '�����')); 1617INSERT INTO log VALUES(COLLATION( '�����')); 1618INSERT INTO log VALUES(@@collation_connection); 1619INSERT INTO log VALUES(@@character_set_client); 1620SET @b1 = '�����'; 1621SET @b1 = '�����'; 1622SET @b2 = '�����'; 1623END ROW AFTER NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1624 1625SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'| 1626TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1627def mysqltest2 trg3 INSERT def mysqltest2 t1 1 NULL BEGIN 1628DECLARE �����1 CHAR(10); 1629INSERT INTO log VALUES(COLLATION(�����1)); 1630INSERT INTO log VALUES(COLLATION('�����')); 1631INSERT INTO log VALUES(COLLATION( '�����')); 1632INSERT INTO log VALUES(COLLATION( '�����')); 1633INSERT INTO log VALUES(@@collation_connection); 1634INSERT INTO log VALUES(@@character_set_client); 1635SET @a1 = '�����'; 1636SET @a1 = '�����'; 1637SET @a2 = '�����'; 1638END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1639 1640SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'| 1641TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 1642def mysqltest2 trg4 INSERT def mysqltest2 t1 1 NULL BEGIN 1643DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1644INSERT INTO log VALUES(COLLATION(�����1)); 1645INSERT INTO log VALUES(COLLATION('�����')); 1646INSERT INTO log VALUES(COLLATION( '�����')); 1647INSERT INTO log VALUES(COLLATION( '�����')); 1648INSERT INTO log VALUES(@@collation_connection); 1649INSERT INTO log VALUES(@@character_set_client); 1650SET @b1 = '�����'; 1651SET @b1 = '�����'; 1652SET @b2 = '�����'; 1653END ROW AFTER NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1654 1655 1656SET @a1 = '1'| 1657SET @a2 = '1'| 1658SET @a3 = '1'| 1659SET @b1 = '2'| 1660SET @b2 = '2'| 1661SET @b3 = '2'| 1662 1663 1664INSERT INTO t1 VALUES(1)| 1665 1666---> Log: 1667SELECT msg FROM log| 1668msg 1669koi8r 1670koi8r 1671koi8r_general_ci 1672koi8r_general_ci 1673koi8r_general_ci 1674koi8r_general_ci 1675koi8r_general_ci 1676koi8r_general_ci 1677utf8_general_ci 1678utf8_general_ci 1679utf8_general_ci 1680utf8_unicode_ci 1681 1682SELECT 1683COLLATION(@a1) AS ca1, 1684COLLATION(@a2) AS ca2, 1685COLLATION(@a3) AS ca3, 1686COLLATION(@b1) AS cb1, 1687COLLATION(@b2) AS cb2, 1688COLLATION(@b3) AS cb3| 1689ca1 ca2 ca3 cb1 cb2 cb3 1690koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci 1691 1692DELETE FROM log| 1693 1694 1695INSERT INTO mysqltest2.t1 VALUES(1)| 1696 1697---> Log: 1698SELECT msg FROM mysqltest2.log| 1699msg 1700koi8r 1701koi8r 1702koi8r_general_ci 1703koi8r_general_ci 1704koi8r_general_ci 1705koi8r_general_ci 1706koi8r_general_ci 1707koi8r_general_ci 1708utf8_general_ci 1709utf8_general_ci 1710utf8_general_ci 1711utf8_unicode_ci 1712 1713SELECT 1714COLLATION(@a1) AS ca1, 1715COLLATION(@a2) AS ca2, 1716COLLATION(@a3) AS ca3, 1717COLLATION(@b1) AS cb1, 1718COLLATION(@b2) AS cb2, 1719COLLATION(@b3) AS cb3| 1720ca1 ca2 ca3 cb1 cb2 cb3 1721koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci 1722 1723DELETE FROM mysqltest2.log| 1724 1725---> Dump of mysqltest1 1726 1727CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp866 */; 1728 1729USE `mysqltest1`; 1730/*!40101 SET @saved_cs_client = @@character_set_client */; 1731/*!40101 SET character_set_client = utf8 */; 1732CREATE TABLE `log` ( 1733 `msg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL 1734) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 1735/*!40101 SET character_set_client = @saved_cs_client */; 1736/*!40101 SET @saved_cs_client = @@character_set_client */; 1737/*!40101 SET character_set_client = utf8 */; 1738CREATE TABLE `t1` ( 1739 `c` int(11) DEFAULT NULL 1740) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 1741/*!40101 SET character_set_client = @saved_cs_client */; 1742INSERT INTO `t1` VALUES (1),(0),(1); 1743ALTER DATABASE `mysqltest1` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 1744/*!50003 SET @saved_cs_client = @@character_set_client */ ; 1745/*!50003 SET @saved_cs_results = @@character_set_results */ ; 1746/*!50003 SET @saved_col_connection = @@collation_connection */ ; 1747/*!50003 SET character_set_client = koi8r */ ; 1748/*!50003 SET character_set_results = koi8r */ ; 1749/*!50003 SET collation_connection = koi8r_general_ci */ ; 1750/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 1751/*!50003 SET sql_mode = '' */ ; 1752DELIMITER ;; 1753/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW 1754BEGIN 1755DECLARE �����1 CHAR(10); 1756INSERT INTO log VALUES(COLLATION(�����1)); 1757INSERT INTO log VALUES(COLLATION('�����')); 1758INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1759INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1760INSERT INTO log VALUES(@@collation_connection); 1761INSERT INTO log VALUES(@@character_set_client); 1762SET @a1 = '�����'; 1763SET @a1 = _koi8r '�����'; 1764SET @a2 = _utf8 'текст'; 1765END */;; 1766DELIMITER ; 1767/*!50003 SET sql_mode = @saved_sql_mode */ ; 1768/*!50003 SET character_set_client = @saved_cs_client */ ; 1769/*!50003 SET character_set_results = @saved_cs_results */ ; 1770/*!50003 SET collation_connection = @saved_col_connection */ ; 1771ALTER DATABASE `mysqltest1` CHARACTER SET cp866 COLLATE cp866_general_ci ; 1772ALTER DATABASE `mysqltest1` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 1773/*!50003 SET @saved_cs_client = @@character_set_client */ ; 1774/*!50003 SET @saved_cs_results = @@character_set_results */ ; 1775/*!50003 SET @saved_col_connection = @@collation_connection */ ; 1776/*!50003 SET character_set_client = koi8r */ ; 1777/*!50003 SET character_set_results = koi8r */ ; 1778/*!50003 SET collation_connection = koi8r_general_ci */ ; 1779/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 1780/*!50003 SET sql_mode = '' */ ; 1781DELIMITER ;; 1782/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW 1783BEGIN 1784DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1785INSERT INTO log VALUES(COLLATION(�����1)); 1786INSERT INTO log VALUES(COLLATION('�����')); 1787INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1788INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1789INSERT INTO log VALUES(@@collation_connection); 1790INSERT INTO log VALUES(@@character_set_client); 1791SET @b1 = '�����'; 1792SET @b1 = _koi8r '�����'; 1793SET @b2 = _utf8 'текст'; 1794END */;; 1795DELIMITER ; 1796/*!50003 SET sql_mode = @saved_sql_mode */ ; 1797/*!50003 SET character_set_client = @saved_cs_client */ ; 1798/*!50003 SET character_set_results = @saved_cs_results */ ; 1799/*!50003 SET collation_connection = @saved_col_connection */ ; 1800ALTER DATABASE `mysqltest1` CHARACTER SET cp866 COLLATE cp866_general_ci ; 1801 1802---> Dumping mysqltest1 to ddl_i18n_koi8r.triggers.mysqltest1.sql 1803 1804---> Dump of mysqltest2 1805 1806CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest2` /*!40100 DEFAULT CHARACTER SET cp866 */; 1807 1808USE `mysqltest2`; 1809/*!40101 SET @saved_cs_client = @@character_set_client */; 1810/*!40101 SET character_set_client = utf8 */; 1811CREATE TABLE `log` ( 1812 `msg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL 1813) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 1814/*!40101 SET character_set_client = @saved_cs_client */; 1815/*!40101 SET @saved_cs_client = @@character_set_client */; 1816/*!40101 SET character_set_client = utf8 */; 1817CREATE TABLE `t1` ( 1818 `c` int(11) DEFAULT NULL 1819) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 1820/*!40101 SET character_set_client = @saved_cs_client */; 1821INSERT INTO `t1` VALUES (1),(0),(1); 1822ALTER DATABASE `mysqltest2` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 1823/*!50003 SET @saved_cs_client = @@character_set_client */ ; 1824/*!50003 SET @saved_cs_results = @@character_set_results */ ; 1825/*!50003 SET @saved_col_connection = @@collation_connection */ ; 1826/*!50003 SET character_set_client = koi8r */ ; 1827/*!50003 SET character_set_results = koi8r */ ; 1828/*!50003 SET collation_connection = koi8r_general_ci */ ; 1829/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 1830/*!50003 SET sql_mode = '' */ ; 1831DELIMITER ;; 1832/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW 1833BEGIN 1834DECLARE �����1 CHAR(10); 1835INSERT INTO log VALUES(COLLATION(�����1)); 1836INSERT INTO log VALUES(COLLATION('�����')); 1837INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1838INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1839INSERT INTO log VALUES(@@collation_connection); 1840INSERT INTO log VALUES(@@character_set_client); 1841SET @a1 = '�����'; 1842SET @a1 = _koi8r '�����'; 1843SET @a2 = _utf8 'текст'; 1844END */;; 1845DELIMITER ; 1846/*!50003 SET sql_mode = @saved_sql_mode */ ; 1847/*!50003 SET character_set_client = @saved_cs_client */ ; 1848/*!50003 SET character_set_results = @saved_cs_results */ ; 1849/*!50003 SET collation_connection = @saved_col_connection */ ; 1850ALTER DATABASE `mysqltest2` CHARACTER SET cp866 COLLATE cp866_general_ci ; 1851ALTER DATABASE `mysqltest2` CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 1852/*!50003 SET @saved_cs_client = @@character_set_client */ ; 1853/*!50003 SET @saved_cs_results = @@character_set_results */ ; 1854/*!50003 SET @saved_col_connection = @@collation_connection */ ; 1855/*!50003 SET character_set_client = koi8r */ ; 1856/*!50003 SET character_set_results = koi8r */ ; 1857/*!50003 SET collation_connection = koi8r_general_ci */ ; 1858/*!50003 SET @saved_sql_mode = @@sql_mode */ ; 1859/*!50003 SET sql_mode = '' */ ; 1860DELIMITER ;; 1861/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW 1862BEGIN 1863DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1864INSERT INTO log VALUES(COLLATION(�����1)); 1865INSERT INTO log VALUES(COLLATION('�����')); 1866INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1867INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1868INSERT INTO log VALUES(@@collation_connection); 1869INSERT INTO log VALUES(@@character_set_client); 1870SET @b1 = '�����'; 1871SET @b1 = _koi8r '�����'; 1872SET @b2 = _utf8 'текст'; 1873END */;; 1874DELIMITER ; 1875/*!50003 SET sql_mode = @saved_sql_mode */ ; 1876/*!50003 SET character_set_client = @saved_cs_client */ ; 1877/*!50003 SET character_set_results = @saved_cs_results */ ; 1878/*!50003 SET collation_connection = @saved_col_connection */ ; 1879ALTER DATABASE `mysqltest2` CHARACTER SET cp866 COLLATE cp866_general_ci ; 1880 1881---> Dumping mysqltest2 to ddl_i18n_koi8r.triggers.mysqltest2.sql 1882 1883 1884DROP DATABASE mysqltest1| 1885DROP DATABASE mysqltest2| 1886 1887 1888---> Restoring mysqltest1... 1889---> Restoring mysqltest2... 1890ALTER TABLE mysqltest1.t1 ADD COLUMN fake INT| 1891ALTER TABLE mysqltest1.t1 DROP COLUMN fake| 1892ALTER TABLE mysqltest2.t1 ADD COLUMN fake INT| 1893ALTER TABLE mysqltest2.t1 DROP COLUMN fake| 1894connect con3,localhost,root,,; 1895SET @@character_set_client= cp1251| 1896SET @@character_set_results= cp1251| 1897SET @@collation_connection= cp1251_general_ci| 1898INSERT INTO mysqltest1.t1 VALUES(0)| 1899INSERT INTO mysqltest2.t1 VALUES(0)| 1900DELETE FROM mysqltest1.log| 1901DELETE FROM mysqltest2.log| 1902set names koi8r| 1903use mysqltest1| 1904 1905 1906SHOW CREATE TRIGGER trg1| 1907Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1908trg1 CREATE DEFINER=`root`@`localhost` TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW 1909BEGIN 1910DECLARE �����1 CHAR(10); 1911INSERT INTO log VALUES(COLLATION(�����1)); 1912INSERT INTO log VALUES(COLLATION('�����')); 1913INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1914INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1915INSERT INTO log VALUES(@@collation_connection); 1916INSERT INTO log VALUES(@@character_set_client); 1917SET @a1 = '�����'; 1918SET @a1 = _koi8r '�����'; 1919SET @a2 = _utf8 'текст'; 1920END koi8r koi8r_general_ci utf8_unicode_ci # 1921 1922SHOW CREATE TRIGGER trg2| 1923Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1924trg2 CREATE DEFINER=`root`@`localhost` TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW 1925BEGIN 1926DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1927INSERT INTO log VALUES(COLLATION(�����1)); 1928INSERT INTO log VALUES(COLLATION('�����')); 1929INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1930INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1931INSERT INTO log VALUES(@@collation_connection); 1932INSERT INTO log VALUES(@@character_set_client); 1933SET @b1 = '�����'; 1934SET @b1 = _koi8r '�����'; 1935SET @b2 = _utf8 'текст'; 1936END koi8r koi8r_general_ci utf8_unicode_ci # 1937 1938SHOW CREATE TRIGGER mysqltest2.trg3| 1939Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1940trg3 CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW 1941BEGIN 1942DECLARE �����1 CHAR(10); 1943INSERT INTO log VALUES(COLLATION(�����1)); 1944INSERT INTO log VALUES(COLLATION('�����')); 1945INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1946INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1947INSERT INTO log VALUES(@@collation_connection); 1948INSERT INTO log VALUES(@@character_set_client); 1949SET @a1 = '�����'; 1950SET @a1 = _koi8r '�����'; 1951SET @a2 = _utf8 'текст'; 1952END koi8r koi8r_general_ci utf8_unicode_ci # 1953 1954SHOW CREATE TRIGGER mysqltest2.trg4| 1955Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created 1956trg4 CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW 1957BEGIN 1958DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1959INSERT INTO log VALUES(COLLATION(�����1)); 1960INSERT INTO log VALUES(COLLATION('�����')); 1961INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1962INSERT INTO log VALUES(COLLATION(_utf8 'текст')); 1963INSERT INTO log VALUES(@@collation_connection); 1964INSERT INTO log VALUES(@@character_set_client); 1965SET @b1 = '�����'; 1966SET @b1 = _koi8r '�����'; 1967SET @b2 = _utf8 'текст'; 1968END koi8r koi8r_general_ci utf8_unicode_ci # 1969 1970 1971SHOW TRIGGERS| 1972Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 1973trg1 INSERT t1 BEGIN 1974DECLARE �����1 CHAR(10); 1975INSERT INTO log VALUES(COLLATION(�����1)); 1976INSERT INTO log VALUES(COLLATION('�����')); 1977INSERT INTO log VALUES(COLLATION( '�����')); 1978INSERT INTO log VALUES(COLLATION( '�����')); 1979INSERT INTO log VALUES(@@collation_connection); 1980INSERT INTO log VALUES(@@character_set_client); 1981SET @a1 = '�����'; 1982SET @a1 = '�����'; 1983SET @a2 = '�����'; 1984END BEFORE # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1985trg2 INSERT t1 BEGIN 1986DECLARE �����1 CHAR(10) CHARACTER SET utf8; 1987INSERT INTO log VALUES(COLLATION(�����1)); 1988INSERT INTO log VALUES(COLLATION('�����')); 1989INSERT INTO log VALUES(COLLATION( '�����')); 1990INSERT INTO log VALUES(COLLATION( '�����')); 1991INSERT INTO log VALUES(@@collation_connection); 1992INSERT INTO log VALUES(@@character_set_client); 1993SET @b1 = '�����'; 1994SET @b1 = '�����'; 1995SET @b2 = '�����'; 1996END AFTER # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 1997 1998use mysqltest2| 1999 2000SHOW TRIGGERS| 2001Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 2002trg3 INSERT t1 BEGIN 2003DECLARE �����1 CHAR(10); 2004INSERT INTO log VALUES(COLLATION(�����1)); 2005INSERT INTO log VALUES(COLLATION('�����')); 2006INSERT INTO log VALUES(COLLATION( '�����')); 2007INSERT INTO log VALUES(COLLATION( '�����')); 2008INSERT INTO log VALUES(@@collation_connection); 2009INSERT INTO log VALUES(@@character_set_client); 2010SET @a1 = '�����'; 2011SET @a1 = '�����'; 2012SET @a2 = '�����'; 2013END BEFORE # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 2014trg4 INSERT t1 BEGIN 2015DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2016INSERT INTO log VALUES(COLLATION(�����1)); 2017INSERT INTO log VALUES(COLLATION('�����')); 2018INSERT INTO log VALUES(COLLATION( '�����')); 2019INSERT INTO log VALUES(COLLATION( '�����')); 2020INSERT INTO log VALUES(@@collation_connection); 2021INSERT INTO log VALUES(@@character_set_client); 2022SET @b1 = '�����'; 2023SET @b1 = '�����'; 2024SET @b2 = '�����'; 2025END AFTER # root@localhost koi8r koi8r_general_ci utf8_unicode_ci 2026use mysqltest1| 2027 2028 2029SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'| 2030TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2031def mysqltest1 trg1 INSERT def mysqltest1 t1 1 NULL BEGIN 2032DECLARE �����1 CHAR(10); 2033INSERT INTO log VALUES(COLLATION(�����1)); 2034INSERT INTO log VALUES(COLLATION('�����')); 2035INSERT INTO log VALUES(COLLATION( '�����')); 2036INSERT INTO log VALUES(COLLATION( '�����')); 2037INSERT INTO log VALUES(@@collation_connection); 2038INSERT INTO log VALUES(@@character_set_client); 2039SET @a1 = '�����'; 2040SET @a1 = '�����'; 2041SET @a2 = '�����'; 2042END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 2043 2044SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'| 2045TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2046def mysqltest1 trg2 INSERT def mysqltest1 t1 1 NULL BEGIN 2047DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2048INSERT INTO log VALUES(COLLATION(�����1)); 2049INSERT INTO log VALUES(COLLATION('�����')); 2050INSERT INTO log VALUES(COLLATION( '�����')); 2051INSERT INTO log VALUES(COLLATION( '�����')); 2052INSERT INTO log VALUES(@@collation_connection); 2053INSERT INTO log VALUES(@@character_set_client); 2054SET @b1 = '�����'; 2055SET @b1 = '�����'; 2056SET @b2 = '�����'; 2057END ROW AFTER NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 2058 2059SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'| 2060TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2061def mysqltest2 trg3 INSERT def mysqltest2 t1 1 NULL BEGIN 2062DECLARE �����1 CHAR(10); 2063INSERT INTO log VALUES(COLLATION(�����1)); 2064INSERT INTO log VALUES(COLLATION('�����')); 2065INSERT INTO log VALUES(COLLATION( '�����')); 2066INSERT INTO log VALUES(COLLATION( '�����')); 2067INSERT INTO log VALUES(@@collation_connection); 2068INSERT INTO log VALUES(@@character_set_client); 2069SET @a1 = '�����'; 2070SET @a1 = '�����'; 2071SET @a2 = '�����'; 2072END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 2073 2074SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'| 2075TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2076def mysqltest2 trg4 INSERT def mysqltest2 t1 1 NULL BEGIN 2077DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2078INSERT INTO log VALUES(COLLATION(�����1)); 2079INSERT INTO log VALUES(COLLATION('�����')); 2080INSERT INTO log VALUES(COLLATION( '�����')); 2081INSERT INTO log VALUES(COLLATION( '�����')); 2082INSERT INTO log VALUES(@@collation_connection); 2083INSERT INTO log VALUES(@@character_set_client); 2084SET @b1 = '�����'; 2085SET @b1 = '�����'; 2086SET @b2 = '�����'; 2087END ROW AFTER NULL NULL OLD NEW CREATED root@localhost koi8r koi8r_general_ci utf8_unicode_ci 2088 2089 2090SET @a1 = '1'| 2091SET @a2 = '1'| 2092SET @a3 = '1'| 2093SET @b1 = '2'| 2094SET @b2 = '2'| 2095SET @b3 = '2'| 2096 2097 2098INSERT INTO t1 VALUES(1)| 2099 2100---> Log: 2101SELECT msg FROM log| 2102msg 2103koi8r 2104koi8r 2105koi8r_general_ci 2106koi8r_general_ci 2107koi8r_general_ci 2108koi8r_general_ci 2109koi8r_general_ci 2110koi8r_general_ci 2111utf8_general_ci 2112utf8_general_ci 2113utf8_general_ci 2114utf8_unicode_ci 2115 2116SELECT 2117COLLATION(@a1) AS ca1, 2118COLLATION(@a2) AS ca2, 2119COLLATION(@a3) AS ca3, 2120COLLATION(@b1) AS cb1, 2121COLLATION(@b2) AS cb2, 2122COLLATION(@b3) AS cb3| 2123ca1 ca2 ca3 cb1 cb2 cb3 2124koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci 2125 2126DELETE FROM log| 2127 2128 2129INSERT INTO mysqltest2.t1 VALUES(1)| 2130 2131---> Log: 2132SELECT msg FROM mysqltest2.log| 2133msg 2134koi8r 2135koi8r 2136koi8r_general_ci 2137koi8r_general_ci 2138koi8r_general_ci 2139koi8r_general_ci 2140koi8r_general_ci 2141koi8r_general_ci 2142utf8_general_ci 2143utf8_general_ci 2144utf8_general_ci 2145utf8_unicode_ci 2146 2147SELECT 2148COLLATION(@a1) AS ca1, 2149COLLATION(@a2) AS ca2, 2150COLLATION(@a3) AS ca3, 2151COLLATION(@b1) AS cb1, 2152COLLATION(@b2) AS cb2, 2153COLLATION(@b3) AS cb3| 2154ca1 ca2 ca3 cb1 cb2 cb3 2155koi8r_general_ci utf8_general_ci koi8r_general_ci koi8r_general_ci utf8_general_ci koi8r_general_ci 2156 2157DELETE FROM mysqltest2.log| 2158connection default; 2159disconnect con2; 2160disconnect con3; 2161use test| 2162DROP DATABASE mysqltest1| 2163DROP DATABASE mysqltest2| 2164 2165------------------------------------------------------------------- 2166Events 2167------------------------------------------------------------------- 2168 2169DROP DATABASE IF EXISTS mysqltest1| 2170DROP DATABASE IF EXISTS mysqltest2| 2171CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 2172CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 2173use mysqltest1| 2174 2175CREATE EVENT ev1 ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO 2176BEGIN 2177DECLARE �����1 CHAR(10); 2178SELECT 2179COLLATION(�����1) AS c1, 2180COLLATION('�����') AS c2, 2181COLLATION(_koi8r '�����') AS c3, 2182COLLATION(_utf8 'текст') AS c4, 2183@@collation_connection AS c5, 2184@@character_set_client AS c6; 2185END| 2186Warnings: 2187Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. 2188 2189CREATE EVENT ev2 ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO 2190BEGIN 2191DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2192SELECT 2193COLLATION(�����1) AS c1, 2194COLLATION('�����') AS c2, 2195COLLATION(_koi8r '�����') AS c3, 2196COLLATION(_utf8 'текст') AS c4, 2197@@collation_connection AS c5, 2198@@character_set_client AS c6; 2199END| 2200Warnings: 2201Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. 2202 2203CREATE EVENT mysqltest2.ev3 ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO 2204BEGIN 2205DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2206SELECT 2207COLLATION(�����1) AS c1, 2208COLLATION('�����') AS c2, 2209COLLATION(_koi8r '�����') AS c3, 2210COLLATION(_utf8 'текст') AS c4, 2211@@collation_connection AS c5, 2212@@character_set_client AS c6; 2213END| 2214Warnings: 2215Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. 2216 2217CREATE EVENT mysqltest2.ev4 ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO 2218BEGIN 2219DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2220SELECT 2221COLLATION(�����1) AS c1, 2222COLLATION('�����') AS c2, 2223COLLATION(_koi8r '�����') AS c3, 2224COLLATION(_utf8 'текст') AS c4, 2225@@collation_connection AS c5, 2226@@character_set_client AS c6; 2227END| 2228Warnings: 2229Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. 2230 2231 2232 2233SHOW CREATE EVENT ev1| 2234Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2235ev1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev1` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2236DECLARE �����1 CHAR(10); 2237SELECT 2238COLLATION(�����1) AS c1, 2239COLLATION('�����') AS c2, 2240COLLATION(_koi8r '�����') AS c3, 2241COLLATION(_utf8 'текст') AS c4, 2242@@collation_connection AS c5, 2243@@character_set_client AS c6; 2244END koi8r koi8r_general_ci utf8_unicode_ci 2245 2246SHOW CREATE EVENT ev2| 2247Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2248ev2 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev2` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2249DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2250SELECT 2251COLLATION(�����1) AS c1, 2252COLLATION('�����') AS c2, 2253COLLATION(_koi8r '�����') AS c3, 2254COLLATION(_utf8 'текст') AS c4, 2255@@collation_connection AS c5, 2256@@character_set_client AS c6; 2257END koi8r koi8r_general_ci utf8_unicode_ci 2258 2259SHOW CREATE EVENT mysqltest2.ev3| 2260Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2261ev3 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2262DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2263SELECT 2264COLLATION(�����1) AS c1, 2265COLLATION('�����') AS c2, 2266COLLATION(_koi8r '�����') AS c3, 2267COLLATION(_utf8 'текст') AS c4, 2268@@collation_connection AS c5, 2269@@character_set_client AS c6; 2270END koi8r koi8r_general_ci utf8_unicode_ci 2271 2272SHOW CREATE EVENT mysqltest2.ev3| 2273Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2274ev3 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2275DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2276SELECT 2277COLLATION(�����1) AS c1, 2278COLLATION('�����') AS c2, 2279COLLATION(_koi8r '�����') AS c3, 2280COLLATION(_utf8 'текст') AS c4, 2281@@collation_connection AS c5, 2282@@character_set_client AS c6; 2283END koi8r koi8r_general_ci utf8_unicode_ci 2284 2285 2286SHOW EVENTS LIKE 'ev1'| 2287Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2288mysqltest1 ev1 root@localhost SYSTEM ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED 1 koi8r koi8r_general_ci utf8_unicode_ci 2289 2290SHOW EVENTS LIKE 'ev2'| 2291Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2292mysqltest1 ev2 root@localhost SYSTEM ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED 1 koi8r koi8r_general_ci utf8_unicode_ci 2293 2294SHOW EVENTS LIKE 'ev3'| 2295Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2296 2297SHOW EVENTS LIKE 'ev4'| 2298Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2299 2300 2301SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'| 2302EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2303def mysqltest1 ev1 root@localhost SYSTEM SQL BEGIN 2304DECLARE �����1 CHAR(10); 2305SELECT 2306COLLATION(�����1) AS c1, 2307COLLATION('�����') AS c2, 2308COLLATION( '�����') AS c3, 2309COLLATION( '�����') AS c4, 2310@@collation_connection AS c5, 2311@@character_set_client AS c6; 2312END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2313 2314SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'| 2315EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2316def mysqltest1 ev2 root@localhost SYSTEM SQL BEGIN 2317DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2318SELECT 2319COLLATION(�����1) AS c1, 2320COLLATION('�����') AS c2, 2321COLLATION( '�����') AS c3, 2322COLLATION( '�����') AS c4, 2323@@collation_connection AS c5, 2324@@character_set_client AS c6; 2325END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2326 2327SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'| 2328EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2329def mysqltest2 ev3 root@localhost SYSTEM SQL BEGIN 2330DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2331SELECT 2332COLLATION(�����1) AS c1, 2333COLLATION('�����') AS c2, 2334COLLATION( '�����') AS c3, 2335COLLATION( '�����') AS c4, 2336@@collation_connection AS c5, 2337@@character_set_client AS c6; 2338END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2339 2340SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'| 2341EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2342def mysqltest2 ev4 root@localhost SYSTEM SQL BEGIN 2343DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2344SELECT 2345COLLATION(�����1) AS c1, 2346COLLATION('�����') AS c2, 2347COLLATION( '�����') AS c3, 2348COLLATION( '�����') AS c4, 2349@@collation_connection AS c5, 2350@@character_set_client AS c6; 2351END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2352 2353 2354ALTER DATABASE mysqltest1 COLLATE cp866_general_ci| 2355ALTER DATABASE mysqltest2 COLLATE cp866_general_ci| 2356connect con2,localhost,root,,mysqltest1; 2357SET @@character_set_client= cp1251| 2358SET @@character_set_results= cp1251| 2359SET @@collation_connection= cp1251_general_ci| 2360SHOW CREATE EVENT ev1| 2361SHOW CREATE EVENT ev2| 2362SHOW CREATE EVENT mysqltest2.ev3| 2363SHOW CREATE EVENT mysqltest2.ev4| 2364set names koi8r| 2365 2366 2367SHOW CREATE EVENT ev1| 2368Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2369ev1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev1` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2370DECLARE �����1 CHAR(10); 2371SELECT 2372COLLATION(�����1) AS c1, 2373COLLATION('�����') AS c2, 2374COLLATION(_koi8r '�����') AS c3, 2375COLLATION(_utf8 'текст') AS c4, 2376@@collation_connection AS c5, 2377@@character_set_client AS c6; 2378END koi8r koi8r_general_ci utf8_unicode_ci 2379 2380SHOW CREATE EVENT ev2| 2381Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2382ev2 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev2` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2383DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2384SELECT 2385COLLATION(�����1) AS c1, 2386COLLATION('�����') AS c2, 2387COLLATION(_koi8r '�����') AS c3, 2388COLLATION(_utf8 'текст') AS c4, 2389@@collation_connection AS c5, 2390@@character_set_client AS c6; 2391END koi8r koi8r_general_ci utf8_unicode_ci 2392 2393SHOW CREATE EVENT mysqltest2.ev3| 2394Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2395ev3 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2396DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2397SELECT 2398COLLATION(�����1) AS c1, 2399COLLATION('�����') AS c2, 2400COLLATION(_koi8r '�����') AS c3, 2401COLLATION(_utf8 'текст') AS c4, 2402@@collation_connection AS c5, 2403@@character_set_client AS c6; 2404END koi8r koi8r_general_ci utf8_unicode_ci 2405 2406SHOW CREATE EVENT mysqltest2.ev3| 2407Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2408ev3 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2409DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2410SELECT 2411COLLATION(�����1) AS c1, 2412COLLATION('�����') AS c2, 2413COLLATION(_koi8r '�����') AS c3, 2414COLLATION(_utf8 'текст') AS c4, 2415@@collation_connection AS c5, 2416@@character_set_client AS c6; 2417END koi8r koi8r_general_ci utf8_unicode_ci 2418 2419 2420SHOW EVENTS LIKE 'ev1'| 2421Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2422mysqltest1 ev1 root@localhost SYSTEM ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED 1 koi8r koi8r_general_ci utf8_unicode_ci 2423 2424SHOW EVENTS LIKE 'ev2'| 2425Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2426mysqltest1 ev2 root@localhost SYSTEM ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED 1 koi8r koi8r_general_ci utf8_unicode_ci 2427 2428SHOW EVENTS LIKE 'ev3'| 2429Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2430 2431SHOW EVENTS LIKE 'ev4'| 2432Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2433 2434 2435SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'| 2436EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2437def mysqltest1 ev1 root@localhost SYSTEM SQL BEGIN 2438DECLARE �����1 CHAR(10); 2439SELECT 2440COLLATION(�����1) AS c1, 2441COLLATION('�����') AS c2, 2442COLLATION( '�����') AS c3, 2443COLLATION( '�����') AS c4, 2444@@collation_connection AS c5, 2445@@character_set_client AS c6; 2446END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2447 2448SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'| 2449EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2450def mysqltest1 ev2 root@localhost SYSTEM SQL BEGIN 2451DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2452SELECT 2453COLLATION(�����1) AS c1, 2454COLLATION('�����') AS c2, 2455COLLATION( '�����') AS c3, 2456COLLATION( '�����') AS c4, 2457@@collation_connection AS c5, 2458@@character_set_client AS c6; 2459END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2460 2461SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'| 2462EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2463def mysqltest2 ev3 root@localhost SYSTEM SQL BEGIN 2464DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2465SELECT 2466COLLATION(�����1) AS c1, 2467COLLATION('�����') AS c2, 2468COLLATION( '�����') AS c3, 2469COLLATION( '�����') AS c4, 2470@@collation_connection AS c5, 2471@@character_set_client AS c6; 2472END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2473 2474SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'| 2475EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2476def mysqltest2 ev4 root@localhost SYSTEM SQL BEGIN 2477DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2478SELECT 2479COLLATION(�����1) AS c1, 2480COLLATION('�����') AS c2, 2481COLLATION( '�����') AS c3, 2482COLLATION( '�����') AS c4, 2483@@collation_connection AS c5, 2484@@character_set_client AS c6; 2485END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2486 2487---> Dump of mysqltest1 2488 2489CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp866 */; 2490 2491USE `mysqltest1`; 2492/*!50106 SET @save_time_zone= @@TIME_ZONE */ ; 2493DELIMITER ;; 2494ALTER DATABASE `mysqltest1` CHARACTER SET utf8 COLLATE utf8_unicode_ci ;; 2495/*!50003 SET @saved_cs_client = @@character_set_client */ ;; 2496/*!50003 SET @saved_cs_results = @@character_set_results */ ;; 2497/*!50003 SET @saved_col_connection = @@collation_connection */ ;; 2498/*!50003 SET character_set_client = koi8r */ ;; 2499/*!50003 SET character_set_results = koi8r */ ;; 2500/*!50003 SET collation_connection = koi8r_general_ci */ ;; 2501/*!50003 SET @saved_sql_mode = @@sql_mode */ ;; 2502/*!50003 SET sql_mode = '' */ ;; 2503/*!50003 SET @saved_time_zone = @@time_zone */ ;; 2504/*!50003 SET time_zone = 'SYSTEM' */ ;; 2505/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `ev1` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2506DECLARE �����1 CHAR(10); 2507SELECT 2508COLLATION(�����1) AS c1, 2509COLLATION('�����') AS c2, 2510COLLATION(_koi8r '�����') AS c3, 2511COLLATION(_utf8 'текст') AS c4, 2512@@collation_connection AS c5, 2513@@character_set_client AS c6; 2514END */ ;; 2515/*!50003 SET time_zone = @saved_time_zone */ ;; 2516/*!50003 SET sql_mode = @saved_sql_mode */ ;; 2517/*!50003 SET character_set_client = @saved_cs_client */ ;; 2518/*!50003 SET character_set_results = @saved_cs_results */ ;; 2519/*!50003 SET collation_connection = @saved_col_connection */ ;; 2520ALTER DATABASE `mysqltest1` CHARACTER SET cp866 COLLATE cp866_general_ci ;; 2521DELIMITER ;; 2522ALTER DATABASE `mysqltest1` CHARACTER SET utf8 COLLATE utf8_unicode_ci ;; 2523/*!50003 SET @saved_cs_client = @@character_set_client */ ;; 2524/*!50003 SET @saved_cs_results = @@character_set_results */ ;; 2525/*!50003 SET @saved_col_connection = @@collation_connection */ ;; 2526/*!50003 SET character_set_client = koi8r */ ;; 2527/*!50003 SET character_set_results = koi8r */ ;; 2528/*!50003 SET collation_connection = koi8r_general_ci */ ;; 2529/*!50003 SET @saved_sql_mode = @@sql_mode */ ;; 2530/*!50003 SET sql_mode = '' */ ;; 2531/*!50003 SET @saved_time_zone = @@time_zone */ ;; 2532/*!50003 SET time_zone = 'SYSTEM' */ ;; 2533/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `ev2` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2534DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2535SELECT 2536COLLATION(�����1) AS c1, 2537COLLATION('�����') AS c2, 2538COLLATION(_koi8r '�����') AS c3, 2539COLLATION(_utf8 'текст') AS c4, 2540@@collation_connection AS c5, 2541@@character_set_client AS c6; 2542END */ ;; 2543/*!50003 SET time_zone = @saved_time_zone */ ;; 2544/*!50003 SET sql_mode = @saved_sql_mode */ ;; 2545/*!50003 SET character_set_client = @saved_cs_client */ ;; 2546/*!50003 SET character_set_results = @saved_cs_results */ ;; 2547/*!50003 SET collation_connection = @saved_col_connection */ ;; 2548ALTER DATABASE `mysqltest1` CHARACTER SET cp866 COLLATE cp866_general_ci ;; 2549DELIMITER ; 2550/*!50106 SET TIME_ZONE= @save_time_zone */ ; 2551 2552---> Dumping mysqltest1 to ddl_i18n_koi8r.events.mysqltest1.sql 2553 2554---> Dump of mysqltest2 2555 2556CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest2` /*!40100 DEFAULT CHARACTER SET cp866 */; 2557 2558USE `mysqltest2`; 2559/*!50106 SET @save_time_zone= @@TIME_ZONE */ ; 2560DELIMITER ;; 2561ALTER DATABASE `mysqltest2` CHARACTER SET utf8 COLLATE utf8_unicode_ci ;; 2562/*!50003 SET @saved_cs_client = @@character_set_client */ ;; 2563/*!50003 SET @saved_cs_results = @@character_set_results */ ;; 2564/*!50003 SET @saved_col_connection = @@collation_connection */ ;; 2565/*!50003 SET character_set_client = koi8r */ ;; 2566/*!50003 SET character_set_results = koi8r */ ;; 2567/*!50003 SET collation_connection = koi8r_general_ci */ ;; 2568/*!50003 SET @saved_sql_mode = @@sql_mode */ ;; 2569/*!50003 SET sql_mode = '' */ ;; 2570/*!50003 SET @saved_time_zone = @@time_zone */ ;; 2571/*!50003 SET time_zone = 'SYSTEM' */ ;; 2572/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2573DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2574SELECT 2575COLLATION(�����1) AS c1, 2576COLLATION('�����') AS c2, 2577COLLATION(_koi8r '�����') AS c3, 2578COLLATION(_utf8 'текст') AS c4, 2579@@collation_connection AS c5, 2580@@character_set_client AS c6; 2581END */ ;; 2582/*!50003 SET time_zone = @saved_time_zone */ ;; 2583/*!50003 SET sql_mode = @saved_sql_mode */ ;; 2584/*!50003 SET character_set_client = @saved_cs_client */ ;; 2585/*!50003 SET character_set_results = @saved_cs_results */ ;; 2586/*!50003 SET collation_connection = @saved_col_connection */ ;; 2587ALTER DATABASE `mysqltest2` CHARACTER SET cp866 COLLATE cp866_general_ci ;; 2588DELIMITER ;; 2589ALTER DATABASE `mysqltest2` CHARACTER SET utf8 COLLATE utf8_unicode_ci ;; 2590/*!50003 SET @saved_cs_client = @@character_set_client */ ;; 2591/*!50003 SET @saved_cs_results = @@character_set_results */ ;; 2592/*!50003 SET @saved_col_connection = @@collation_connection */ ;; 2593/*!50003 SET character_set_client = koi8r */ ;; 2594/*!50003 SET character_set_results = koi8r */ ;; 2595/*!50003 SET collation_connection = koi8r_general_ci */ ;; 2596/*!50003 SET @saved_sql_mode = @@sql_mode */ ;; 2597/*!50003 SET sql_mode = '' */ ;; 2598/*!50003 SET @saved_time_zone = @@time_zone */ ;; 2599/*!50003 SET time_zone = 'SYSTEM' */ ;; 2600/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `ev4` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2601DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2602SELECT 2603COLLATION(�����1) AS c1, 2604COLLATION('�����') AS c2, 2605COLLATION(_koi8r '�����') AS c3, 2606COLLATION(_utf8 'текст') AS c4, 2607@@collation_connection AS c5, 2608@@character_set_client AS c6; 2609END */ ;; 2610/*!50003 SET time_zone = @saved_time_zone */ ;; 2611/*!50003 SET sql_mode = @saved_sql_mode */ ;; 2612/*!50003 SET character_set_client = @saved_cs_client */ ;; 2613/*!50003 SET character_set_results = @saved_cs_results */ ;; 2614/*!50003 SET collation_connection = @saved_col_connection */ ;; 2615ALTER DATABASE `mysqltest2` CHARACTER SET cp866 COLLATE cp866_general_ci ;; 2616DELIMITER ; 2617/*!50106 SET TIME_ZONE= @save_time_zone */ ; 2618 2619---> Dumping mysqltest2 to ddl_i18n_koi8r.events.mysqltest2.sql 2620 2621 2622DROP DATABASE mysqltest1| 2623DROP DATABASE mysqltest2| 2624 2625 2626---> Restoring mysqltest1... 2627---> Restoring mysqltest2... 2628connect con3,localhost,root,,mysqltest1; 2629SET @@character_set_client= cp1251| 2630SET @@character_set_results= cp1251| 2631SET @@collation_connection= cp1251_general_ci| 2632SHOW CREATE EVENT ev1| 2633SHOW CREATE EVENT ev2| 2634SHOW CREATE EVENT mysqltest2.ev3| 2635SHOW CREATE EVENT mysqltest2.ev4| 2636set names koi8r| 2637 2638 2639SHOW CREATE EVENT ev1| 2640Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2641ev1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev1` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2642DECLARE �����1 CHAR(10); 2643SELECT 2644COLLATION(�����1) AS c1, 2645COLLATION('�����') AS c2, 2646COLLATION(_koi8r '�����') AS c3, 2647COLLATION(_utf8 'текст') AS c4, 2648@@collation_connection AS c5, 2649@@character_set_client AS c6; 2650END koi8r koi8r_general_ci utf8_unicode_ci 2651 2652SHOW CREATE EVENT ev2| 2653Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2654ev2 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev2` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2655DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2656SELECT 2657COLLATION(�����1) AS c1, 2658COLLATION('�����') AS c2, 2659COLLATION(_koi8r '�����') AS c3, 2660COLLATION(_utf8 'текст') AS c4, 2661@@collation_connection AS c5, 2662@@character_set_client AS c6; 2663END koi8r koi8r_general_ci utf8_unicode_ci 2664 2665SHOW CREATE EVENT mysqltest2.ev3| 2666Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2667ev3 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2668DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2669SELECT 2670COLLATION(�����1) AS c1, 2671COLLATION('�����') AS c2, 2672COLLATION(_koi8r '�����') AS c3, 2673COLLATION(_utf8 'текст') AS c4, 2674@@collation_connection AS c5, 2675@@character_set_client AS c6; 2676END koi8r koi8r_general_ci utf8_unicode_ci 2677 2678SHOW CREATE EVENT mysqltest2.ev3| 2679Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation 2680ev3 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev3` ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE DO BEGIN 2681DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2682SELECT 2683COLLATION(�����1) AS c1, 2684COLLATION('�����') AS c2, 2685COLLATION(_koi8r '�����') AS c3, 2686COLLATION(_utf8 'текст') AS c4, 2687@@collation_connection AS c5, 2688@@character_set_client AS c6; 2689END koi8r koi8r_general_ci utf8_unicode_ci 2690 2691 2692SHOW EVENTS LIKE 'ev1'| 2693Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2694mysqltest1 ev1 root@localhost SYSTEM ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED 1 koi8r koi8r_general_ci utf8_unicode_ci 2695 2696SHOW EVENTS LIKE 'ev2'| 2697Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2698mysqltest1 ev2 root@localhost SYSTEM ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED 1 koi8r koi8r_general_ci utf8_unicode_ci 2699 2700SHOW EVENTS LIKE 'ev3'| 2701Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2702 2703SHOW EVENTS LIKE 'ev4'| 2704Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation 2705 2706 2707SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'| 2708EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2709def mysqltest1 ev1 root@localhost SYSTEM SQL BEGIN 2710DECLARE �����1 CHAR(10); 2711SELECT 2712COLLATION(�����1) AS c1, 2713COLLATION('�����') AS c2, 2714COLLATION( '�����') AS c3, 2715COLLATION( '�����') AS c4, 2716@@collation_connection AS c5, 2717@@character_set_client AS c6; 2718END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2719 2720SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'| 2721EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2722def mysqltest1 ev2 root@localhost SYSTEM SQL BEGIN 2723DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2724SELECT 2725COLLATION(�����1) AS c1, 2726COLLATION('�����') AS c2, 2727COLLATION( '�����') AS c3, 2728COLLATION( '�����') AS c4, 2729@@collation_connection AS c5, 2730@@character_set_client AS c6; 2731END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2732 2733SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'| 2734EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2735def mysqltest2 ev3 root@localhost SYSTEM SQL BEGIN 2736DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2737SELECT 2738COLLATION(�����1) AS c1, 2739COLLATION('�����') AS c2, 2740COLLATION( '�����') AS c3, 2741COLLATION( '�����') AS c4, 2742@@collation_connection AS c5, 2743@@character_set_client AS c6; 2744END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2745 2746SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'| 2747EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION 2748def mysqltest2 ev4 root@localhost SYSTEM SQL BEGIN 2749DECLARE �����1 CHAR(10) CHARACTER SET utf8; 2750SELECT 2751COLLATION(�����1) AS c1, 2752COLLATION('�����') AS c2, 2753COLLATION( '�����') AS c3, 2754COLLATION( '�����') AS c4, 2755@@collation_connection AS c5, 2756@@character_set_client AS c6; 2757END ONE TIME 1970-01-02 00:00:00 NULL NULL NULL NULL DISABLED PRESERVE CREATED LAST_ALTERED NULL 1 koi8r koi8r_general_ci utf8_unicode_ci 2758 2759------------------------------------------------------------------- 2760DDL statements within stored routine. 2761------------------------------------------------------------------- 2762 2763DROP DATABASE IF EXISTS mysqltest1| 2764DROP DATABASE IF EXISTS mysqltest2| 2765CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 2766CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci| 2767use mysqltest1| 2768 2769CREATE PROCEDURE p1() 2770BEGIN 2771CREATE TABLE t1(col1 VARCHAR(10)); 2772SHOW CREATE TABLE t1; 2773END| 2774 2775CREATE PROCEDURE mysqltest2.p2() 2776BEGIN 2777CREATE TABLE t2(col1 VARCHAR(10)); 2778SHOW CREATE TABLE t2; 2779END| 2780 2781CALL p1()| 2782Table Create Table 2783t1 CREATE TABLE `t1` ( 2784 `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL 2785) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 2786 2787SHOW CREATE TABLE t1| 2788Table Create Table 2789t1 CREATE TABLE `t1` ( 2790 `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL 2791) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 2792 2793 2794CALL mysqltest2.p2()| 2795Table Create Table 2796t2 CREATE TABLE `t2` ( 2797 `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL 2798) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 2799 2800SHOW CREATE TABLE mysqltest2.t2| 2801Table Create Table 2802t2 CREATE TABLE `t2` ( 2803 `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL 2804) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 2805 2806ALTER DATABASE mysqltest1 COLLATE cp1251_general_cs| 2807ALTER DATABASE mysqltest2 COLLATE cp1251_general_cs| 2808DROP TABLE t1| 2809DROP TABLE mysqltest2.t2| 2810 2811CALL p1()| 2812Table Create Table 2813t1 CREATE TABLE `t1` ( 2814 `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL 2815) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs 2816 2817SHOW CREATE TABLE t1| 2818Table Create Table 2819t1 CREATE TABLE `t1` ( 2820 `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL 2821) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs 2822 2823 2824CALL mysqltest2.p2()| 2825Table Create Table 2826t2 CREATE TABLE `t2` ( 2827 `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL 2828) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs 2829 2830SHOW CREATE TABLE mysqltest2.t2| 2831Table Create Table 2832t2 CREATE TABLE `t2` ( 2833 `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL 2834) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs 2835connection con2; 2836disconnect con2; 2837connection con3; 2838disconnect con3; 2839connection default; 2840USE test; 2841DROP DATABASE mysqltest1; 2842DROP DATABASE mysqltest2; 2843