1set sql_mode=""; 2set names utf8; 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 _koi8r'����' as c1| 19 20CREATE VIEW v3 AS SELECT _koi8r'����'| 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` utf8 utf8_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 _koi8r'����' AS `c1` utf8 utf8_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 _koi8r'����' AS `тест` utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_general_ci UNDEFINED 48 49 50SELECT COLLATION(c1), COLLATION(c2) FROM v1| 51COLLATION(c1) COLLATION(c2) 52utf8_general_ci binary 53 54SELECT COLLATION(c1) FROM v2| 55COLLATION(c1) 56koi8r_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 utf8| 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` utf8 utf8_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 _koi8r'����' AS `c1` utf8 utf8_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 _koi8r'����' AS `тест` utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_general_ci UNDEFINED 99 100 101SELECT COLLATION(c1), COLLATION(c2) FROM v1| 102COLLATION(c1) COLLATION(c2) 103utf8_general_ci binary 104 105SELECT COLLATION(c1) FROM v2| 106COLLATION(c1) 107koi8r_general_ci 108 109SELECT * FROM v3| 110тест 111тест 112 113---> Dumping mysqltest1 to ddl_i18n_utf8views.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 utf8| 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` utf8 utf8_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 _koi8r'����' AS `c1` utf8 utf8_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 _koi8r'����' AS `тест` utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_general_ci UNDEFINED 155 156 157SELECT COLLATION(c1), COLLATION(c2) FROM v1| 158COLLATION(c1) COLLATION(c2) 159utf8_general_ci binary 160 161SELECT COLLATION(c1) FROM v2| 162COLLATION(c1) 163koi8r_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(_utf8 'текст') AS c5, 196COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c5, 215COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c5, 234COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c5, 253COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c5, 275COLLATION(_koi8r '�����') AS c6, 276@@collation_connection AS c7, 277@@character_set_client AS c8; 278SET парам1 = 'a'; 279SET парам2 = 'b'; 280END utf8 utf8_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(_utf8 'текст') AS c5, 296COLLATION(_koi8r '�����') AS c6, 297@@collation_connection AS c7, 298@@character_set_client AS c8; 299SET парам1 = 'a'; 300SET парам2 = 'b'; 301END utf8 utf8_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(_utf8 'текст') AS c5, 317COLLATION(_koi8r '�����') AS c6, 318@@collation_connection AS c7, 319@@character_set_client AS c8; 320SET парам1 = 'a'; 321SET парам2 = 'b'; 322END utf8 utf8_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(_utf8 'текст') AS c5, 338COLLATION(_koi8r '�����') AS c6, 339@@collation_connection AS c7, 340@@character_set_client AS c8; 341SET парам1 = 'a'; 342SET парам2 = 'b'; 343END utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 444utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 453utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 462utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 471utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 487utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 488CALL p2(@a, @b)| 489c1 c2 c3 490utf8_general_ci utf8_general_ci utf8_general_ci 491c4 c5 c6 c7 c8 492utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 493CALL mysqltest2.p3(@a, @b)| 494c1 c2 c3 495utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 496c4 c5 c6 c7 c8 497utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 498CALL mysqltest2.p4(@a, @b)| 499c1 c2 c3 500utf8_general_ci utf8_general_ci utf8_general_ci 501c4 c5 c6 c7 c8 502utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 503set names utf8| 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(_utf8 'текст') AS c5, 520COLLATION(_koi8r '�����') AS c6, 521@@collation_connection AS c7, 522@@character_set_client AS c8; 523SET парам1 = 'a'; 524SET парам2 = 'b'; 525END utf8 utf8_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(_utf8 'текст') AS c5, 541COLLATION(_koi8r '�����') AS c6, 542@@collation_connection AS c7, 543@@character_set_client AS c8; 544SET парам1 = 'a'; 545SET парам2 = 'b'; 546END utf8 utf8_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(_utf8 'текст') AS c5, 562COLLATION(_koi8r '�����') AS c6, 563@@collation_connection AS c7, 564@@character_set_client AS c8; 565SET парам1 = 'a'; 566SET парам2 = 'b'; 567END utf8 utf8_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(_utf8 'текст') AS c5, 583COLLATION(_koi8r '�����') AS c6, 584@@collation_connection AS c7, 585@@character_set_client AS c8; 586SET парам1 = 'a'; 587SET парам2 = 'b'; 588END utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 689utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 698utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 707utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 716utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 = utf8 */ ; 731/*!50003 SET character_set_results = utf8 */ ; 732/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c5, 748COLLATION(_koi8r '�����') 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 = utf8 */ ; 765/*!50003 SET character_set_results = utf8 */ ; 766/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c5, 782COLLATION(_koi8r '�����') 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_utf8sp.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 = utf8 */ ; 807/*!50003 SET character_set_results = utf8 */ ; 808/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c5, 824COLLATION(_koi8r '�����') 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 = utf8 */ ; 841/*!50003 SET character_set_results = utf8 */ ; 842/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c5, 858COLLATION(_koi8r '�����') 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_utf8sp.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 888utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 889CALL p2(@a, @b)| 890c1 c2 c3 891utf8_general_ci utf8_general_ci utf8_general_ci 892c4 c5 c6 c7 c8 893utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 894CALL mysqltest2.p3(@a, @b)| 895c1 c2 c3 896utf8_unicode_ci utf8_unicode_ci utf8_unicode_ci 897c4 c5 c6 c7 c8 898utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 899CALL mysqltest2.p4(@a, @b)| 900c1 c2 c3 901utf8_general_ci utf8_general_ci utf8_general_ci 902c4 c5 c6 c7 c8 903utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 904set names utf8| 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(_utf8 'текст') AS c5, 921COLLATION(_koi8r '�����') AS c6, 922@@collation_connection AS c7, 923@@character_set_client AS c8; 924SET парам1 = 'a'; 925SET парам2 = 'b'; 926END utf8 utf8_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(_utf8 'текст') AS c5, 942COLLATION(_koi8r '�����') AS c6, 943@@collation_connection AS c7, 944@@character_set_client AS c8; 945SET парам1 = 'a'; 946SET парам2 = 'b'; 947END utf8 utf8_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(_utf8 'текст') AS c5, 963COLLATION(_koi8r '�����') AS c6, 964@@collation_connection AS c7, 965@@character_set_client AS c8; 966SET парам1 = 'a'; 967SET парам2 = 'b'; 968END utf8 utf8_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(_utf8 'текст') AS c5, 984COLLATION(_koi8r '�����') AS c6, 985@@collation_connection AS c7, 986@@character_set_client AS c8; 987SET парам1 = 'a'; 988SET парам2 = 'b'; 989END utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 1090utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 1099utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 1108utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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 1117utf8_general_ci utf8_general_ci koi8r_general_ci utf8_general_ci utf8 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(_utf8 'текст')); 1148INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1149INSERT INTO log VALUES(@@collation_connection); 1150INSERT INTO log VALUES(@@character_set_client); 1151SET @a1 = 'текст'; 1152SET @a2 = _utf8 'текст'; 1153SET @a3 = _koi8r '�����'; 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(_utf8 'текст')); 1162INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1163INSERT INTO log VALUES(@@collation_connection); 1164INSERT INTO log VALUES(@@character_set_client); 1165SET @b1 = 'текст'; 1166SET @b2 = _utf8 'текст'; 1167SET @b3 = _koi8r '�����'; 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(_utf8 'текст')); 1176INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1177INSERT INTO log VALUES(@@collation_connection); 1178INSERT INTO log VALUES(@@character_set_client); 1179SET @a1 = 'текст'; 1180SET @a2 = _utf8 'текст'; 1181SET @a3 = _koi8r '�����'; 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(_utf8 'текст')); 1190INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1191INSERT INTO log VALUES(@@collation_connection); 1192INSERT INTO log VALUES(@@character_set_client); 1193SET @b1 = 'текст'; 1194SET @b2 = _utf8 'текст'; 1195SET @b3 = _koi8r '�����'; 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(_utf8 'текст')); 1208INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1209INSERT INTO log VALUES(@@collation_connection); 1210INSERT INTO log VALUES(@@character_set_client); 1211SET @a1 = 'текст'; 1212SET @a2 = _utf8 'текст'; 1213SET @a3 = _koi8r '�����'; 1214END utf8 utf8_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(_utf8 'текст')); 1224INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1225INSERT INTO log VALUES(@@collation_connection); 1226INSERT INTO log VALUES(@@character_set_client); 1227SET @b1 = 'текст'; 1228SET @b2 = _utf8 'текст'; 1229SET @b3 = _koi8r '�����'; 1230END utf8 utf8_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(_utf8 'текст')); 1240INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1241INSERT INTO log VALUES(@@collation_connection); 1242INSERT INTO log VALUES(@@character_set_client); 1243SET @a1 = 'текст'; 1244SET @a2 = _utf8 'текст'; 1245SET @a3 = _koi8r '�����'; 1246END utf8 utf8_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(_utf8 'текст')); 1256INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1257INSERT INTO log VALUES(@@collation_connection); 1258INSERT INTO log VALUES(@@character_set_client); 1259SET @b1 = 'текст'; 1260SET @b2 = _utf8 'текст'; 1261SET @b3 = _koi8r '�����'; 1262END utf8 utf8_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 @a2 = 'текст'; 1277SET @a3 = 'текст'; 1278END BEFORE # root@localhost utf8 utf8_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 @b2 = 'текст'; 1289SET @b3 = 'текст'; 1290END AFTER # root@localhost utf8 utf8_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 @a2 = 'текст'; 1306SET @a3 = 'текст'; 1307END BEFORE # root@localhost utf8 utf8_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 @b2 = 'текст'; 1318SET @b3 = 'текст'; 1319END AFTER # root@localhost utf8 utf8_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 @a2 = 'текст'; 1335SET @a3 = 'текст'; 1336END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @b2 = 'текст'; 1350SET @b3 = 'текст'; 1351END ROW AFTER NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @a2 = 'текст'; 1365SET @a3 = 'текст'; 1366END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @b2 = 'текст'; 1380SET @b3 = 'текст'; 1381END ROW AFTER NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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_general_ci 1398koi8r_general_ci 1399utf8 1400utf8 1401utf8_general_ci 1402utf8_general_ci 1403utf8_general_ci 1404utf8_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 1418utf8_general_ci utf8_general_ci koi8r_general_ci utf8_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_general_ci 1429koi8r_general_ci 1430utf8 1431utf8 1432utf8_general_ci 1433utf8_general_ci 1434utf8_general_ci 1435utf8_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 1449utf8_general_ci utf8_general_ci koi8r_general_ci utf8_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 utf8| 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(_utf8 'текст')); 1480INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1481INSERT INTO log VALUES(@@collation_connection); 1482INSERT INTO log VALUES(@@character_set_client); 1483SET @a1 = 'текст'; 1484SET @a2 = _utf8 'текст'; 1485SET @a3 = _koi8r '�����'; 1486END utf8 utf8_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(_utf8 'текст')); 1496INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1497INSERT INTO log VALUES(@@collation_connection); 1498INSERT INTO log VALUES(@@character_set_client); 1499SET @b1 = 'текст'; 1500SET @b2 = _utf8 'текст'; 1501SET @b3 = _koi8r '�����'; 1502END utf8 utf8_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(_utf8 'текст')); 1512INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1513INSERT INTO log VALUES(@@collation_connection); 1514INSERT INTO log VALUES(@@character_set_client); 1515SET @a1 = 'текст'; 1516SET @a2 = _utf8 'текст'; 1517SET @a3 = _koi8r '�����'; 1518END utf8 utf8_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(_utf8 'текст')); 1528INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1529INSERT INTO log VALUES(@@collation_connection); 1530INSERT INTO log VALUES(@@character_set_client); 1531SET @b1 = 'текст'; 1532SET @b2 = _utf8 'текст'; 1533SET @b3 = _koi8r '�����'; 1534END utf8 utf8_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 @a2 = 'текст'; 1549SET @a3 = 'текст'; 1550END BEFORE # root@localhost utf8 utf8_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 @b2 = 'текст'; 1561SET @b3 = 'текст'; 1562END AFTER # root@localhost utf8 utf8_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 @a2 = 'текст'; 1578SET @a3 = 'текст'; 1579END BEFORE # root@localhost utf8 utf8_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 @b2 = 'текст'; 1590SET @b3 = 'текст'; 1591END AFTER # root@localhost utf8 utf8_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 @a2 = 'текст'; 1607SET @a3 = 'текст'; 1608END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @b2 = 'текст'; 1622SET @b3 = 'текст'; 1623END ROW AFTER NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @a2 = 'текст'; 1637SET @a3 = 'текст'; 1638END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @b2 = 'текст'; 1652SET @b3 = 'текст'; 1653END ROW AFTER NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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_general_ci 1670koi8r_general_ci 1671utf8 1672utf8 1673utf8_general_ci 1674utf8_general_ci 1675utf8_general_ci 1676utf8_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 1690utf8_general_ci utf8_general_ci koi8r_general_ci utf8_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_general_ci 1701koi8r_general_ci 1702utf8 1703utf8 1704utf8_general_ci 1705utf8_general_ci 1706utf8_general_ci 1707utf8_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 1721utf8_general_ci utf8_general_ci koi8r_general_ci utf8_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 = utf8 */ ; 1748/*!50003 SET character_set_results = utf8 */ ; 1749/*!50003 SET collation_connection = utf8_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(_utf8 'текст')); 1759INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1760INSERT INTO log VALUES(@@collation_connection); 1761INSERT INTO log VALUES(@@character_set_client); 1762SET @a1 = 'текст'; 1763SET @a2 = _utf8 'текст'; 1764SET @a3 = _koi8r '�����'; 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 = utf8 */ ; 1777/*!50003 SET character_set_results = utf8 */ ; 1778/*!50003 SET collation_connection = utf8_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(_utf8 'текст')); 1788INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1789INSERT INTO log VALUES(@@collation_connection); 1790INSERT INTO log VALUES(@@character_set_client); 1791SET @b1 = 'текст'; 1792SET @b2 = _utf8 'текст'; 1793SET @b3 = _koi8r '�����'; 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_utf8triggers.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 = utf8 */ ; 1827/*!50003 SET character_set_results = utf8 */ ; 1828/*!50003 SET collation_connection = utf8_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(_utf8 'текст')); 1838INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1839INSERT INTO log VALUES(@@collation_connection); 1840INSERT INTO log VALUES(@@character_set_client); 1841SET @a1 = 'текст'; 1842SET @a2 = _utf8 'текст'; 1843SET @a3 = _koi8r '�����'; 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 = utf8 */ ; 1856/*!50003 SET character_set_results = utf8 */ ; 1857/*!50003 SET collation_connection = utf8_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(_utf8 'текст')); 1867INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1868INSERT INTO log VALUES(@@collation_connection); 1869INSERT INTO log VALUES(@@character_set_client); 1870SET @b1 = 'текст'; 1871SET @b2 = _utf8 'текст'; 1872SET @b3 = _koi8r '�����'; 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_utf8triggers.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 utf8| 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(_utf8 'текст')); 1914INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1915INSERT INTO log VALUES(@@collation_connection); 1916INSERT INTO log VALUES(@@character_set_client); 1917SET @a1 = 'текст'; 1918SET @a2 = _utf8 'текст'; 1919SET @a3 = _koi8r '�����'; 1920END utf8 utf8_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(_utf8 'текст')); 1930INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1931INSERT INTO log VALUES(@@collation_connection); 1932INSERT INTO log VALUES(@@character_set_client); 1933SET @b1 = 'текст'; 1934SET @b2 = _utf8 'текст'; 1935SET @b3 = _koi8r '�����'; 1936END utf8 utf8_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(_utf8 'текст')); 1946INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1947INSERT INTO log VALUES(@@collation_connection); 1948INSERT INTO log VALUES(@@character_set_client); 1949SET @a1 = 'текст'; 1950SET @a2 = _utf8 'текст'; 1951SET @a3 = _koi8r '�����'; 1952END utf8 utf8_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(_utf8 'текст')); 1962INSERT INTO log VALUES(COLLATION(_koi8r '�����')); 1963INSERT INTO log VALUES(@@collation_connection); 1964INSERT INTO log VALUES(@@character_set_client); 1965SET @b1 = 'текст'; 1966SET @b2 = _utf8 'текст'; 1967SET @b3 = _koi8r '�����'; 1968END utf8 utf8_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 @a2 = 'текст'; 1983SET @a3 = 'текст'; 1984END BEFORE # root@localhost utf8 utf8_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 @b2 = 'текст'; 1995SET @b3 = 'текст'; 1996END AFTER # root@localhost utf8 utf8_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 @a2 = 'текст'; 2012SET @a3 = 'текст'; 2013END BEFORE # root@localhost utf8 utf8_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 @b2 = 'текст'; 2024SET @b3 = 'текст'; 2025END AFTER # root@localhost utf8 utf8_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 @a2 = 'текст'; 2041SET @a3 = 'текст'; 2042END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @b2 = 'текст'; 2056SET @b3 = 'текст'; 2057END ROW AFTER NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @a2 = 'текст'; 2071SET @a3 = 'текст'; 2072END ROW BEFORE NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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 @b2 = 'текст'; 2086SET @b3 = 'текст'; 2087END ROW AFTER NULL NULL OLD NEW CREATED root@localhost utf8 utf8_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_general_ci 2104koi8r_general_ci 2105utf8 2106utf8 2107utf8_general_ci 2108utf8_general_ci 2109utf8_general_ci 2110utf8_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 2124utf8_general_ci utf8_general_ci koi8r_general_ci utf8_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_general_ci 2135koi8r_general_ci 2136utf8 2137utf8 2138utf8_general_ci 2139utf8_general_ci 2140utf8_general_ci 2141utf8_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 2155utf8_general_ci utf8_general_ci koi8r_general_ci utf8_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(_utf8 'текст') AS c3, 2182COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c3, 2196COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c3, 2210COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c3, 2224COLLATION(_koi8r '�����') 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(_utf8 'текст') AS c3, 2241COLLATION(_koi8r '�����') AS c4, 2242@@collation_connection AS c5, 2243@@character_set_client AS c6; 2244END utf8 utf8_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(_utf8 'текст') AS c3, 2254COLLATION(_koi8r '�����') AS c4, 2255@@collation_connection AS c5, 2256@@character_set_client AS c6; 2257END utf8 utf8_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(_utf8 'текст') AS c3, 2267COLLATION(_koi8r '�����') AS c4, 2268@@collation_connection AS c5, 2269@@character_set_client AS c6; 2270END utf8 utf8_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(_utf8 'текст') AS c3, 2280COLLATION(_koi8r '�����') AS c4, 2281@@collation_connection AS c5, 2282@@character_set_client AS c6; 2283END utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8| 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(_utf8 'текст') AS c3, 2375COLLATION(_koi8r '�����') AS c4, 2376@@collation_connection AS c5, 2377@@character_set_client AS c6; 2378END utf8 utf8_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(_utf8 'текст') AS c3, 2388COLLATION(_koi8r '�����') AS c4, 2389@@collation_connection AS c5, 2390@@character_set_client AS c6; 2391END utf8 utf8_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(_utf8 'текст') AS c3, 2401COLLATION(_koi8r '�����') AS c4, 2402@@collation_connection AS c5, 2403@@character_set_client AS c6; 2404END utf8 utf8_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(_utf8 'текст') AS c3, 2414COLLATION(_koi8r '�����') AS c4, 2415@@collation_connection AS c5, 2416@@character_set_client AS c6; 2417END utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 = utf8 */ ;; 2499/*!50003 SET character_set_results = utf8 */ ;; 2500/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c3, 2511COLLATION(_koi8r '�����') 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 = utf8 */ ;; 2527/*!50003 SET character_set_results = utf8 */ ;; 2528/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c3, 2539COLLATION(_koi8r '�����') 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_utf8events.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 = utf8 */ ;; 2566/*!50003 SET character_set_results = utf8 */ ;; 2567/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c3, 2578COLLATION(_koi8r '�����') 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 = utf8 */ ;; 2594/*!50003 SET character_set_results = utf8 */ ;; 2595/*!50003 SET collation_connection = utf8_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(_utf8 'текст') AS c3, 2606COLLATION(_koi8r '�����') 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_utf8events.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 utf8| 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(_utf8 'текст') AS c3, 2647COLLATION(_koi8r '�����') AS c4, 2648@@collation_connection AS c5, 2649@@character_set_client AS c6; 2650END utf8 utf8_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(_utf8 'текст') AS c3, 2660COLLATION(_koi8r '�����') AS c4, 2661@@collation_connection AS c5, 2662@@character_set_client AS c6; 2663END utf8 utf8_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(_utf8 'текст') AS c3, 2673COLLATION(_koi8r '�����') AS c4, 2674@@collation_connection AS c5, 2675@@character_set_client AS c6; 2676END utf8 utf8_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(_utf8 'текст') AS c3, 2686COLLATION(_koi8r '�����') AS c4, 2687@@collation_connection AS c5, 2688@@character_set_client AS c6; 2689END utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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 utf8 utf8_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