In case the data is not in the same character set you might consider this snippet from (like following) ALTER TABLE rma CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_history CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_history CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_products CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_products CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_report_period CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_report_period CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_reservation CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_reservation CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_supplier_return CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_supplier_return CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_supplier_return_history CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_supplier_return_history CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ĪLTER TABLE rma_supplier_return_product CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE rma_supplier_return_product CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci WHERE C.collation_name = T.table_collationĪND T.table_schema = 'your_database_name'Īdjusting table columns' collation and character setĬapture upper sql output and run it. 'ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ')įROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C 'ALTER TABLE ', table_name, ' CHARACTER SET utf8 COLLATE utf8_general_ci ', Identifying Database Tables with the incorrect character set or collation SELECT CONCAT( Identifying the Collation and Character set of your database SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROMĭEFAULT_COLLATION_NAME not like 'utf8%') įixing the collation for the database ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci
ICONOMY CONVERT TO MYSQL FULL
IConomy 5 was originally made by Nijikokun and has been forked by ElgarL as well as LlmDl.Before proceeding, ensure that you: Have completed a full database backup! Permission nodes can be gotten from the plugin.yml They are already given out by default for the most part. vault-convert iconomy5.11 (replace 5.11 with the iConomy version number.) Commands:
Conversion:Ĭonvert from other economy plugins using the Vault command: If you use Towny older than 0.96.5.2 you will also need TownyNameUpdater. Town and Nation bank accounts will not reset using this economy plugin. You will find that this plugin does not use UUIDs ( it's a really old plugin) to track player/town/nation balances, for this reason you must use Towny in order for Towny to handle name changes. It has simple commands which can be aliased to anything you want using your server's commands.yml file. It uses an h2 database which installs itself with no setup required on your part. Many people have found this plugin to be very stable, lasting the test of time with less than a dozen updates being required. The original iConomy 5 plugin revamped and updated.
0 kommentar(er)
