mysql/mysql_change_charset.sql

[Pman.Core] / mysql / mysql_change_charset.sql

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
index 008ebf5..c2c2768 100644 (file)
--- a/mysql/mysql_change_charset.sql
+++ b/mysql/mysql_change_charset.sql
@@ -1,50 +1,5 @@
 
 
 DROP PROCEDURE IF EXISTS mysql_change_charset;
-
-delimiter $$
-
-
-CREATE PROCEDURE mysql_change_charset(mytb TEXT)
-    BEGIN
-    DECLARE mydb TEXT;
-    
-    SELECT database() INTO mydb;
-    
-    SELECT
-        IF(
-            csname='utf8' AND collatename='utf8_unicode_ci',
-            CONCAT('SELECT ''',mytb,' is Already utf8'' as \"No Need to Convert\"'),
-            CONCAT('ALTER TABLE ',mytb,' CONVERT TO CHARACTER SET  utf8 COLLATE utf8_unicode_ci')
-            
-        )
-    INTO
-        @ConvertEngineSQL
-        
-    FROM (
-        SELECT
-            CCSA.character_set_name csname,
-            CCSA.collation_name collatename
-            FROM
-                information_schema.`TABLES` T,
-                information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
-            WHERE
-                CCSA.collation_name = T.table_collation
-                AND
-                T.table_schema = mydb COLLATE utf8_unicode_ci
-                AND
-                T.table_name = mytb COLLATE utf8_unicode_ci
-
-    
-    ) AA;
-            
-    -- SELECT ConvertEngineSQL; -- ???
-    PREPARE st FROM @ConvertEngineSQL;
-    EXECUTE st;
-    DEALLOCATE PREPARE st;
-
-END;
-
-$$
-
-DELIMITER ;
\ No newline at end of file
+ 
+ -- this code has been moved to PHP as we force it on all tables now..
\ No newline at end of file