← Back to branch summary

~drizzle-trunk/drizzle/development

1 by brian
clean slate 
1
 
set names utf8;

2
 









3



-------------------------------------------------------------------










4



Views










5



-------------------------------------------------------------------










6












7



DROP DATABASE IF EXISTS mysqltest1|










8



CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










9



use mysqltest1|










10



CREATE TABLE t1(кПл INT)|










11



INSERT INTO t1 VALUES(1)|










12












13



CREATE VIEW v1 AS










14



SELECT 'тест' AS c1, кПл AS c2










15



FROM t1|










16












17



CREATE VIEW v2 AS SELECT _koi8r'ÔÅÓÔ' as c1|










18












19



CREATE VIEW v3 AS SELECT _koi8r'ÔÅÓÔ'|










20












21












22












23



SHOW CREATE VIEW v1|










24



View	Create View	character_set_client	collation_connection










25



v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 'тест' AS `c1`,`t1`.`кПл` AS `c2` from `t1`	utf8	utf8_general_ci










26












27



SHOW CREATE VIEW v2|










28



View	Create View	character_set_client	collation_connection










29



v2	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select _koi8r'ÔÅÓÔ' AS `c1`	utf8	utf8_general_ci










30












31



SHOW CREATE VIEW v3|










32



View	Create View	character_set_client	collation_connection










33



v3	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select _koi8r'ÔÅÓÔ' AS `тест`	utf8	utf8_general_ci










34












35












36



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v1'|










37



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










38



NULL	mysqltest1	v1	select 'тест' AS `c1`,`mysqltest1`.`t1`.`кПл` AS `c2` from `mysqltest1`.`t1`	NONE	YES	root@localhost	DEFINER	utf8	utf8_general_ci










39












40



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v2'|










41



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










42



NULL	mysqltest1	v2	select 'тест' AS `c1`	NONE	NO	root@localhost	DEFINER	utf8	utf8_general_ci










43












44



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v3'|










45



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










46



NULL	mysqltest1	v3	select 'тест' AS `тест`	NONE	NO	root@localhost	DEFINER	utf8	utf8_general_ci










47












48












49



SELECT COLLATION(c1), COLLATION(c2) FROM v1|










50



COLLATION(c1)	COLLATION(c2)










51



utf8_general_ci	binary










52












53



SELECT COLLATION(c1) FROM v2|










54



COLLATION(c1)










55



koi8r_general_ci










56












57



SELECT * FROM v3|










58



тест










59



тест










60












61












62



ALTER DATABASE mysqltest1 COLLATE cp866_general_ci|










63












64



---> connection: con2










65



SET @@character_set_client= cp1251|










66



SET @@character_set_results= cp1251|










67



SET @@collation_connection= cp1251_general_ci|










68



SELECT * FROM mysqltest1.v1|










69



SELECT * FROM mysqltest1.v2|










70



SELECT * FROM mysqltest1.v3|










71



use mysqltest1|










72



set names utf8|










73












74












75



SHOW CREATE VIEW v1|










76



View	Create View	character_set_client	collation_connection










77



v1	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












79



SHOW CREATE VIEW v2|










80



View	Create View	character_set_client	collation_connection










81



v2	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select _koi8r'ÔÅÓÔ' AS `c1`	utf8	utf8_general_ci










82












83



SHOW CREATE VIEW v3|










84



View	Create View	character_set_client	collation_connection










85



v3	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select _koi8r'ÔÅÓÔ' AS `тест`	utf8	utf8_general_ci










86












87












88



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v1'|










89



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










90



NULL	mysqltest1	v1	select 'тест' AS `c1`,`mysqltest1`.`t1`.`кПл` AS `c2` from `mysqltest1`.`t1`	NONE	YES	root@localhost	DEFINER	utf8	utf8_general_ci










91












92



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v2'|










93



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










94



NULL	mysqltest1	v2	select 'тест' AS `c1`	NONE	NO	root@localhost	DEFINER	utf8	utf8_general_ci










95












96



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v3'|










97



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










98



NULL	mysqltest1	v3	select 'тест' AS `тест`	NONE	NO	root@localhost	DEFINER	utf8	utf8_general_ci










99












100












101



SELECT COLLATION(c1), COLLATION(c2) FROM v1|










102



COLLATION(c1)	COLLATION(c2)










103



utf8_general_ci	binary










104












105



SELECT COLLATION(c1) FROM v2|










106



COLLATION(c1)










107



koi8r_general_ci










108












109



SELECT * FROM v3|










110



тест










111



тест










112












113



---> Dumping mysqltest1 to ddl_i18n_utf8views.mysqltest1.sql










114












115












116



DROP DATABASE mysqltest1|










117












118












119



---> Restoring mysqltest1...










120












121



---> connection: con3










122



SET @@character_set_client= cp1251|










123



SET @@character_set_results= cp1251|










124



SET @@collation_connection= cp1251_general_ci|










125



SELECT * FROM mysqltest1.v1|










126



SELECT * FROM mysqltest1.v2|










127



SELECT * FROM mysqltest1.v3|










128



use mysqltest1|










129



set names utf8|










130












131












132



SHOW CREATE VIEW v1|










133



View	Create View	character_set_client	collation_connection










134



v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 'тест' AS `c1`,`t1`.`кПл` AS `c2` from `t1`	utf8	utf8_general_ci










135












136



SHOW CREATE VIEW v2|










137



View	Create View	character_set_client	collation_connection










138



v2	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select _koi8r'ÔÅÓÔ' AS `c1`	utf8	utf8_general_ci










139












140



SHOW CREATE VIEW v3|










141



View	Create View	character_set_client	collation_connection










142



v3	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select _koi8r'ÔÅÓÔ' AS `тест`	utf8	utf8_general_ci










143












144












145



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v1'|










146



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










147



NULL	mysqltest1	v1	select 'тест' AS `c1`,`mysqltest1`.`t1`.`кПл` AS `c2` from `mysqltest1`.`t1`	NONE	YES	root@localhost	DEFINER	utf8	utf8_general_ci










148












149



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v2'|










150



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










151



NULL	mysqltest1	v2	select 'тест' AS `c1`	NONE	NO	root@localhost	DEFINER	utf8	utf8_general_ci










152












153



SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE table_name = 'v3'|










154



TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION










155



NULL	mysqltest1	v3	select 'тест' AS `тест`	NONE	NO	root@localhost	DEFINER	utf8	utf8_general_ci










156












157












158



SELECT COLLATION(c1), COLLATION(c2) FROM v1|










159



COLLATION(c1)	COLLATION(c2)










160



utf8_general_ci	binary










161












162



SELECT COLLATION(c1) FROM v2|










163



COLLATION(c1)










164



koi8r_general_ci










165












166



SELECT * FROM v3|










167



тест










168



тест










169












170



---> connection: default










171



use test|










172



DROP DATABASE mysqltest1|










173












174



-------------------------------------------------------------------










175



Stored procedures/functions










176



-------------------------------------------------------------------










177












178



DROP DATABASE IF EXISTS mysqltest1|










179



DROP DATABASE IF EXISTS mysqltest2|










180



CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










181



CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










182



use mysqltest1|










183












184



CREATE PROCEDURE p1(










185



INOUT параЌ1 CHAR(10),










186



OUT параЌ2 CHAR(10))










187



BEGIN










188



DECLARE переЌ1 CHAR(10);










189



SELECT










190



COLLATION(переЌ1) AS c1,










191



COLLATION(параЌ1) AS c2,










192



COLLATION(параЌ2) AS c3;










193



SELECT










194



COLLATION('текст') AS c4,










195



COLLATION(_utf8 'текст') AS c5,










196



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










197



@@collation_connection AS c7,










198



@@character_set_client AS c8;










199



SET параЌ1 = 'a';










200



SET параЌ2 = 'b';










201



END|










202












203



CREATE PROCEDURE p2(










204



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










205



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










206



BEGIN










207



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










208



SELECT










209



COLLATION(переЌ1) AS c1,










210



COLLATION(параЌ1) AS c2,










211



COLLATION(параЌ2) AS c3;










212



SELECT










213



COLLATION('текст') AS c4,










214



COLLATION(_utf8 'текст') AS c5,










215



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










216



@@collation_connection AS c7,










217



@@character_set_client AS c8;










218



SET параЌ1 = 'a';










219



SET параЌ2 = 'b';










220



END|










221












222



CREATE PROCEDURE mysqltest2.p3(










223



INOUT параЌ1 CHAR(10),










224



OUT параЌ2 CHAR(10))










225



BEGIN










226



DECLARE переЌ1 CHAR(10);










227



SELECT










228



COLLATION(переЌ1) AS c1,










229



COLLATION(параЌ1) AS c2,










230



COLLATION(параЌ2) AS c3;










231



SELECT










232



COLLATION('текст') AS c4,










233



COLLATION(_utf8 'текст') AS c5,










234



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










235



@@collation_connection AS c7,










236



@@character_set_client AS c8;










237



SET параЌ1 = 'a';










238



SET параЌ2 = 'b';










239



END|










240












241



CREATE PROCEDURE mysqltest2.p4(










242



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










243



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










244



BEGIN










245



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










246



SELECT










247



COLLATION(переЌ1) AS c1,










248



COLLATION(параЌ1) AS c2,










249



COLLATION(параЌ2) AS c3;










250



SELECT










251



COLLATION('текст') AS c4,










252



COLLATION(_utf8 'текст') AS c5,










253



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










254



@@collation_connection AS c7,










255



@@character_set_client AS c8;










256



SET параЌ1 = 'a';










257



SET параЌ2 = 'b';










258



END|










259












260












261



SHOW CREATE PROCEDURE p1|










262



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










263



p1		CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(










264



INOUT параЌ1 CHAR(10),










265



OUT параЌ2 CHAR(10))










266



BEGIN










267



DECLARE переЌ1 CHAR(10);










268



SELECT










269



COLLATION(переЌ1) AS c1,










270



COLLATION(параЌ1) AS c2,










271



COLLATION(параЌ2) AS c3;










272



SELECT










273



COLLATION('текст') AS c4,










274



COLLATION(_utf8 'текст') AS c5,










275



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










276



@@collation_connection AS c7,










277



@@character_set_client AS c8;










278



SET параЌ1 = 'a';










279



SET параЌ2 = 'b';










280



END	utf8	utf8_general_ci	utf8_unicode_ci










281












282



SHOW CREATE PROCEDURE p2|










283



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










284



p2		CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(










285



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










286



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










287



BEGIN










288



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










289



SELECT










290



COLLATION(переЌ1) AS c1,










291



COLLATION(параЌ1) AS c2,










292



COLLATION(параЌ2) AS c3;










293



SELECT










294



COLLATION('текст') AS c4,










295



COLLATION(_utf8 'текст') AS c5,










296



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










297



@@collation_connection AS c7,










298



@@character_set_client AS c8;










299



SET параЌ1 = 'a';










300



SET параЌ2 = 'b';










301



END	utf8	utf8_general_ci	utf8_unicode_ci










302












303



SHOW CREATE PROCEDURE mysqltest2.p3|










304



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










305



p3		CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`(










306



INOUT параЌ1 CHAR(10),










307



OUT параЌ2 CHAR(10))










308



BEGIN










309



DECLARE переЌ1 CHAR(10);










310



SELECT










311



COLLATION(переЌ1) AS c1,










312



COLLATION(параЌ1) AS c2,










313



COLLATION(параЌ2) AS c3;










314



SELECT










315



COLLATION('текст') AS c4,










316



COLLATION(_utf8 'текст') AS c5,










317



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










318



@@collation_connection AS c7,










319



@@character_set_client AS c8;










320



SET параЌ1 = 'a';










321



SET параЌ2 = 'b';










322



END	utf8	utf8_general_ci	utf8_unicode_ci










323












324



SHOW CREATE PROCEDURE mysqltest2.p4|










325



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










326



p4		CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`(










327



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










328



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










329



BEGIN










330



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










331



SELECT










332



COLLATION(переЌ1) AS c1,










333



COLLATION(параЌ1) AS c2,










334



COLLATION(параЌ2) AS c3;










335



SELECT










336



COLLATION('текст') AS c4,










337



COLLATION(_utf8 'текст') AS c5,










338



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










339



@@collation_connection AS c7,










340



@@character_set_client AS c8;










341



SET параЌ1 = 'a';










342



SET параЌ2 = 'b';










343



END	utf8	utf8_general_ci	utf8_unicode_ci










344












345












346



SHOW PROCEDURE STATUS LIKE 'p1'|










347



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










348



mysqltest1	p1	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










349












350



SHOW PROCEDURE STATUS LIKE 'p2'|










351



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










352



mysqltest1	p2	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










353












354



SHOW PROCEDURE STATUS LIKE 'p3'|










355



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










356



mysqltest2	p3	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










357












358



SHOW PROCEDURE STATUS LIKE 'p4'|










359



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










360



mysqltest2	p4	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










361












362












363



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p1'|










364



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










365



p1	NULL	mysqltest1	p1	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










366



DECLARE переЌ1 CHAR(10);










367



SELECT










368



COLLATION(переЌ1) AS c1,










369



COLLATION(параЌ1) AS c2,










370



COLLATION(параЌ2) AS c3;










371



SELECT










372



COLLATION('текст') AS c4,










373



COLLATION( 'текст') AS c5,










374



COLLATION(    'текст') AS c6,










375



@@collation_connection AS c7,










376



@@character_set_client AS c8;










377



SET параЌ1 = 'a';










378



SET параЌ2 = 'b';










379



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










380












381



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p2'|










382



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










383



p2	NULL	mysqltest1	p2	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










384



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










385



SELECT










386



COLLATION(переЌ1) AS c1,










387



COLLATION(параЌ1) AS c2,










388



COLLATION(параЌ2) AS c3;










389



SELECT










390



COLLATION('текст') AS c4,










391



COLLATION( 'текст') AS c5,










392



COLLATION(    'текст') AS c6,










393



@@collation_connection AS c7,










394



@@character_set_client AS c8;










395



SET параЌ1 = 'a';










396



SET параЌ2 = 'b';










397



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










398












399



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p3'|










400



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










401



p3	NULL	mysqltest2	p3	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










402



DECLARE переЌ1 CHAR(10);










403



SELECT










404



COLLATION(переЌ1) AS c1,










405



COLLATION(параЌ1) AS c2,










406



COLLATION(параЌ2) AS c3;










407



SELECT










408



COLLATION('текст') AS c4,










409



COLLATION( 'текст') AS c5,










410



COLLATION(    'текст') AS c6,










411



@@collation_connection AS c7,










412



@@character_set_client AS c8;










413



SET параЌ1 = 'a';










414



SET параЌ2 = 'b';










415



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










416












417



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p4'|










418



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










419



p4	NULL	mysqltest2	p4	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










420



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










421



SELECT










422



COLLATION(переЌ1) AS c1,










423



COLLATION(параЌ1) AS c2,










424



COLLATION(параЌ2) AS c3;










425



SELECT










426



COLLATION('текст') AS c4,










427



COLLATION( 'текст') AS c5,










428



COLLATION(    'текст') AS c6,










429



@@collation_connection AS c7,










430



@@character_set_client AS c8;










431



SET параЌ1 = 'a';










432



SET параЌ2 = 'b';










433



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










434












435












436



SET @a = '1'|










437



SET @b = '2'|










438












439












440



CALL p1(@a, @b)|










441



c1	c2	c3










442



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










443



c4	c5	c6	c7	c8










444



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










445



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










446



ca	cb










447



utf8_unicode_ci	utf8_unicode_ci










448












449



CALL p2(@a, @b)|










450



c1	c2	c3










451



utf8_general_ci	utf8_general_ci	utf8_general_ci










452



c4	c5	c6	c7	c8










453



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










454



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










455



ca	cb










456



utf8_general_ci	utf8_general_ci










457












458



CALL mysqltest2.p3(@a, @b)|










459



c1	c2	c3










460



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










461



c4	c5	c6	c7	c8










462



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










463



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










464



ca	cb










465



utf8_unicode_ci	utf8_unicode_ci










466












467



CALL mysqltest2.p4(@a, @b)|










468



c1	c2	c3










469



utf8_general_ci	utf8_general_ci	utf8_general_ci










470



c4	c5	c6	c7	c8










471



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










472



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










473



ca	cb










474



utf8_general_ci	utf8_general_ci










475












476












477



ALTER DATABASE mysqltest1 COLLATE cp866_general_ci|










478



ALTER DATABASE mysqltest2 COLLATE cp866_general_ci|










479












480



---> connection: con2










481



SET @@character_set_client= cp1251|










482



SET @@character_set_results= cp1251|










483



SET @@collation_connection= cp1251_general_ci|










484



CALL p1(@a, @b)|










485



c1	c2	c3










486



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










487



c4	c5	c6	c7	c8










488



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










489



CALL p2(@a, @b)|










490



c1	c2	c3










491



utf8_general_ci	utf8_general_ci	utf8_general_ci










492



c4	c5	c6	c7	c8










493



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










494



CALL mysqltest2.p3(@a, @b)|










495



c1	c2	c3










496



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










497



c4	c5	c6	c7	c8










498



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










499



CALL mysqltest2.p4(@a, @b)|










500



c1	c2	c3










501



utf8_general_ci	utf8_general_ci	utf8_general_ci










502



c4	c5	c6	c7	c8










503



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










504



set names utf8|










505












506












507



SHOW CREATE PROCEDURE p1|










508



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










509



p1		CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(










510



INOUT параЌ1 CHAR(10),










511



OUT параЌ2 CHAR(10))










512



BEGIN










513



DECLARE переЌ1 CHAR(10);










514



SELECT










515



COLLATION(переЌ1) AS c1,










516



COLLATION(параЌ1) AS c2,










517



COLLATION(параЌ2) AS c3;










518



SELECT










519



COLLATION('текст') AS c4,










520



COLLATION(_utf8 'текст') AS c5,










521



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










522



@@collation_connection AS c7,










523



@@character_set_client AS c8;










524



SET параЌ1 = 'a';










525



SET параЌ2 = 'b';










526



END	utf8	utf8_general_ci	utf8_unicode_ci










527












528



SHOW CREATE PROCEDURE p2|










529



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










530



p2		CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(










531



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










532



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










533



BEGIN










534



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










535



SELECT










536



COLLATION(переЌ1) AS c1,










537



COLLATION(параЌ1) AS c2,










538



COLLATION(параЌ2) AS c3;










539



SELECT










540



COLLATION('текст') AS c4,










541



COLLATION(_utf8 'текст') AS c5,










542



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










543



@@collation_connection AS c7,










544



@@character_set_client AS c8;










545



SET параЌ1 = 'a';










546



SET параЌ2 = 'b';










547



END	utf8	utf8_general_ci	utf8_unicode_ci










548












549



SHOW CREATE PROCEDURE mysqltest2.p3|










550



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










551



p3		CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`(










552



INOUT параЌ1 CHAR(10),










553



OUT параЌ2 CHAR(10))










554



BEGIN










555



DECLARE переЌ1 CHAR(10);










556



SELECT










557



COLLATION(переЌ1) AS c1,










558



COLLATION(параЌ1) AS c2,










559



COLLATION(параЌ2) AS c3;










560



SELECT










561



COLLATION('текст') AS c4,










562



COLLATION(_utf8 'текст') AS c5,










563



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










564



@@collation_connection AS c7,










565



@@character_set_client AS c8;










566



SET параЌ1 = 'a';










567



SET параЌ2 = 'b';










568



END	utf8	utf8_general_ci	utf8_unicode_ci










569












570



SHOW CREATE PROCEDURE mysqltest2.p4|










571



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










572



p4		CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`(










573



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










574



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










575



BEGIN










576



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










577



SELECT










578



COLLATION(переЌ1) AS c1,










579



COLLATION(параЌ1) AS c2,










580



COLLATION(параЌ2) AS c3;










581



SELECT










582



COLLATION('текст') AS c4,










583



COLLATION(_utf8 'текст') AS c5,










584



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










585



@@collation_connection AS c7,










586



@@character_set_client AS c8;










587



SET параЌ1 = 'a';










588



SET параЌ2 = 'b';










589



END	utf8	utf8_general_ci	utf8_unicode_ci










590












591












592



SHOW PROCEDURE STATUS LIKE 'p1'|










593



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










594



mysqltest1	p1	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










595












596



SHOW PROCEDURE STATUS LIKE 'p2'|










597



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










598



mysqltest1	p2	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










599












600



SHOW PROCEDURE STATUS LIKE 'p3'|










601



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










602



mysqltest2	p3	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










603












604



SHOW PROCEDURE STATUS LIKE 'p4'|










605



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










606



mysqltest2	p4	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










607












608












609



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p1'|










610



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










611



p1	NULL	mysqltest1	p1	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










612



DECLARE переЌ1 CHAR(10);










613



SELECT










614



COLLATION(переЌ1) AS c1,










615



COLLATION(параЌ1) AS c2,










616



COLLATION(параЌ2) AS c3;










617



SELECT










618



COLLATION('текст') AS c4,










619



COLLATION( 'текст') AS c5,










620



COLLATION(    'текст') AS c6,










621



@@collation_connection AS c7,










622



@@character_set_client AS c8;










623



SET параЌ1 = 'a';










624



SET параЌ2 = 'b';










625



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










626












627



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p2'|










628



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










629



p2	NULL	mysqltest1	p2	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










630



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










631



SELECT










632



COLLATION(переЌ1) AS c1,










633



COLLATION(параЌ1) AS c2,










634



COLLATION(параЌ2) AS c3;










635



SELECT










636



COLLATION('текст') AS c4,










637



COLLATION( 'текст') AS c5,










638



COLLATION(    'текст') AS c6,










639



@@collation_connection AS c7,










640



@@character_set_client AS c8;










641



SET параЌ1 = 'a';










642



SET параЌ2 = 'b';










643



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










644












645



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p3'|










646



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










647



p3	NULL	mysqltest2	p3	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










648



DECLARE переЌ1 CHAR(10);










649



SELECT










650



COLLATION(переЌ1) AS c1,










651



COLLATION(параЌ1) AS c2,










652



COLLATION(параЌ2) AS c3;










653



SELECT










654



COLLATION('текст') AS c4,










655



COLLATION( 'текст') AS c5,










656



COLLATION(    'текст') AS c6,










657



@@collation_connection AS c7,










658



@@character_set_client AS c8;










659



SET параЌ1 = 'a';










660



SET параЌ2 = 'b';










661



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










662












663



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p4'|










664



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










665



p4	NULL	mysqltest2	p4	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










666



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










667



SELECT










668



COLLATION(переЌ1) AS c1,










669



COLLATION(параЌ1) AS c2,










670



COLLATION(параЌ2) AS c3;










671



SELECT










672



COLLATION('текст') AS c4,










673



COLLATION( 'текст') AS c5,










674



COLLATION(    'текст') AS c6,










675



@@collation_connection AS c7,










676



@@character_set_client AS c8;










677



SET параЌ1 = 'a';










678



SET параЌ2 = 'b';










679



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










680












681












682



SET @a = '1'|










683



SET @b = '2'|










684












685












686



CALL p1(@a, @b)|










687



c1	c2	c3










688



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










689



c4	c5	c6	c7	c8










690



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










691



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










692



ca	cb










693



utf8_unicode_ci	utf8_unicode_ci










694












695



CALL p2(@a, @b)|










696



c1	c2	c3










697



utf8_general_ci	utf8_general_ci	utf8_general_ci










698



c4	c5	c6	c7	c8










699



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










700



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










701



ca	cb










702



utf8_general_ci	utf8_general_ci










703












704



CALL mysqltest2.p3(@a, @b)|










705



c1	c2	c3










706



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










707



c4	c5	c6	c7	c8










708



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










709



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










710



ca	cb










711



utf8_unicode_ci	utf8_unicode_ci










712












713



CALL mysqltest2.p4(@a, @b)|










714



c1	c2	c3










715



utf8_general_ci	utf8_general_ci	utf8_general_ci










716



c4	c5	c6	c7	c8










717



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










718



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










719



ca	cb










720



utf8_general_ci	utf8_general_ci










721












722



---> Dump of mysqltest1










723












724



CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp866 */;










725












726



USE `mysqltest1`;










727



ALTER DATABASE mysqltest1 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










728



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










729



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










730



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










731



/*!50003 SET character_set_client  = utf8 */ ;










732



/*!50003 SET character_set_results = utf8 */ ;










733



/*!50003 SET collation_connection  = utf8_general_ci */ ;










734



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










735



/*!50003 SET sql_mode              = '' */ ;










736



DELIMITER ;;










737



/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `p1`(










738



INOUT параЌ1 CHAR(10),










739



OUT параЌ2 CHAR(10))










740



BEGIN










741



DECLARE переЌ1 CHAR(10);










742



SELECT










743



COLLATION(переЌ1) AS c1,










744



COLLATION(параЌ1) AS c2,










745



COLLATION(параЌ2) AS c3;










746



SELECT










747



COLLATION('текст') AS c4,










748



COLLATION(_utf8 'текст') AS c5,










749



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










750



@@collation_connection AS c7,










751



@@character_set_client AS c8;










752



SET параЌ1 = 'a';










753



SET параЌ2 = 'b';










754



END */;;










755



DELIMITER ;










756



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










757



/*!50003 SET character_set_client  = @saved_cs_client */ ;










758



/*!50003 SET character_set_results = @saved_cs_results */ ;










759



/*!50003 SET collation_connection  = @saved_col_connection */ ;










760



ALTER DATABASE mysqltest1 CHARACTER SET cp866 COLLATE cp866_general_ci ;










761



ALTER DATABASE mysqltest1 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










762



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










763



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










764



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










765



/*!50003 SET character_set_client  = utf8 */ ;










766



/*!50003 SET character_set_results = utf8 */ ;










767



/*!50003 SET collation_connection  = utf8_general_ci */ ;










768



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










769



/*!50003 SET sql_mode              = '' */ ;










770



DELIMITER ;;










771



/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `p2`(










772



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










773



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










774



BEGIN










775



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










776



SELECT










777



COLLATION(переЌ1) AS c1,










778



COLLATION(параЌ1) AS c2,










779



COLLATION(параЌ2) AS c3;










780



SELECT










781



COLLATION('текст') AS c4,










782



COLLATION(_utf8 'текст') AS c5,










783



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










784



@@collation_connection AS c7,










785



@@character_set_client AS c8;










786



SET параЌ1 = 'a';










787



SET параЌ2 = 'b';










788



END */;;










789



DELIMITER ;










790



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










791



/*!50003 SET character_set_client  = @saved_cs_client */ ;










792



/*!50003 SET character_set_results = @saved_cs_results */ ;










793



/*!50003 SET collation_connection  = @saved_col_connection */ ;










794



ALTER DATABASE mysqltest1 CHARACTER SET cp866 COLLATE cp866_general_ci ;










795












796



---> Dumping mysqltest1 to ddl_i18n_utf8sp.mysqltest1.sql










797












798



---> Dump of mysqltest2










799












800



CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest2` /*!40100 DEFAULT CHARACTER SET cp866 */;










801












802



USE `mysqltest2`;










803



ALTER DATABASE mysqltest2 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










804



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










805



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










806



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










807



/*!50003 SET character_set_client  = utf8 */ ;










808



/*!50003 SET character_set_results = utf8 */ ;










809



/*!50003 SET collation_connection  = utf8_general_ci */ ;










810



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










811



/*!50003 SET sql_mode              = '' */ ;










812



DELIMITER ;;










813



/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `p3`(










814



INOUT параЌ1 CHAR(10),










815



OUT параЌ2 CHAR(10))










816



BEGIN










817



DECLARE переЌ1 CHAR(10);










818



SELECT










819



COLLATION(переЌ1) AS c1,










820



COLLATION(параЌ1) AS c2,










821



COLLATION(параЌ2) AS c3;










822



SELECT










823



COLLATION('текст') AS c4,










824



COLLATION(_utf8 'текст') AS c5,










825



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










826



@@collation_connection AS c7,










827



@@character_set_client AS c8;










828



SET параЌ1 = 'a';










829



SET параЌ2 = 'b';










830



END */;;










831



DELIMITER ;










832



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










833



/*!50003 SET character_set_client  = @saved_cs_client */ ;










834



/*!50003 SET character_set_results = @saved_cs_results */ ;










835



/*!50003 SET collation_connection  = @saved_col_connection */ ;










836



ALTER DATABASE mysqltest2 CHARACTER SET cp866 COLLATE cp866_general_ci ;










837



ALTER DATABASE mysqltest2 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










838



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










839



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










840



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










841



/*!50003 SET character_set_client  = utf8 */ ;










842



/*!50003 SET character_set_results = utf8 */ ;










843



/*!50003 SET collation_connection  = utf8_general_ci */ ;










844



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










845



/*!50003 SET sql_mode              = '' */ ;










846



DELIMITER ;;










847



/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `p4`(










848



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










849



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










850



BEGIN










851



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










852



SELECT










853



COLLATION(переЌ1) AS c1,










854



COLLATION(параЌ1) AS c2,










855



COLLATION(параЌ2) AS c3;










856



SELECT










857



COLLATION('текст') AS c4,










858



COLLATION(_utf8 'текст') AS c5,










859



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










860



@@collation_connection AS c7,










861



@@character_set_client AS c8;










862



SET параЌ1 = 'a';










863



SET параЌ2 = 'b';










864



END */;;










865



DELIMITER ;










866



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










867



/*!50003 SET character_set_client  = @saved_cs_client */ ;










868



/*!50003 SET character_set_results = @saved_cs_results */ ;










869



/*!50003 SET collation_connection  = @saved_col_connection */ ;










870



ALTER DATABASE mysqltest2 CHARACTER SET cp866 COLLATE cp866_general_ci ;










871












872



---> Dumping mysqltest2 to ddl_i18n_utf8sp.mysqltest2.sql










873












874












875



DROP DATABASE mysqltest1|










876



DROP DATABASE mysqltest2|










877












878












879



---> Restoring mysqltest1...










880



---> Restoring mysqltest2...










881












882



---> connection: con3










883



SET @@character_set_client= cp1251|










884



SET @@character_set_results= cp1251|










885



SET @@collation_connection= cp1251_general_ci|










886



CALL p1(@a, @b)|










887



c1	c2	c3










888



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










889



c4	c5	c6	c7	c8










890



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










891



CALL p2(@a, @b)|










892



c1	c2	c3










893



utf8_general_ci	utf8_general_ci	utf8_general_ci










894



c4	c5	c6	c7	c8










895



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










896



CALL mysqltest2.p3(@a, @b)|










897



c1	c2	c3










898



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










899



c4	c5	c6	c7	c8










900



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










901



CALL mysqltest2.p4(@a, @b)|










902



c1	c2	c3










903



utf8_general_ci	utf8_general_ci	utf8_general_ci










904



c4	c5	c6	c7	c8










905



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










906



set names utf8|










907












908












909



SHOW CREATE PROCEDURE p1|










910



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










911



p1		CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(










912



INOUT параЌ1 CHAR(10),










913



OUT параЌ2 CHAR(10))










914



BEGIN










915



DECLARE переЌ1 CHAR(10);










916



SELECT










917



COLLATION(переЌ1) AS c1,










918



COLLATION(параЌ1) AS c2,










919



COLLATION(параЌ2) AS c3;










920



SELECT










921



COLLATION('текст') AS c4,










922



COLLATION(_utf8 'текст') AS c5,










923



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










924



@@collation_connection AS c7,










925



@@character_set_client AS c8;










926



SET параЌ1 = 'a';










927



SET параЌ2 = 'b';










928



END	utf8	utf8_general_ci	utf8_unicode_ci










929












930



SHOW CREATE PROCEDURE p2|










931



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










932



p2		CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`(










933



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










934



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










935



BEGIN










936



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










937



SELECT










938



COLLATION(переЌ1) AS c1,










939



COLLATION(параЌ1) AS c2,










940



COLLATION(параЌ2) AS c3;










941



SELECT










942



COLLATION('текст') AS c4,










943



COLLATION(_utf8 'текст') AS c5,










944



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










945



@@collation_connection AS c7,










946



@@character_set_client AS c8;










947



SET параЌ1 = 'a';










948



SET параЌ2 = 'b';










949



END	utf8	utf8_general_ci	utf8_unicode_ci










950












951



SHOW CREATE PROCEDURE mysqltest2.p3|










952



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










953



p3		CREATE DEFINER=`root`@`localhost` PROCEDURE `p3`(










954



INOUT параЌ1 CHAR(10),










955



OUT параЌ2 CHAR(10))










956



BEGIN










957



DECLARE переЌ1 CHAR(10);










958



SELECT










959



COLLATION(переЌ1) AS c1,










960



COLLATION(параЌ1) AS c2,










961



COLLATION(параЌ2) AS c3;










962



SELECT










963



COLLATION('текст') AS c4,










964



COLLATION(_utf8 'текст') AS c5,










965



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










966



@@collation_connection AS c7,










967



@@character_set_client AS c8;










968



SET параЌ1 = 'a';










969



SET параЌ2 = 'b';










970



END	utf8	utf8_general_ci	utf8_unicode_ci










971












972



SHOW CREATE PROCEDURE mysqltest2.p4|










973



Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation










974



p4		CREATE DEFINER=`root`@`localhost` PROCEDURE `p4`(










975



INOUT параЌ1 CHAR(10) CHARACTER SET utf8,










976



OUT параЌ2 CHAR(10) CHARACTER SET utf8)










977



BEGIN










978



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










979



SELECT










980



COLLATION(переЌ1) AS c1,










981



COLLATION(параЌ1) AS c2,










982



COLLATION(параЌ2) AS c3;










983



SELECT










984



COLLATION('текст') AS c4,










985



COLLATION(_utf8 'текст') AS c5,










986



COLLATION(_koi8r    'ÔÅËÓÔ') AS c6,










987



@@collation_connection AS c7,










988



@@character_set_client AS c8;










989



SET параЌ1 = 'a';










990



SET параЌ2 = 'b';










991



END	utf8	utf8_general_ci	utf8_unicode_ci










992












993












994



SHOW PROCEDURE STATUS LIKE 'p1'|










995



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










996



mysqltest1	p1	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










997












998



SHOW PROCEDURE STATUS LIKE 'p2'|










999



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










1000



mysqltest1	p2	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










1001












1002



SHOW PROCEDURE STATUS LIKE 'p3'|










1003



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










1004



mysqltest2	p3	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










1005












1006



SHOW PROCEDURE STATUS LIKE 'p4'|










1007



Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation










1008



mysqltest2	p4	PROCEDURE	root@localhost	MODIFIED	CREATED	DEFINER		utf8	utf8_general_ci	utf8_unicode_ci










1009












1010












1011



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p1'|










1012



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










1013



p1	NULL	mysqltest1	p1	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










1014



DECLARE переЌ1 CHAR(10);










1015



SELECT










1016



COLLATION(переЌ1) AS c1,










1017



COLLATION(параЌ1) AS c2,










1018



COLLATION(параЌ2) AS c3;










1019



SELECT










1020



COLLATION('текст') AS c4,










1021



COLLATION( 'текст') AS c5,










1022



COLLATION(    'текст') AS c6,










1023



@@collation_connection AS c7,










1024



@@character_set_client AS c8;










1025



SET параЌ1 = 'a';










1026



SET параЌ2 = 'b';










1027



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1028












1029



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p2'|










1030



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










1031



p2	NULL	mysqltest1	p2	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










1032



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1033



SELECT










1034



COLLATION(переЌ1) AS c1,










1035



COLLATION(параЌ1) AS c2,










1036



COLLATION(параЌ2) AS c3;










1037



SELECT










1038



COLLATION('текст') AS c4,










1039



COLLATION( 'текст') AS c5,










1040



COLLATION(    'текст') AS c6,










1041



@@collation_connection AS c7,










1042



@@character_set_client AS c8;










1043



SET параЌ1 = 'a';










1044



SET параЌ2 = 'b';










1045



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1046












1047



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p3'|










1048



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










1049



p3	NULL	mysqltest2	p3	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










1050



DECLARE переЌ1 CHAR(10);










1051



SELECT










1052



COLLATION(переЌ1) AS c1,










1053



COLLATION(параЌ1) AS c2,










1054



COLLATION(параЌ2) AS c3;










1055



SELECT










1056



COLLATION('текст') AS c4,










1057



COLLATION( 'текст') AS c5,










1058



COLLATION(    'текст') AS c6,










1059



@@collation_connection AS c7,










1060



@@character_set_client AS c8;










1061



SET параЌ1 = 'a';










1062



SET параЌ2 = 'b';










1063



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1064












1065



SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_name = 'p4'|










1066



SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	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










1067



p4	NULL	mysqltest2	p4	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN










1068



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1069



SELECT










1070



COLLATION(переЌ1) AS c1,










1071



COLLATION(параЌ1) AS c2,










1072



COLLATION(параЌ2) AS c3;










1073



SELECT










1074



COLLATION('текст') AS c4,










1075



COLLATION( 'текст') AS c5,










1076



COLLATION(    'текст') AS c6,










1077



@@collation_connection AS c7,










1078



@@character_set_client AS c8;










1079



SET параЌ1 = 'a';










1080



SET параЌ2 = 'b';










1081



END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	CREATED	ALTERED			root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1082












1083












1084



SET @a = '1'|










1085



SET @b = '2'|










1086












1087












1088



CALL p1(@a, @b)|










1089



c1	c2	c3










1090



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










1091



c4	c5	c6	c7	c8










1092



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










1093



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










1094



ca	cb










1095



utf8_unicode_ci	utf8_unicode_ci










1096












1097



CALL p2(@a, @b)|










1098



c1	c2	c3










1099



utf8_general_ci	utf8_general_ci	utf8_general_ci










1100



c4	c5	c6	c7	c8










1101



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










1102



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










1103



ca	cb










1104



utf8_general_ci	utf8_general_ci










1105












1106



CALL mysqltest2.p3(@a, @b)|










1107



c1	c2	c3










1108



utf8_unicode_ci	utf8_unicode_ci	utf8_unicode_ci










1109



c4	c5	c6	c7	c8










1110



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










1111



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










1112



ca	cb










1113



utf8_unicode_ci	utf8_unicode_ci










1114












1115



CALL mysqltest2.p4(@a, @b)|










1116



c1	c2	c3










1117



utf8_general_ci	utf8_general_ci	utf8_general_ci










1118



c4	c5	c6	c7	c8










1119



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8










1120



SELECT COLLATION(@a) AS ca, COLLATION(@b) cb|










1121



ca	cb










1122



utf8_general_ci	utf8_general_ci










1123












1124



---> connection: default










1125



use test|










1126



DROP DATABASE mysqltest1|










1127



DROP DATABASE mysqltest2|










1128












1129



-------------------------------------------------------------------










1130



Triggers










1131



-------------------------------------------------------------------










1132












1133



DROP DATABASE IF EXISTS mysqltest1|










1134



DROP DATABASE IF EXISTS mysqltest2|










1135



CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










1136



CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










1137



use mysqltest1|










1138



CREATE TABLE t1(c INT)|










1139



CREATE TABLE mysqltest2.t1(c INT)|










1140



CREATE TABLE log(msg VARCHAR(255))|










1141



CREATE TABLE mysqltest2.log(msg VARCHAR(255))|










1142












1143



CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW










1144



BEGIN










1145



DECLARE переЌ1 CHAR(10);










1146



INSERT INTO log VALUES(COLLATION(переЌ1));










1147



INSERT INTO log VALUES(COLLATION('текст'));










1148



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1149



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1150



INSERT INTO log VALUES(@@collation_connection);










1151



INSERT INTO log VALUES(@@character_set_client);










1152



SET @a1 = 'текст';










1153



SET @a2 = _utf8 'текст';










1154



SET @a3 = _koi8r    'ÔÅËÓÔ';










1155



END|










1156












1157



CREATE TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW










1158



BEGIN










1159



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1160



INSERT INTO log VALUES(COLLATION(переЌ1));










1161



INSERT INTO log VALUES(COLLATION('текст'));










1162



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1163



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1164



INSERT INTO log VALUES(@@collation_connection);










1165



INSERT INTO log VALUES(@@character_set_client);










1166



SET @b1 = 'текст';










1167



SET @b2 = _utf8 'текст';










1168



SET @b3 = _koi8r    'ÔÅËÓÔ';










1169



END|










1170












1171



CREATE TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW










1172



BEGIN










1173



DECLARE переЌ1 CHAR(10);










1174



INSERT INTO log VALUES(COLLATION(переЌ1));










1175



INSERT INTO log VALUES(COLLATION('текст'));










1176



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1177



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1178



INSERT INTO log VALUES(@@collation_connection);










1179



INSERT INTO log VALUES(@@character_set_client);










1180



SET @a1 = 'текст';










1181



SET @a2 = _utf8 'текст';










1182



SET @a3 = _koi8r    'ÔÅËÓÔ';










1183



END|










1184












1185



CREATE TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW










1186



BEGIN










1187



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1188



INSERT INTO log VALUES(COLLATION(переЌ1));










1189



INSERT INTO log VALUES(COLLATION('текст'));










1190



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1191



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1192



INSERT INTO log VALUES(@@collation_connection);










1193



INSERT INTO log VALUES(@@character_set_client);










1194



SET @b1 = 'текст';










1195



SET @b2 = _utf8 'текст';










1196



SET @b3 = _koi8r    'ÔÅËÓÔ';










1197



END|










1198












1199












1200












1201



SHOW CREATE TRIGGER trg1|










1202



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1203



trg1		CREATE DEFINER=`root`@`localhost` TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW










1204



BEGIN










1205



DECLARE переЌ1 CHAR(10);










1206



INSERT INTO log VALUES(COLLATION(переЌ1));










1207



INSERT INTO log VALUES(COLLATION('текст'));










1208



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1209



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1210



INSERT INTO log VALUES(@@collation_connection);










1211



INSERT INTO log VALUES(@@character_set_client);










1212



SET @a1 = 'текст';










1213



SET @a2 = _utf8 'текст';










1214



SET @a3 = _koi8r    'ÔÅËÓÔ';










1215



END	utf8	utf8_general_ci	utf8_unicode_ci










1216












1217



SHOW CREATE TRIGGER trg2|










1218



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1219



trg2		CREATE DEFINER=`root`@`localhost` TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW










1220



BEGIN










1221



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1222



INSERT INTO log VALUES(COLLATION(переЌ1));










1223



INSERT INTO log VALUES(COLLATION('текст'));










1224



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1225



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1226



INSERT INTO log VALUES(@@collation_connection);










1227



INSERT INTO log VALUES(@@character_set_client);










1228



SET @b1 = 'текст';










1229



SET @b2 = _utf8 'текст';










1230



SET @b3 = _koi8r    'ÔÅËÓÔ';










1231



END	utf8	utf8_general_ci	utf8_unicode_ci










1232












1233



SHOW CREATE TRIGGER mysqltest2.trg3|










1234



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1235



trg3		CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW










1236



BEGIN










1237



DECLARE переЌ1 CHAR(10);










1238



INSERT INTO log VALUES(COLLATION(переЌ1));










1239



INSERT INTO log VALUES(COLLATION('текст'));










1240



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1241



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1242



INSERT INTO log VALUES(@@collation_connection);










1243



INSERT INTO log VALUES(@@character_set_client);










1244



SET @a1 = 'текст';










1245



SET @a2 = _utf8 'текст';










1246



SET @a3 = _koi8r    'ÔÅËÓÔ';










1247



END	utf8	utf8_general_ci	utf8_unicode_ci










1248












1249



SHOW CREATE TRIGGER mysqltest2.trg4|










1250



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1251



trg4		CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW










1252



BEGIN










1253



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1254



INSERT INTO log VALUES(COLLATION(переЌ1));










1255



INSERT INTO log VALUES(COLLATION('текст'));










1256



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1257



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1258



INSERT INTO log VALUES(@@collation_connection);










1259



INSERT INTO log VALUES(@@character_set_client);










1260



SET @b1 = 'текст';










1261



SET @b2 = _utf8 'текст';










1262



SET @b3 = _koi8r    'ÔÅËÓÔ';










1263



END	utf8	utf8_general_ci	utf8_unicode_ci










1264












1265












1266



SHOW TRIGGERS|










1267



Trigger	Event	Table	Statement	Timing	Created	sql_mode	Definer	character_set_client	collation_connection	Database Collation










1268



trg1	INSERT	t1	BEGIN










1269



DECLARE переЌ1 CHAR(10);










1270



INSERT INTO log VALUES(COLLATION(переЌ1));










1271



INSERT INTO log VALUES(COLLATION('текст'));










1272



INSERT INTO log VALUES(COLLATION( 'текст'));










1273



INSERT INTO log VALUES(COLLATION(    'текст'));










1274



INSERT INTO log VALUES(@@collation_connection);










1275



INSERT INTO log VALUES(@@character_set_client);










1276



SET @a1 = 'текст';










1277



SET @a2 =  'текст';










1278



SET @a3 =     'текст';










1279



END	BEFORE	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1280



trg2	INSERT	t1	BEGIN










1281



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1282



INSERT INTO log VALUES(COLLATION(переЌ1));










1283



INSERT INTO log VALUES(COLLATION('текст'));










1284



INSERT INTO log VALUES(COLLATION( 'текст'));










1285



INSERT INTO log VALUES(COLLATION(    'текст'));










1286



INSERT INTO log VALUES(@@collation_connection);










1287



INSERT INTO log VALUES(@@character_set_client);










1288



SET @b1 = 'текст';










1289



SET @b2 =  'текст';










1290



SET @b3 =     'текст';










1291



END	AFTER	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1292












1293



use mysqltest2|










1294












1295



SHOW TRIGGERS|










1296



Trigger	Event	Table	Statement	Timing	Created	sql_mode	Definer	character_set_client	collation_connection	Database Collation










1297



trg3	INSERT	t1	BEGIN










1298



DECLARE переЌ1 CHAR(10);










1299



INSERT INTO log VALUES(COLLATION(переЌ1));










1300



INSERT INTO log VALUES(COLLATION('текст'));










1301



INSERT INTO log VALUES(COLLATION( 'текст'));










1302



INSERT INTO log VALUES(COLLATION(    'текст'));










1303



INSERT INTO log VALUES(@@collation_connection);










1304



INSERT INTO log VALUES(@@character_set_client);










1305



SET @a1 = 'текст';










1306



SET @a2 =  'текст';










1307



SET @a3 =     'текст';










1308



END	BEFORE	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1309



trg4	INSERT	t1	BEGIN










1310



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1311



INSERT INTO log VALUES(COLLATION(переЌ1));










1312



INSERT INTO log VALUES(COLLATION('текст'));










1313



INSERT INTO log VALUES(COLLATION( 'текст'));










1314



INSERT INTO log VALUES(COLLATION(    'текст'));










1315



INSERT INTO log VALUES(@@collation_connection);










1316



INSERT INTO log VALUES(@@character_set_client);










1317



SET @b1 = 'текст';










1318



SET @b2 =  'текст';










1319



SET @b3 =     'текст';










1320



END	AFTER	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1321



use mysqltest1|










1322












1323












1324



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'|










1325



TRIGGER_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










1326



NULL	mysqltest1	trg1	INSERT	NULL	mysqltest1	t1	0	NULL	BEGIN










1327



DECLARE переЌ1 CHAR(10);










1328



INSERT INTO log VALUES(COLLATION(переЌ1));










1329



INSERT INTO log VALUES(COLLATION('текст'));










1330



INSERT INTO log VALUES(COLLATION( 'текст'));










1331



INSERT INTO log VALUES(COLLATION(    'текст'));










1332



INSERT INTO log VALUES(@@collation_connection);










1333



INSERT INTO log VALUES(@@character_set_client);










1334



SET @a1 = 'текст';










1335



SET @a2 =  'текст';










1336



SET @a3 =     'текст';










1337



END	ROW	BEFORE	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1338












1339



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'|










1340



TRIGGER_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










1341



NULL	mysqltest1	trg2	INSERT	NULL	mysqltest1	t1	0	NULL	BEGIN










1342



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1343



INSERT INTO log VALUES(COLLATION(переЌ1));










1344



INSERT INTO log VALUES(COLLATION('текст'));










1345



INSERT INTO log VALUES(COLLATION( 'текст'));










1346



INSERT INTO log VALUES(COLLATION(    'текст'));










1347



INSERT INTO log VALUES(@@collation_connection);










1348



INSERT INTO log VALUES(@@character_set_client);










1349



SET @b1 = 'текст';










1350



SET @b2 =  'текст';










1351



SET @b3 =     'текст';










1352



END	ROW	AFTER	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1353












1354



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'|










1355



TRIGGER_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










1356



NULL	mysqltest2	trg3	INSERT	NULL	mysqltest2	t1	0	NULL	BEGIN










1357



DECLARE переЌ1 CHAR(10);










1358



INSERT INTO log VALUES(COLLATION(переЌ1));










1359



INSERT INTO log VALUES(COLLATION('текст'));










1360



INSERT INTO log VALUES(COLLATION( 'текст'));










1361



INSERT INTO log VALUES(COLLATION(    'текст'));










1362



INSERT INTO log VALUES(@@collation_connection);










1363



INSERT INTO log VALUES(@@character_set_client);










1364



SET @a1 = 'текст';










1365



SET @a2 =  'текст';










1366



SET @a3 =     'текст';










1367



END	ROW	BEFORE	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1368












1369



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'|










1370



TRIGGER_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










1371



NULL	mysqltest2	trg4	INSERT	NULL	mysqltest2	t1	0	NULL	BEGIN










1372



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1373



INSERT INTO log VALUES(COLLATION(переЌ1));










1374



INSERT INTO log VALUES(COLLATION('текст'));










1375



INSERT INTO log VALUES(COLLATION( 'текст'));










1376



INSERT INTO log VALUES(COLLATION(    'текст'));










1377



INSERT INTO log VALUES(@@collation_connection);










1378



INSERT INTO log VALUES(@@character_set_client);










1379



SET @b1 = 'текст';










1380



SET @b2 =  'текст';










1381



SET @b3 =     'текст';










1382



END	ROW	AFTER	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1383












1384












1385



SET @a1 = '1'|










1386



SET @a2 = '1'|










1387



SET @a3 = '1'|










1388



SET @b1 = '2'|










1389



SET @b2 = '2'|










1390



SET @b3 = '2'|










1391












1392












1393



INSERT INTO t1 VALUES(1)|










1394












1395



---> Log:










1396



SELECT msg FROM log|










1397



msg










1398



utf8_unicode_ci










1399



utf8_general_ci










1400



utf8_general_ci










1401



koi8r_general_ci










1402



utf8_general_ci










1403



utf8










1404



utf8_general_ci










1405



utf8_general_ci










1406



utf8_general_ci










1407



koi8r_general_ci










1408



utf8_general_ci










1409



utf8










1410












1411



SELECT










1412



COLLATION(@a1) AS ca1,










1413



COLLATION(@a2) AS ca2,










1414



COLLATION(@a3) AS ca3,










1415



COLLATION(@b1) AS cb1,










1416



COLLATION(@b2) AS cb2,










1417



COLLATION(@b3) AS cb3|










1418



ca1	ca2	ca3	cb1	cb2	cb3










1419



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8_general_ci	koi8r_general_ci










1420












1421



DELETE FROM log|










1422












1423












1424



INSERT INTO mysqltest2.t1 VALUES(1)|










1425












1426



---> Log:










1427



SELECT msg FROM mysqltest2.log|










1428



msg










1429



utf8_unicode_ci










1430



utf8_general_ci










1431



utf8_general_ci










1432



koi8r_general_ci










1433



utf8_general_ci










1434



utf8










1435



utf8_general_ci










1436



utf8_general_ci










1437



utf8_general_ci










1438



koi8r_general_ci










1439



utf8_general_ci










1440



utf8










1441












1442



SELECT










1443



COLLATION(@a1) AS ca1,










1444



COLLATION(@a2) AS ca2,










1445



COLLATION(@a3) AS ca3,










1446



COLLATION(@b1) AS cb1,










1447



COLLATION(@b2) AS cb2,










1448



COLLATION(@b3) AS cb3|










1449



ca1	ca2	ca3	cb1	cb2	cb3










1450



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8_general_ci	koi8r_general_ci










1451












1452



DELETE FROM mysqltest2.log|










1453












1454












1455



ALTER DATABASE mysqltest1 COLLATE cp866_general_ci|










1456



ALTER DATABASE mysqltest2 COLLATE cp866_general_ci|










1457



ALTER TABLE t1 ADD COLUMN fake INT|










1458



ALTER TABLE t1 DROP COLUMN fake|










1459



ALTER TABLE mysqltest2.t1 ADD COLUMN fake INT|










1460



ALTER TABLE mysqltest2.t1 DROP COLUMN fake|










1461












1462



---> connection: con2










1463



SET @@character_set_client= cp1251|










1464



SET @@character_set_results= cp1251|










1465



SET @@collation_connection= cp1251_general_ci|










1466



INSERT INTO mysqltest1.t1 VALUES(0)|










1467



INSERT INTO mysqltest2.t1 VALUES(0)|










1468



DELETE FROM mysqltest1.log|










1469



DELETE FROM mysqltest2.log|










1470



set names utf8|










1471



use mysqltest1|










1472












1473












1474



SHOW CREATE TRIGGER trg1|










1475



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1476



trg1		CREATE DEFINER=`root`@`localhost` TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW










1477



BEGIN










1478



DECLARE переЌ1 CHAR(10);










1479



INSERT INTO log VALUES(COLLATION(переЌ1));










1480



INSERT INTO log VALUES(COLLATION('текст'));










1481



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1482



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1483



INSERT INTO log VALUES(@@collation_connection);










1484



INSERT INTO log VALUES(@@character_set_client);










1485



SET @a1 = 'текст';










1486



SET @a2 = _utf8 'текст';










1487



SET @a3 = _koi8r    'ÔÅËÓÔ';










1488



END	utf8	utf8_general_ci	utf8_unicode_ci










1489












1490



SHOW CREATE TRIGGER trg2|










1491



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1492



trg2		CREATE DEFINER=`root`@`localhost` TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW










1493



BEGIN










1494



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1495



INSERT INTO log VALUES(COLLATION(переЌ1));










1496



INSERT INTO log VALUES(COLLATION('текст'));










1497



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1498



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1499



INSERT INTO log VALUES(@@collation_connection);










1500



INSERT INTO log VALUES(@@character_set_client);










1501



SET @b1 = 'текст';










1502



SET @b2 = _utf8 'текст';










1503



SET @b3 = _koi8r    'ÔÅËÓÔ';










1504



END	utf8	utf8_general_ci	utf8_unicode_ci










1505












1506



SHOW CREATE TRIGGER mysqltest2.trg3|










1507



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1508



trg3		CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW










1509



BEGIN










1510



DECLARE переЌ1 CHAR(10);










1511



INSERT INTO log VALUES(COLLATION(переЌ1));










1512



INSERT INTO log VALUES(COLLATION('текст'));










1513



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1514



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1515



INSERT INTO log VALUES(@@collation_connection);










1516



INSERT INTO log VALUES(@@character_set_client);










1517



SET @a1 = 'текст';










1518



SET @a2 = _utf8 'текст';










1519



SET @a3 = _koi8r    'ÔÅËÓÔ';










1520



END	utf8	utf8_general_ci	utf8_unicode_ci










1521












1522



SHOW CREATE TRIGGER mysqltest2.trg4|










1523



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1524



trg4		CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW










1525



BEGIN










1526



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1527



INSERT INTO log VALUES(COLLATION(переЌ1));










1528



INSERT INTO log VALUES(COLLATION('текст'));










1529



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1530



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1531



INSERT INTO log VALUES(@@collation_connection);










1532



INSERT INTO log VALUES(@@character_set_client);










1533



SET @b1 = 'текст';










1534



SET @b2 = _utf8 'текст';










1535



SET @b3 = _koi8r    'ÔÅËÓÔ';










1536



END	utf8	utf8_general_ci	utf8_unicode_ci










1537












1538












1539



SHOW TRIGGERS|










1540



Trigger	Event	Table	Statement	Timing	Created	sql_mode	Definer	character_set_client	collation_connection	Database Collation










1541



trg1	INSERT	t1	BEGIN










1542



DECLARE переЌ1 CHAR(10);










1543



INSERT INTO log VALUES(COLLATION(переЌ1));










1544



INSERT INTO log VALUES(COLLATION('текст'));










1545



INSERT INTO log VALUES(COLLATION( 'текст'));










1546



INSERT INTO log VALUES(COLLATION(    'текст'));










1547



INSERT INTO log VALUES(@@collation_connection);










1548



INSERT INTO log VALUES(@@character_set_client);










1549



SET @a1 = 'текст';










1550



SET @a2 =  'текст';










1551



SET @a3 =     'текст';










1552



END	BEFORE	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1553



trg2	INSERT	t1	BEGIN










1554



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1555



INSERT INTO log VALUES(COLLATION(переЌ1));










1556



INSERT INTO log VALUES(COLLATION('текст'));










1557



INSERT INTO log VALUES(COLLATION( 'текст'));










1558



INSERT INTO log VALUES(COLLATION(    'текст'));










1559



INSERT INTO log VALUES(@@collation_connection);










1560



INSERT INTO log VALUES(@@character_set_client);










1561



SET @b1 = 'текст';










1562



SET @b2 =  'текст';










1563



SET @b3 =     'текст';










1564



END	AFTER	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1565












1566



use mysqltest2|










1567












1568



SHOW TRIGGERS|










1569



Trigger	Event	Table	Statement	Timing	Created	sql_mode	Definer	character_set_client	collation_connection	Database Collation










1570



trg3	INSERT	t1	BEGIN










1571



DECLARE переЌ1 CHAR(10);










1572



INSERT INTO log VALUES(COLLATION(переЌ1));










1573



INSERT INTO log VALUES(COLLATION('текст'));










1574



INSERT INTO log VALUES(COLLATION( 'текст'));










1575



INSERT INTO log VALUES(COLLATION(    'текст'));










1576



INSERT INTO log VALUES(@@collation_connection);










1577



INSERT INTO log VALUES(@@character_set_client);










1578



SET @a1 = 'текст';










1579



SET @a2 =  'текст';










1580



SET @a3 =     'текст';










1581



END	BEFORE	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1582



trg4	INSERT	t1	BEGIN










1583



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1584



INSERT INTO log VALUES(COLLATION(переЌ1));










1585



INSERT INTO log VALUES(COLLATION('текст'));










1586



INSERT INTO log VALUES(COLLATION( 'текст'));










1587



INSERT INTO log VALUES(COLLATION(    'текст'));










1588



INSERT INTO log VALUES(@@collation_connection);










1589



INSERT INTO log VALUES(@@character_set_client);










1590



SET @b1 = 'текст';










1591



SET @b2 =  'текст';










1592



SET @b3 =     'текст';










1593



END	AFTER	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1594



use mysqltest1|










1595












1596












1597



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'|










1598



TRIGGER_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










1599



NULL	mysqltest1	trg1	INSERT	NULL	mysqltest1	t1	0	NULL	BEGIN










1600



DECLARE переЌ1 CHAR(10);










1601



INSERT INTO log VALUES(COLLATION(переЌ1));










1602



INSERT INTO log VALUES(COLLATION('текст'));










1603



INSERT INTO log VALUES(COLLATION( 'текст'));










1604



INSERT INTO log VALUES(COLLATION(    'текст'));










1605



INSERT INTO log VALUES(@@collation_connection);










1606



INSERT INTO log VALUES(@@character_set_client);










1607



SET @a1 = 'текст';










1608



SET @a2 =  'текст';










1609



SET @a3 =     'текст';










1610



END	ROW	BEFORE	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1611












1612



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'|










1613



TRIGGER_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










1614



NULL	mysqltest1	trg2	INSERT	NULL	mysqltest1	t1	0	NULL	BEGIN










1615



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1616



INSERT INTO log VALUES(COLLATION(переЌ1));










1617



INSERT INTO log VALUES(COLLATION('текст'));










1618



INSERT INTO log VALUES(COLLATION( 'текст'));










1619



INSERT INTO log VALUES(COLLATION(    'текст'));










1620



INSERT INTO log VALUES(@@collation_connection);










1621



INSERT INTO log VALUES(@@character_set_client);










1622



SET @b1 = 'текст';










1623



SET @b2 =  'текст';










1624



SET @b3 =     'текст';










1625



END	ROW	AFTER	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1626












1627



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'|










1628



TRIGGER_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










1629



NULL	mysqltest2	trg3	INSERT	NULL	mysqltest2	t1	0	NULL	BEGIN










1630



DECLARE переЌ1 CHAR(10);










1631



INSERT INTO log VALUES(COLLATION(переЌ1));










1632



INSERT INTO log VALUES(COLLATION('текст'));










1633



INSERT INTO log VALUES(COLLATION( 'текст'));










1634



INSERT INTO log VALUES(COLLATION(    'текст'));










1635



INSERT INTO log VALUES(@@collation_connection);










1636



INSERT INTO log VALUES(@@character_set_client);










1637



SET @a1 = 'текст';










1638



SET @a2 =  'текст';










1639



SET @a3 =     'текст';










1640



END	ROW	BEFORE	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1641












1642



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'|










1643



TRIGGER_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










1644



NULL	mysqltest2	trg4	INSERT	NULL	mysqltest2	t1	0	NULL	BEGIN










1645



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1646



INSERT INTO log VALUES(COLLATION(переЌ1));










1647



INSERT INTO log VALUES(COLLATION('текст'));










1648



INSERT INTO log VALUES(COLLATION( 'текст'));










1649



INSERT INTO log VALUES(COLLATION(    'текст'));










1650



INSERT INTO log VALUES(@@collation_connection);










1651



INSERT INTO log VALUES(@@character_set_client);










1652



SET @b1 = 'текст';










1653



SET @b2 =  'текст';










1654



SET @b3 =     'текст';










1655



END	ROW	AFTER	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1656












1657












1658



SET @a1 = '1'|










1659



SET @a2 = '1'|










1660



SET @a3 = '1'|










1661



SET @b1 = '2'|










1662



SET @b2 = '2'|










1663



SET @b3 = '2'|










1664












1665












1666



INSERT INTO t1 VALUES(1)|










1667












1668



---> Log:










1669



SELECT msg FROM log|










1670



msg










1671



utf8_unicode_ci










1672



utf8_general_ci










1673



utf8_general_ci










1674



koi8r_general_ci










1675



utf8_general_ci










1676



utf8










1677



utf8_general_ci










1678



utf8_general_ci










1679



utf8_general_ci










1680



koi8r_general_ci










1681



utf8_general_ci










1682



utf8










1683












1684



SELECT










1685



COLLATION(@a1) AS ca1,










1686



COLLATION(@a2) AS ca2,










1687



COLLATION(@a3) AS ca3,










1688



COLLATION(@b1) AS cb1,










1689



COLLATION(@b2) AS cb2,










1690



COLLATION(@b3) AS cb3|










1691



ca1	ca2	ca3	cb1	cb2	cb3










1692



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8_general_ci	koi8r_general_ci










1693












1694



DELETE FROM log|










1695












1696












1697



INSERT INTO mysqltest2.t1 VALUES(1)|










1698












1699



---> Log:










1700



SELECT msg FROM mysqltest2.log|










1701



msg










1702



utf8_unicode_ci










1703



utf8_general_ci










1704



utf8_general_ci










1705



koi8r_general_ci










1706



utf8_general_ci










1707



utf8










1708



utf8_general_ci










1709



utf8_general_ci










1710



utf8_general_ci










1711



koi8r_general_ci










1712



utf8_general_ci










1713



utf8










1714












1715



SELECT










1716



COLLATION(@a1) AS ca1,










1717



COLLATION(@a2) AS ca2,










1718



COLLATION(@a3) AS ca3,










1719



COLLATION(@b1) AS cb1,










1720



COLLATION(@b2) AS cb2,










1721



COLLATION(@b3) AS cb3|










1722



ca1	ca2	ca3	cb1	cb2	cb3










1723



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8_general_ci	koi8r_general_ci










1724












1725



DELETE FROM mysqltest2.log|










1726












1727



---> Dump of mysqltest1










1728












1729



CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp866 */;










1730












1731



USE `mysqltest1`;










1732



SET @saved_cs_client     = @@character_set_client;










1733



SET character_set_client = utf8;










1734



CREATE TABLE `log` (










1735



  `msg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL










1736



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;










1737



SET character_set_client = @saved_cs_client;










1738



SET @saved_cs_client     = @@character_set_client;










1739



SET character_set_client = utf8;










1740



CREATE TABLE `t1` (










1741



  `c` int(11) DEFAULT NULL










1742



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;










1743



SET character_set_client = @saved_cs_client;










1744



INSERT INTO `t1` VALUES (1),(0),(1);










1745



ALTER DATABASE mysqltest1 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










1746



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










1747



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










1748



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










1749



/*!50003 SET character_set_client  = utf8 */ ;










1750



/*!50003 SET character_set_results = utf8 */ ;










1751



/*!50003 SET collation_connection  = utf8_general_ci */ ;










1752



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










1753



/*!50003 SET sql_mode              = '' */ ;










1754



DELIMITER ;;










1755



/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW










1756



BEGIN










1757



DECLARE переЌ1 CHAR(10);










1758



INSERT INTO log VALUES(COLLATION(переЌ1));










1759



INSERT INTO log VALUES(COLLATION('текст'));










1760



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1761



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1762



INSERT INTO log VALUES(@@collation_connection);










1763



INSERT INTO log VALUES(@@character_set_client);










1764



SET @a1 = 'текст';










1765



SET @a2 = _utf8 'текст';










1766



SET @a3 = _koi8r    'ÔÅËÓÔ';










1767



END */;;










1768



DELIMITER ;










1769



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










1770



/*!50003 SET character_set_client  = @saved_cs_client */ ;










1771



/*!50003 SET character_set_results = @saved_cs_results */ ;










1772



/*!50003 SET collation_connection  = @saved_col_connection */ ;










1773



ALTER DATABASE mysqltest1 CHARACTER SET cp866 COLLATE cp866_general_ci ;










1774



ALTER DATABASE mysqltest1 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










1775



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










1776



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










1777



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










1778



/*!50003 SET character_set_client  = utf8 */ ;










1779



/*!50003 SET character_set_results = utf8 */ ;










1780



/*!50003 SET collation_connection  = utf8_general_ci */ ;










1781



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










1782



/*!50003 SET sql_mode              = '' */ ;










1783



DELIMITER ;;










1784



/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW










1785



BEGIN










1786



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1787



INSERT INTO log VALUES(COLLATION(переЌ1));










1788



INSERT INTO log VALUES(COLLATION('текст'));










1789



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1790



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1791



INSERT INTO log VALUES(@@collation_connection);










1792



INSERT INTO log VALUES(@@character_set_client);










1793



SET @b1 = 'текст';










1794



SET @b2 = _utf8 'текст';










1795



SET @b3 = _koi8r    'ÔÅËÓÔ';










1796



END */;;










1797



DELIMITER ;










1798



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










1799



/*!50003 SET character_set_client  = @saved_cs_client */ ;










1800



/*!50003 SET character_set_results = @saved_cs_results */ ;










1801



/*!50003 SET collation_connection  = @saved_col_connection */ ;










1802



ALTER DATABASE mysqltest1 CHARACTER SET cp866 COLLATE cp866_general_ci ;










1803












1804



---> Dumping mysqltest1 to ddl_i18n_utf8triggers.mysqltest1.sql










1805












1806



---> Dump of mysqltest2










1807












1808



CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest2` /*!40100 DEFAULT CHARACTER SET cp866 */;










1809












1810



USE `mysqltest2`;










1811



SET @saved_cs_client     = @@character_set_client;










1812



SET character_set_client = utf8;










1813



CREATE TABLE `log` (










1814



  `msg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL










1815



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;










1816



SET character_set_client = @saved_cs_client;










1817



SET @saved_cs_client     = @@character_set_client;










1818



SET character_set_client = utf8;










1819



CREATE TABLE `t1` (










1820



  `c` int(11) DEFAULT NULL










1821



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;










1822



SET character_set_client = @saved_cs_client;










1823



INSERT INTO `t1` VALUES (1),(0),(1);










1824



ALTER DATABASE mysqltest2 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










1825



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










1826



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










1827



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










1828



/*!50003 SET character_set_client  = utf8 */ ;










1829



/*!50003 SET character_set_results = utf8 */ ;










1830



/*!50003 SET collation_connection  = utf8_general_ci */ ;










1831



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










1832



/*!50003 SET sql_mode              = '' */ ;










1833



DELIMITER ;;










1834



/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW










1835



BEGIN










1836



DECLARE переЌ1 CHAR(10);










1837



INSERT INTO log VALUES(COLLATION(переЌ1));










1838



INSERT INTO log VALUES(COLLATION('текст'));










1839



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1840



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1841



INSERT INTO log VALUES(@@collation_connection);










1842



INSERT INTO log VALUES(@@character_set_client);










1843



SET @a1 = 'текст';










1844



SET @a2 = _utf8 'текст';










1845



SET @a3 = _koi8r    'ÔÅËÓÔ';










1846



END */;;










1847



DELIMITER ;










1848



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










1849



/*!50003 SET character_set_client  = @saved_cs_client */ ;










1850



/*!50003 SET character_set_results = @saved_cs_results */ ;










1851



/*!50003 SET collation_connection  = @saved_col_connection */ ;










1852



ALTER DATABASE mysqltest2 CHARACTER SET cp866 COLLATE cp866_general_ci ;










1853



ALTER DATABASE mysqltest2 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;










1854



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;










1855



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;










1856



/*!50003 SET @saved_col_connection = @@collation_connection */ ;










1857



/*!50003 SET character_set_client  = utf8 */ ;










1858



/*!50003 SET character_set_results = utf8 */ ;










1859



/*!50003 SET collation_connection  = utf8_general_ci */ ;










1860



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;










1861



/*!50003 SET sql_mode              = '' */ ;










1862



DELIMITER ;;










1863



/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW










1864



BEGIN










1865



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1866



INSERT INTO log VALUES(COLLATION(переЌ1));










1867



INSERT INTO log VALUES(COLLATION('текст'));










1868



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1869



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1870



INSERT INTO log VALUES(@@collation_connection);










1871



INSERT INTO log VALUES(@@character_set_client);










1872



SET @b1 = 'текст';










1873



SET @b2 = _utf8 'текст';










1874



SET @b3 = _koi8r    'ÔÅËÓÔ';










1875



END */;;










1876



DELIMITER ;










1877



/*!50003 SET sql_mode              = @saved_sql_mode */ ;










1878



/*!50003 SET character_set_client  = @saved_cs_client */ ;










1879



/*!50003 SET character_set_results = @saved_cs_results */ ;










1880



/*!50003 SET collation_connection  = @saved_col_connection */ ;










1881



ALTER DATABASE mysqltest2 CHARACTER SET cp866 COLLATE cp866_general_ci ;










1882












1883



---> Dumping mysqltest2 to ddl_i18n_utf8triggers.mysqltest2.sql










1884












1885












1886



DROP DATABASE mysqltest1|










1887



DROP DATABASE mysqltest2|










1888












1889












1890



---> Restoring mysqltest1...










1891



---> Restoring mysqltest2...










1892



ALTER TABLE mysqltest1.t1 ADD COLUMN fake INT|










1893



ALTER TABLE mysqltest1.t1 DROP COLUMN fake|










1894



ALTER TABLE mysqltest2.t1 ADD COLUMN fake INT|










1895



ALTER TABLE mysqltest2.t1 DROP COLUMN fake|










1896












1897



---> connection: con3










1898



SET @@character_set_client= cp1251|










1899



SET @@character_set_results= cp1251|










1900



SET @@collation_connection= cp1251_general_ci|










1901



INSERT INTO mysqltest1.t1 VALUES(0)|










1902



INSERT INTO mysqltest2.t1 VALUES(0)|










1903



DELETE FROM mysqltest1.log|










1904



DELETE FROM mysqltest2.log|










1905



set names utf8|










1906



use mysqltest1|










1907












1908












1909



SHOW CREATE TRIGGER trg1|










1910



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1911



trg1		CREATE DEFINER=`root`@`localhost` TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW










1912



BEGIN










1913



DECLARE переЌ1 CHAR(10);










1914



INSERT INTO log VALUES(COLLATION(переЌ1));










1915



INSERT INTO log VALUES(COLLATION('текст'));










1916



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1917



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1918



INSERT INTO log VALUES(@@collation_connection);










1919



INSERT INTO log VALUES(@@character_set_client);










1920



SET @a1 = 'текст';










1921



SET @a2 = _utf8 'текст';










1922



SET @a3 = _koi8r    'ÔÅËÓÔ';










1923



END	utf8	utf8_general_ci	utf8_unicode_ci










1924












1925



SHOW CREATE TRIGGER trg2|










1926



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1927



trg2		CREATE DEFINER=`root`@`localhost` TRIGGER trg2 AFTER INSERT ON t1 FOR EACH ROW










1928



BEGIN










1929



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1930



INSERT INTO log VALUES(COLLATION(переЌ1));










1931



INSERT INTO log VALUES(COLLATION('текст'));










1932



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1933



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1934



INSERT INTO log VALUES(@@collation_connection);










1935



INSERT INTO log VALUES(@@character_set_client);










1936



SET @b1 = 'текст';










1937



SET @b2 = _utf8 'текст';










1938



SET @b3 = _koi8r    'ÔÅËÓÔ';










1939



END	utf8	utf8_general_ci	utf8_unicode_ci










1940












1941



SHOW CREATE TRIGGER mysqltest2.trg3|










1942



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1943



trg3		CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg3 BEFORE INSERT ON mysqltest2.t1 FOR EACH ROW










1944



BEGIN










1945



DECLARE переЌ1 CHAR(10);










1946



INSERT INTO log VALUES(COLLATION(переЌ1));










1947



INSERT INTO log VALUES(COLLATION('текст'));










1948



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1949



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1950



INSERT INTO log VALUES(@@collation_connection);










1951



INSERT INTO log VALUES(@@character_set_client);










1952



SET @a1 = 'текст';










1953



SET @a2 = _utf8 'текст';










1954



SET @a3 = _koi8r    'ÔÅËÓÔ';










1955



END	utf8	utf8_general_ci	utf8_unicode_ci










1956












1957



SHOW CREATE TRIGGER mysqltest2.trg4|










1958



Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation










1959



trg4		CREATE DEFINER=`root`@`localhost` TRIGGER mysqltest2.trg4 AFTER INSERT ON mysqltest2.t1 FOR EACH ROW










1960



BEGIN










1961



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1962



INSERT INTO log VALUES(COLLATION(переЌ1));










1963



INSERT INTO log VALUES(COLLATION('текст'));










1964



INSERT INTO log VALUES(COLLATION(_utf8 'текст'));










1965



INSERT INTO log VALUES(COLLATION(_koi8r    'ÔÅËÓÔ'));










1966



INSERT INTO log VALUES(@@collation_connection);










1967



INSERT INTO log VALUES(@@character_set_client);










1968



SET @b1 = 'текст';










1969



SET @b2 = _utf8 'текст';










1970



SET @b3 = _koi8r    'ÔÅËÓÔ';










1971



END	utf8	utf8_general_ci	utf8_unicode_ci










1972












1973












1974



SHOW TRIGGERS|










1975



Trigger	Event	Table	Statement	Timing	Created	sql_mode	Definer	character_set_client	collation_connection	Database Collation










1976



trg1	INSERT	t1	BEGIN










1977



DECLARE переЌ1 CHAR(10);










1978



INSERT INTO log VALUES(COLLATION(переЌ1));










1979



INSERT INTO log VALUES(COLLATION('текст'));










1980



INSERT INTO log VALUES(COLLATION( 'текст'));










1981



INSERT INTO log VALUES(COLLATION(    'текст'));










1982



INSERT INTO log VALUES(@@collation_connection);










1983



INSERT INTO log VALUES(@@character_set_client);










1984



SET @a1 = 'текст';










1985



SET @a2 =  'текст';










1986



SET @a3 =     'текст';










1987



END	BEFORE	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










1988



trg2	INSERT	t1	BEGIN










1989



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










1990



INSERT INTO log VALUES(COLLATION(переЌ1));










1991



INSERT INTO log VALUES(COLLATION('текст'));










1992



INSERT INTO log VALUES(COLLATION( 'текст'));










1993



INSERT INTO log VALUES(COLLATION(    'текст'));










1994



INSERT INTO log VALUES(@@collation_connection);










1995



INSERT INTO log VALUES(@@character_set_client);










1996



SET @b1 = 'текст';










1997



SET @b2 =  'текст';










1998



SET @b3 =     'текст';










1999



END	AFTER	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2000












2001



use mysqltest2|










2002












2003



SHOW TRIGGERS|










2004



Trigger	Event	Table	Statement	Timing	Created	sql_mode	Definer	character_set_client	collation_connection	Database Collation










2005



trg3	INSERT	t1	BEGIN










2006



DECLARE переЌ1 CHAR(10);










2007



INSERT INTO log VALUES(COLLATION(переЌ1));










2008



INSERT INTO log VALUES(COLLATION('текст'));










2009



INSERT INTO log VALUES(COLLATION( 'текст'));










2010



INSERT INTO log VALUES(COLLATION(    'текст'));










2011



INSERT INTO log VALUES(@@collation_connection);










2012



INSERT INTO log VALUES(@@character_set_client);










2013



SET @a1 = 'текст';










2014



SET @a2 =  'текст';










2015



SET @a3 =     'текст';










2016



END	BEFORE	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2017



trg4	INSERT	t1	BEGIN










2018



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2019



INSERT INTO log VALUES(COLLATION(переЌ1));










2020



INSERT INTO log VALUES(COLLATION('текст'));










2021



INSERT INTO log VALUES(COLLATION( 'текст'));










2022



INSERT INTO log VALUES(COLLATION(    'текст'));










2023



INSERT INTO log VALUES(@@collation_connection);










2024



INSERT INTO log VALUES(@@character_set_client);










2025



SET @b1 = 'текст';










2026



SET @b2 =  'текст';










2027



SET @b3 =     'текст';










2028



END	AFTER	NULL		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2029



use mysqltest1|










2030












2031












2032



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'|










2033



TRIGGER_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










2034



NULL	mysqltest1	trg1	INSERT	NULL	mysqltest1	t1	0	NULL	BEGIN










2035



DECLARE переЌ1 CHAR(10);










2036



INSERT INTO log VALUES(COLLATION(переЌ1));










2037



INSERT INTO log VALUES(COLLATION('текст'));










2038



INSERT INTO log VALUES(COLLATION( 'текст'));










2039



INSERT INTO log VALUES(COLLATION(    'текст'));










2040



INSERT INTO log VALUES(@@collation_connection);










2041



INSERT INTO log VALUES(@@character_set_client);










2042



SET @a1 = 'текст';










2043



SET @a2 =  'текст';










2044



SET @a3 =     'текст';










2045



END	ROW	BEFORE	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2046












2047



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'|










2048



TRIGGER_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










2049



NULL	mysqltest1	trg2	INSERT	NULL	mysqltest1	t1	0	NULL	BEGIN










2050



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2051



INSERT INTO log VALUES(COLLATION(переЌ1));










2052



INSERT INTO log VALUES(COLLATION('текст'));










2053



INSERT INTO log VALUES(COLLATION( 'текст'));










2054



INSERT INTO log VALUES(COLLATION(    'текст'));










2055



INSERT INTO log VALUES(@@collation_connection);










2056



INSERT INTO log VALUES(@@character_set_client);










2057



SET @b1 = 'текст';










2058



SET @b2 =  'текст';










2059



SET @b3 =     'текст';










2060



END	ROW	AFTER	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2061












2062



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'|










2063



TRIGGER_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










2064



NULL	mysqltest2	trg3	INSERT	NULL	mysqltest2	t1	0	NULL	BEGIN










2065



DECLARE переЌ1 CHAR(10);










2066



INSERT INTO log VALUES(COLLATION(переЌ1));










2067



INSERT INTO log VALUES(COLLATION('текст'));










2068



INSERT INTO log VALUES(COLLATION( 'текст'));










2069



INSERT INTO log VALUES(COLLATION(    'текст'));










2070



INSERT INTO log VALUES(@@collation_connection);










2071



INSERT INTO log VALUES(@@character_set_client);










2072



SET @a1 = 'текст';










2073



SET @a2 =  'текст';










2074



SET @a3 =     'текст';










2075



END	ROW	BEFORE	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2076












2077



SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'|










2078



TRIGGER_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










2079



NULL	mysqltest2	trg4	INSERT	NULL	mysqltest2	t1	0	NULL	BEGIN










2080



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2081



INSERT INTO log VALUES(COLLATION(переЌ1));










2082



INSERT INTO log VALUES(COLLATION('текст'));










2083



INSERT INTO log VALUES(COLLATION( 'текст'));










2084



INSERT INTO log VALUES(COLLATION(    'текст'));










2085



INSERT INTO log VALUES(@@collation_connection);










2086



INSERT INTO log VALUES(@@character_set_client);










2087



SET @b1 = 'текст';










2088



SET @b2 =  'текст';










2089



SET @b3 =     'текст';










2090



END	ROW	AFTER	NULL	NULL	OLD	NEW	CREATED		root@localhost	utf8	utf8_general_ci	utf8_unicode_ci










2091












2092












2093



SET @a1 = '1'|










2094



SET @a2 = '1'|










2095



SET @a3 = '1'|










2096



SET @b1 = '2'|










2097



SET @b2 = '2'|










2098



SET @b3 = '2'|










2099












2100












2101



INSERT INTO t1 VALUES(1)|










2102












2103



---> Log:










2104



SELECT msg FROM log|










2105



msg










2106



utf8_unicode_ci










2107



utf8_general_ci










2108



utf8_general_ci










2109



koi8r_general_ci










2110



utf8_general_ci










2111



utf8










2112



utf8_general_ci










2113



utf8_general_ci










2114



utf8_general_ci










2115



koi8r_general_ci










2116



utf8_general_ci










2117



utf8










2118












2119



SELECT










2120



COLLATION(@a1) AS ca1,










2121



COLLATION(@a2) AS ca2,










2122



COLLATION(@a3) AS ca3,










2123



COLLATION(@b1) AS cb1,










2124



COLLATION(@b2) AS cb2,










2125



COLLATION(@b3) AS cb3|










2126



ca1	ca2	ca3	cb1	cb2	cb3










2127



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8_general_ci	koi8r_general_ci










2128












2129



DELETE FROM log|










2130












2131












2132



INSERT INTO mysqltest2.t1 VALUES(1)|










2133












2134



---> Log:










2135



SELECT msg FROM mysqltest2.log|










2136



msg










2137



utf8_unicode_ci










2138



utf8_general_ci










2139



utf8_general_ci










2140



koi8r_general_ci










2141



utf8_general_ci










2142



utf8










2143



utf8_general_ci










2144



utf8_general_ci










2145



utf8_general_ci










2146



koi8r_general_ci










2147



utf8_general_ci










2148



utf8










2149












2150



SELECT










2151



COLLATION(@a1) AS ca1,










2152



COLLATION(@a2) AS ca2,










2153



COLLATION(@a3) AS ca3,










2154



COLLATION(@b1) AS cb1,










2155



COLLATION(@b2) AS cb2,










2156



COLLATION(@b3) AS cb3|










2157



ca1	ca2	ca3	cb1	cb2	cb3










2158



utf8_general_ci	utf8_general_ci	koi8r_general_ci	utf8_general_ci	utf8_general_ci	koi8r_general_ci










2159












2160



DELETE FROM mysqltest2.log|










2161












2162



---> connection: default










2163



use test|










2164



DROP DATABASE mysqltest1|










2165



DROP DATABASE mysqltest2|










2166












2167



-------------------------------------------------------------------










2168



Events










2169



-------------------------------------------------------------------










2170












2171



DROP DATABASE IF EXISTS mysqltest1|










2172



DROP DATABASE IF EXISTS mysqltest2|










2173



CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










2174



CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










2175



use mysqltest1|










2176












2177



CREATE EVENT ev1 ON SCHEDULE AT '2030-01-01 00:00:00' DO










2178



BEGIN










2179



DECLARE переЌ1 CHAR(10);










2180



SELECT










2181



COLLATION(переЌ1) AS c1,










2182



COLLATION('текст') AS c2,










2183



COLLATION(_utf8 'текст') AS c3,










2184



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2185



@@collation_connection AS c5,










2186



@@character_set_client AS c6;










2187



END|










2188












2189



CREATE EVENT ev2 ON SCHEDULE AT '2030-01-01 00:00:00' DO










2190



BEGIN










2191



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2192



SELECT










2193



COLLATION(переЌ1) AS c1,










2194



COLLATION('текст') AS c2,










2195



COLLATION(_utf8 'текст') AS c3,










2196



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2197



@@collation_connection AS c5,










2198



@@character_set_client AS c6;










2199



END|










2200












2201



CREATE EVENT mysqltest2.ev3 ON SCHEDULE AT '2030-01-01 00:00:00' DO










2202



BEGIN










2203



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2204



SELECT










2205



COLLATION(переЌ1) AS c1,










2206



COLLATION('текст') AS c2,










2207



COLLATION(_utf8 'текст') AS c3,










2208



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2209



@@collation_connection AS c5,










2210



@@character_set_client AS c6;










2211



END|










2212












2213



CREATE EVENT mysqltest2.ev4 ON SCHEDULE AT '2030-01-01 00:00:00' DO










2214



BEGIN










2215



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2216



SELECT










2217



COLLATION(переЌ1) AS c1,










2218



COLLATION('текст') AS c2,










2219



COLLATION(_utf8 'текст') AS c3,










2220



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2221



@@collation_connection AS c5,










2222



@@character_set_client AS c6;










2223



END|










2224












2225












2226












2227



SHOW CREATE EVENT ev1|










2228



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2229



ev1		SYSTEM	CREATE EVENT `ev1` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2230



DECLARE переЌ1 CHAR(10);










2231



SELECT










2232



COLLATION(переЌ1) AS c1,










2233



COLLATION('текст') AS c2,










2234



COLLATION(_utf8 'текст') AS c3,










2235



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2236



@@collation_connection AS c5,










2237



@@character_set_client AS c6;










2238



END	utf8	utf8_general_ci	utf8_unicode_ci










2239












2240



SHOW CREATE EVENT ev2|










2241



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2242



ev2		SYSTEM	CREATE EVENT `ev2` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2243



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2244



SELECT










2245



COLLATION(переЌ1) AS c1,










2246



COLLATION('текст') AS c2,










2247



COLLATION(_utf8 'текст') AS c3,










2248



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2249



@@collation_connection AS c5,










2250



@@character_set_client AS c6;










2251



END	utf8	utf8_general_ci	utf8_unicode_ci










2252












2253



SHOW CREATE EVENT mysqltest2.ev3|










2254



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2255



ev3		SYSTEM	CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2256



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2257



SELECT










2258



COLLATION(переЌ1) AS c1,










2259



COLLATION('текст') AS c2,










2260



COLLATION(_utf8 'текст') AS c3,










2261



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2262



@@collation_connection AS c5,










2263



@@character_set_client AS c6;










2264



END	utf8	utf8_general_ci	utf8_unicode_ci










2265












2266



SHOW CREATE EVENT mysqltest2.ev3|










2267



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2268



ev3		SYSTEM	CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2269



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2270



SELECT










2271



COLLATION(переЌ1) AS c1,










2272



COLLATION('текст') AS c2,










2273



COLLATION(_utf8 'текст') AS c3,










2274



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2275



@@collation_connection AS c5,










2276



@@character_set_client AS c6;










2277



END	utf8	utf8_general_ci	utf8_unicode_ci










2278












2279












2280



SHOW EVENTS LIKE 'ev1'|










2281



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2282



mysqltest1	ev1	root@localhost	SYSTEM	ONE TIME	2030-01-01 00:00:00	NULL	NULL	NULL	NULL	ENABLED	1	utf8	utf8_general_ci	utf8_unicode_ci










2283












2284



SHOW EVENTS LIKE 'ev2'|










2285



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2286



mysqltest1	ev2	root@localhost	SYSTEM	ONE TIME	2030-01-01 00:00:00	NULL	NULL	NULL	NULL	ENABLED	1	utf8	utf8_general_ci	utf8_unicode_ci










2287












2288



SHOW EVENTS LIKE 'ev3'|










2289



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2290












2291



SHOW EVENTS LIKE 'ev4'|










2292



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2293












2294












2295



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'|










2296



EVENT_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










2297



NULL	mysqltest1	ev1	root@localhost	SYSTEM	SQL	BEGIN










2298



DECLARE переЌ1 CHAR(10);










2299



SELECT










2300



COLLATION(переЌ1) AS c1,










2301



COLLATION('текст') AS c2,










2302



COLLATION( 'текст') AS c3,










2303



COLLATION(    'текст') AS c4,










2304



@@collation_connection AS c5,










2305



@@character_set_client AS c6;










2306



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2307












2308



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'|










2309



EVENT_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










2310



NULL	mysqltest1	ev2	root@localhost	SYSTEM	SQL	BEGIN










2311



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2312



SELECT










2313



COLLATION(переЌ1) AS c1,










2314



COLLATION('текст') AS c2,










2315



COLLATION( 'текст') AS c3,










2316



COLLATION(    'текст') AS c4,










2317



@@collation_connection AS c5,










2318



@@character_set_client AS c6;










2319



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2320












2321



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'|










2322



EVENT_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










2323



NULL	mysqltest2	ev3	root@localhost	SYSTEM	SQL	BEGIN










2324



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2325



SELECT










2326



COLLATION(переЌ1) AS c1,










2327



COLLATION('текст') AS c2,










2328



COLLATION( 'текст') AS c3,










2329



COLLATION(    'текст') AS c4,










2330



@@collation_connection AS c5,










2331



@@character_set_client AS c6;










2332



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2333












2334



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'|










2335



EVENT_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










2336



NULL	mysqltest2	ev4	root@localhost	SYSTEM	SQL	BEGIN










2337



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2338



SELECT










2339



COLLATION(переЌ1) AS c1,










2340



COLLATION('текст') AS c2,










2341



COLLATION( 'текст') AS c3,










2342



COLLATION(    'текст') AS c4,










2343



@@collation_connection AS c5,










2344



@@character_set_client AS c6;










2345



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2346












2347












2348



ALTER DATABASE mysqltest1 COLLATE cp866_general_ci|










2349



ALTER DATABASE mysqltest2 COLLATE cp866_general_ci|










2350












2351



---> connection: con2










2352



SET @@character_set_client= cp1251|










2353



SET @@character_set_results= cp1251|










2354



SET @@collation_connection= cp1251_general_ci|










2355



SHOW CREATE EVENT ev1|










2356



SHOW CREATE EVENT ev2|










2357



SHOW CREATE EVENT mysqltest2.ev3|










2358



SHOW CREATE EVENT mysqltest2.ev4|










2359



set names utf8|










2360












2361












2362



SHOW CREATE EVENT ev1|










2363



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2364



ev1		SYSTEM	CREATE EVENT `ev1` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2365



DECLARE переЌ1 CHAR(10);










2366



SELECT










2367



COLLATION(переЌ1) AS c1,










2368



COLLATION('текст') AS c2,










2369



COLLATION(_utf8 'текст') AS c3,










2370



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2371



@@collation_connection AS c5,










2372



@@character_set_client AS c6;










2373



END	utf8	utf8_general_ci	utf8_unicode_ci










2374












2375



SHOW CREATE EVENT ev2|










2376



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2377



ev2		SYSTEM	CREATE EVENT `ev2` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2378



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2379



SELECT










2380



COLLATION(переЌ1) AS c1,










2381



COLLATION('текст') AS c2,










2382



COLLATION(_utf8 'текст') AS c3,










2383



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2384



@@collation_connection AS c5,










2385



@@character_set_client AS c6;










2386



END	utf8	utf8_general_ci	utf8_unicode_ci










2387












2388



SHOW CREATE EVENT mysqltest2.ev3|










2389



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2390



ev3		SYSTEM	CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2391



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2392



SELECT










2393



COLLATION(переЌ1) AS c1,










2394



COLLATION('текст') AS c2,










2395



COLLATION(_utf8 'текст') AS c3,










2396



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2397



@@collation_connection AS c5,










2398



@@character_set_client AS c6;










2399



END	utf8	utf8_general_ci	utf8_unicode_ci










2400












2401



SHOW CREATE EVENT mysqltest2.ev3|










2402



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2403



ev3		SYSTEM	CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2404



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2405



SELECT










2406



COLLATION(переЌ1) AS c1,










2407



COLLATION('текст') AS c2,










2408



COLLATION(_utf8 'текст') AS c3,










2409



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2410



@@collation_connection AS c5,










2411



@@character_set_client AS c6;










2412



END	utf8	utf8_general_ci	utf8_unicode_ci










2413












2414












2415



SHOW EVENTS LIKE 'ev1'|










2416



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2417



mysqltest1	ev1	root@localhost	SYSTEM	ONE TIME	2030-01-01 00:00:00	NULL	NULL	NULL	NULL	ENABLED	1	utf8	utf8_general_ci	utf8_unicode_ci










2418












2419



SHOW EVENTS LIKE 'ev2'|










2420



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2421



mysqltest1	ev2	root@localhost	SYSTEM	ONE TIME	2030-01-01 00:00:00	NULL	NULL	NULL	NULL	ENABLED	1	utf8	utf8_general_ci	utf8_unicode_ci










2422












2423



SHOW EVENTS LIKE 'ev3'|










2424



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2425












2426



SHOW EVENTS LIKE 'ev4'|










2427



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2428












2429












2430



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'|










2431



EVENT_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










2432



NULL	mysqltest1	ev1	root@localhost	SYSTEM	SQL	BEGIN










2433



DECLARE переЌ1 CHAR(10);










2434



SELECT










2435



COLLATION(переЌ1) AS c1,










2436



COLLATION('текст') AS c2,










2437



COLLATION( 'текст') AS c3,










2438



COLLATION(    'текст') AS c4,










2439



@@collation_connection AS c5,










2440



@@character_set_client AS c6;










2441



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2442












2443



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'|










2444



EVENT_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










2445



NULL	mysqltest1	ev2	root@localhost	SYSTEM	SQL	BEGIN










2446



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2447



SELECT










2448



COLLATION(переЌ1) AS c1,










2449



COLLATION('текст') AS c2,










2450



COLLATION( 'текст') AS c3,










2451



COLLATION(    'текст') AS c4,










2452



@@collation_connection AS c5,










2453



@@character_set_client AS c6;










2454



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2455












2456



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'|










2457



EVENT_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










2458



NULL	mysqltest2	ev3	root@localhost	SYSTEM	SQL	BEGIN










2459



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2460



SELECT










2461



COLLATION(переЌ1) AS c1,










2462



COLLATION('текст') AS c2,










2463



COLLATION( 'текст') AS c3,










2464



COLLATION(    'текст') AS c4,










2465



@@collation_connection AS c5,










2466



@@character_set_client AS c6;










2467



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2468












2469



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'|










2470



EVENT_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










2471



NULL	mysqltest2	ev4	root@localhost	SYSTEM	SQL	BEGIN










2472



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2473



SELECT










2474



COLLATION(переЌ1) AS c1,










2475



COLLATION('текст') AS c2,










2476



COLLATION( 'текст') AS c3,










2477



COLLATION(    'текст') AS c4,










2478



@@collation_connection AS c5,










2479



@@character_set_client AS c6;










2480



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2481












2482



---> Dump of mysqltest1










2483












2484



CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp866 */;










2485












2486



USE `mysqltest1`;










2487



/*!50106 SET @save_time_zone= @@TIME_ZONE */ ;










2488



DELIMITER ;;










2489



ALTER DATABASE mysqltest1 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;;










2490



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;










2491



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;










2492



/*!50003 SET @saved_col_connection = @@collation_connection */ ;;










2493



/*!50003 SET character_set_client  = utf8 */ ;;










2494



/*!50003 SET character_set_results = utf8 */ ;;










2495



/*!50003 SET collation_connection  = utf8_general_ci */ ;;










2496



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;










2497



/*!50003 SET sql_mode              = '' */ ;;










2498



/*!50003 SET @saved_time_zone      = @@time_zone */ ;;










2499



/*!50003 SET time_zone             = 'SYSTEM' */ ;;










2500



/*!50106 CREATE EVENT `ev1` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2501



DECLARE переЌ1 CHAR(10);










2502



SELECT










2503



COLLATION(переЌ1) AS c1,










2504



COLLATION('текст') AS c2,










2505



COLLATION(_utf8 'текст') AS c3,










2506



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2507



@@collation_connection AS c5,










2508



@@character_set_client AS c6;










2509



END */ ;;










2510



/*!50003 SET time_zone             = @saved_time_zone */ ;;










2511



/*!50003 SET sql_mode              = @saved_sql_mode */ ;;










2512



/*!50003 SET character_set_client  = @saved_cs_client */ ;;










2513



/*!50003 SET character_set_results = @saved_cs_results */ ;;










2514



/*!50003 SET collation_connection  = @saved_col_connection */ ;;










2515



ALTER DATABASE mysqltest1 CHARACTER SET cp866 COLLATE cp866_general_ci ;;










2516



DELIMITER ;;










2517



ALTER DATABASE mysqltest1 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;;










2518



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;










2519



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;










2520



/*!50003 SET @saved_col_connection = @@collation_connection */ ;;










2521



/*!50003 SET character_set_client  = utf8 */ ;;










2522



/*!50003 SET character_set_results = utf8 */ ;;










2523



/*!50003 SET collation_connection  = utf8_general_ci */ ;;










2524



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;










2525



/*!50003 SET sql_mode              = '' */ ;;










2526



/*!50003 SET @saved_time_zone      = @@time_zone */ ;;










2527



/*!50003 SET time_zone             = 'SYSTEM' */ ;;










2528



/*!50106 CREATE EVENT `ev2` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2529



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2530



SELECT










2531



COLLATION(переЌ1) AS c1,










2532



COLLATION('текст') AS c2,










2533



COLLATION(_utf8 'текст') AS c3,










2534



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2535



@@collation_connection AS c5,










2536



@@character_set_client AS c6;










2537



END */ ;;










2538



/*!50003 SET time_zone             = @saved_time_zone */ ;;










2539



/*!50003 SET sql_mode              = @saved_sql_mode */ ;;










2540



/*!50003 SET character_set_client  = @saved_cs_client */ ;;










2541



/*!50003 SET character_set_results = @saved_cs_results */ ;;










2542



/*!50003 SET collation_connection  = @saved_col_connection */ ;;










2543



ALTER DATABASE mysqltest1 CHARACTER SET cp866 COLLATE cp866_general_ci ;;










2544



DELIMITER ;










2545



/*!50106 SET TIME_ZONE= @save_time_zone */ ;










2546












2547



---> Dumping mysqltest1 to ddl_i18n_utf8events.mysqltest1.sql










2548












2549



---> Dump of mysqltest2










2550












2551



CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqltest2` /*!40100 DEFAULT CHARACTER SET cp866 */;










2552












2553



USE `mysqltest2`;










2554



/*!50106 SET @save_time_zone= @@TIME_ZONE */ ;










2555



DELIMITER ;;










2556



ALTER DATABASE mysqltest2 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;;










2557



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;










2558



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;










2559



/*!50003 SET @saved_col_connection = @@collation_connection */ ;;










2560



/*!50003 SET character_set_client  = utf8 */ ;;










2561



/*!50003 SET character_set_results = utf8 */ ;;










2562



/*!50003 SET collation_connection  = utf8_general_ci */ ;;










2563



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;










2564



/*!50003 SET sql_mode              = '' */ ;;










2565



/*!50003 SET @saved_time_zone      = @@time_zone */ ;;










2566



/*!50003 SET time_zone             = 'SYSTEM' */ ;;










2567



/*!50106 CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2568



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2569



SELECT










2570



COLLATION(переЌ1) AS c1,










2571



COLLATION('текст') AS c2,










2572



COLLATION(_utf8 'текст') AS c3,










2573



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2574



@@collation_connection AS c5,










2575



@@character_set_client AS c6;










2576



END */ ;;










2577



/*!50003 SET time_zone             = @saved_time_zone */ ;;










2578



/*!50003 SET sql_mode              = @saved_sql_mode */ ;;










2579



/*!50003 SET character_set_client  = @saved_cs_client */ ;;










2580



/*!50003 SET character_set_results = @saved_cs_results */ ;;










2581



/*!50003 SET collation_connection  = @saved_col_connection */ ;;










2582



ALTER DATABASE mysqltest2 CHARACTER SET cp866 COLLATE cp866_general_ci ;;










2583



DELIMITER ;;










2584



ALTER DATABASE mysqltest2 CHARACTER SET utf8 COLLATE utf8_unicode_ci ;;










2585



/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;










2586



/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;










2587



/*!50003 SET @saved_col_connection = @@collation_connection */ ;;










2588



/*!50003 SET character_set_client  = utf8 */ ;;










2589



/*!50003 SET character_set_results = utf8 */ ;;










2590



/*!50003 SET collation_connection  = utf8_general_ci */ ;;










2591



/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;










2592



/*!50003 SET sql_mode              = '' */ ;;










2593



/*!50003 SET @saved_time_zone      = @@time_zone */ ;;










2594



/*!50003 SET time_zone             = 'SYSTEM' */ ;;










2595



/*!50106 CREATE EVENT `ev4` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2596



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2597



SELECT










2598



COLLATION(переЌ1) AS c1,










2599



COLLATION('текст') AS c2,










2600



COLLATION(_utf8 'текст') AS c3,










2601



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2602



@@collation_connection AS c5,










2603



@@character_set_client AS c6;










2604



END */ ;;










2605



/*!50003 SET time_zone             = @saved_time_zone */ ;;










2606



/*!50003 SET sql_mode              = @saved_sql_mode */ ;;










2607



/*!50003 SET character_set_client  = @saved_cs_client */ ;;










2608



/*!50003 SET character_set_results = @saved_cs_results */ ;;










2609



/*!50003 SET collation_connection  = @saved_col_connection */ ;;










2610



ALTER DATABASE mysqltest2 CHARACTER SET cp866 COLLATE cp866_general_ci ;;










2611



DELIMITER ;










2612



/*!50106 SET TIME_ZONE= @save_time_zone */ ;










2613












2614



---> Dumping mysqltest2 to ddl_i18n_utf8events.mysqltest2.sql










2615












2616












2617



DROP DATABASE mysqltest1|










2618



DROP DATABASE mysqltest2|










2619












2620












2621



---> Restoring mysqltest1...










2622



---> Restoring mysqltest2...










2623












2624



---> connection: con3










2625



SET @@character_set_client= cp1251|










2626



SET @@character_set_results= cp1251|










2627



SET @@collation_connection= cp1251_general_ci|










2628



SHOW CREATE EVENT ev1|










2629



SHOW CREATE EVENT ev2|










2630



SHOW CREATE EVENT mysqltest2.ev3|










2631



SHOW CREATE EVENT mysqltest2.ev4|










2632



set names utf8|










2633












2634












2635



SHOW CREATE EVENT ev1|










2636



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2637



ev1		SYSTEM	CREATE EVENT `ev1` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2638



DECLARE переЌ1 CHAR(10);










2639



SELECT










2640



COLLATION(переЌ1) AS c1,










2641



COLLATION('текст') AS c2,










2642



COLLATION(_utf8 'текст') AS c3,










2643



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2644



@@collation_connection AS c5,










2645



@@character_set_client AS c6;










2646



END	utf8	utf8_general_ci	utf8_unicode_ci










2647












2648



SHOW CREATE EVENT ev2|










2649



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2650



ev2		SYSTEM	CREATE EVENT `ev2` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2651



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2652



SELECT










2653



COLLATION(переЌ1) AS c1,










2654



COLLATION('текст') AS c2,










2655



COLLATION(_utf8 'текст') AS c3,










2656



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2657



@@collation_connection AS c5,










2658



@@character_set_client AS c6;










2659



END	utf8	utf8_general_ci	utf8_unicode_ci










2660












2661



SHOW CREATE EVENT mysqltest2.ev3|










2662



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2663



ev3		SYSTEM	CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2664



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2665



SELECT










2666



COLLATION(переЌ1) AS c1,










2667



COLLATION('текст') AS c2,










2668



COLLATION(_utf8 'текст') AS c3,










2669



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2670



@@collation_connection AS c5,










2671



@@character_set_client AS c6;










2672



END	utf8	utf8_general_ci	utf8_unicode_ci










2673












2674



SHOW CREATE EVENT mysqltest2.ev3|










2675



Event	sql_mode	time_zone	Create Event	character_set_client	collation_connection	Database Collation










2676



ev3		SYSTEM	CREATE EVENT `ev3` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN










2677



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2678



SELECT










2679



COLLATION(переЌ1) AS c1,










2680



COLLATION('текст') AS c2,










2681



COLLATION(_utf8 'текст') AS c3,










2682



COLLATION(_koi8r    'ÔÅËÓÔ') AS c4,










2683



@@collation_connection AS c5,










2684



@@character_set_client AS c6;










2685



END	utf8	utf8_general_ci	utf8_unicode_ci










2686












2687












2688



SHOW EVENTS LIKE 'ev1'|










2689



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2690



mysqltest1	ev1	root@localhost	SYSTEM	ONE TIME	2030-01-01 00:00:00	NULL	NULL	NULL	NULL	ENABLED	1	utf8	utf8_general_ci	utf8_unicode_ci










2691












2692



SHOW EVENTS LIKE 'ev2'|










2693



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2694



mysqltest1	ev2	root@localhost	SYSTEM	ONE TIME	2030-01-01 00:00:00	NULL	NULL	NULL	NULL	ENABLED	1	utf8	utf8_general_ci	utf8_unicode_ci










2695












2696



SHOW EVENTS LIKE 'ev3'|










2697



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2698












2699



SHOW EVENTS LIKE 'ev4'|










2700



Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation










2701












2702












2703



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev1'|










2704



EVENT_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










2705



NULL	mysqltest1	ev1	root@localhost	SYSTEM	SQL	BEGIN










2706



DECLARE переЌ1 CHAR(10);










2707



SELECT










2708



COLLATION(переЌ1) AS c1,










2709



COLLATION('текст') AS c2,










2710



COLLATION( 'текст') AS c3,










2711



COLLATION(    'текст') AS c4,










2712



@@collation_connection AS c5,










2713



@@character_set_client AS c6;










2714



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2715












2716



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev2'|










2717



EVENT_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










2718



NULL	mysqltest1	ev2	root@localhost	SYSTEM	SQL	BEGIN










2719



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2720



SELECT










2721



COLLATION(переЌ1) AS c1,










2722



COLLATION('текст') AS c2,










2723



COLLATION( 'текст') AS c3,










2724



COLLATION(    'текст') AS c4,










2725



@@collation_connection AS c5,










2726



@@character_set_client AS c6;










2727



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2728












2729



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev3'|










2730



EVENT_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










2731



NULL	mysqltest2	ev3	root@localhost	SYSTEM	SQL	BEGIN










2732



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2733



SELECT










2734



COLLATION(переЌ1) AS c1,










2735



COLLATION('текст') AS c2,










2736



COLLATION( 'текст') AS c3,










2737



COLLATION(    'текст') AS c4,










2738



@@collation_connection AS c5,










2739



@@character_set_client AS c6;










2740



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2741












2742



SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE event_name = 'ev4'|










2743



EVENT_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










2744



NULL	mysqltest2	ev4	root@localhost	SYSTEM	SQL	BEGIN










2745



DECLARE переЌ1 CHAR(10) CHARACTER SET utf8;










2746



SELECT










2747



COLLATION(переЌ1) AS c1,










2748



COLLATION('текст') AS c2,










2749



COLLATION( 'текст') AS c3,










2750



COLLATION(    'текст') AS c4,










2751



@@collation_connection AS c5,










2752



@@character_set_client AS c6;










2753



END	ONE TIME	2030-01-01 00:00:00	NULL	NULL		NULL	NULL	ENABLED	NOT PRESERVE	CREATED	LAST_ALTERED	NULL		1	utf8	utf8_general_ci	utf8_unicode_ci










2754












2755



-------------------------------------------------------------------










2756



DDL statements within stored routine.










2757



-------------------------------------------------------------------










2758












2759



DROP DATABASE IF EXISTS mysqltest1|










2760



DROP DATABASE IF EXISTS mysqltest2|










2761



CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










2762



CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci|










2763



use mysqltest1|










2764












2765



CREATE PROCEDURE p1()










2766



BEGIN










2767



CREATE TABLE t1(col1 VARCHAR(10));










2768



SHOW CREATE TABLE t1;










2769



END|










2770












2771



CREATE PROCEDURE mysqltest2.p2()










2772



BEGIN










2773



CREATE TABLE t2(col1 VARCHAR(10));










2774



SHOW CREATE TABLE t2;










2775



END|










2776












2777



CALL p1()|










2778



Table	Create Table










2779



t1	CREATE TABLE `t1` (










2780



  `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL










2781



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci










2782












2783



SHOW CREATE TABLE t1|










2784



Table	Create Table










2785



t1	CREATE TABLE `t1` (










2786



  `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL










2787



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci










2788












2789












2790



CALL mysqltest2.p2()|










2791



Table	Create Table










2792



t2	CREATE TABLE `t2` (










2793



  `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL










2794



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci










2795












2796



SHOW CREATE TABLE mysqltest2.t2|










2797



Table	Create Table










2798



t2	CREATE TABLE `t2` (










2799



  `col1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL










2800



) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci










2801












2802



ALTER DATABASE mysqltest1 COLLATE cp1251_general_cs|










2803



ALTER DATABASE mysqltest2 COLLATE cp1251_general_cs|










2804



DROP TABLE t1|










2805



DROP TABLE mysqltest2.t2|










2806












2807



CALL p1()|










2808



Table	Create Table










2809



t1	CREATE TABLE `t1` (










2810



  `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL










2811



) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs










2812












2813



SHOW CREATE TABLE t1|










2814



Table	Create Table










2815



t1	CREATE TABLE `t1` (










2816



  `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL










2817



) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs










2818












2819












2820



CALL mysqltest2.p2()|










2821



Table	Create Table










2822



t2	CREATE TABLE `t2` (










2823



  `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL










2824



) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs










2825












2826



SHOW CREATE TABLE mysqltest2.t2|










2827



Table	Create Table










2828



t2	CREATE TABLE `t2` (










2829



  `col1` varchar(10) COLLATE cp1251_general_cs DEFAULT NULL










2830



) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs










2831












2832



---> connection: default










2833



use test|










2834



DROP DATABASE mysqltest1|










2835



DROP DATABASE mysqltest2|