X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=mysql%2Fmysql_change_charset.sql;h=c2c27680fe96607953da9b96317ed985d68ecb70;hb=702bf4a6d8597a268f6a7953a9d236a57387f7bd;hp=008ebf552e426bb11fa3b0baf286928590b7303d;hpb=4be02c7167901a7530cf7137c4d026d97bedced4;p=Pman.Core

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
index 008ebf55..c2c27680 100644
--- 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