Correction:
This requires a one query for each field in each table to be changed.
This requires one query for each table to be changed - all fields in the table
that need the collation will be changed.
SVN 6767 has brought some changes to the MySQL db structure. The default
collation is now utf8_general_ci.
For those coming in from prior to SVN 6765, the following SQL statements need
to be executed:
ALTER TABLE `care_test_param` DROP PRIMARY KEY, ADD PRIMARY KEY (`nr`);
ALTER TABLE `care_test_param` ADD UNIQUE `id` (`id`);
ALTER TABLE `care_test_param` ADD KEY `group_id` (`group_id`);
ALTER DATABASE `care2x` CHARACTER SET utf8 COLLATE utf8_general_ci;
All fields that have collation set for character fields need to be changed.
This requires a one query for each field in each table to be changed.
These queries can be generated by an SQL statement like:-
SELECT CONCAT('ALTER TABLE `',TABLE_SCHEMA,'`.`',TABLE_NAME,'` CONVERT TO
CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'care2x' AND ENGINE='INNODB';
Please note that the above SQL statement will only generate the queries. We
then need to execute them individually or thru an SQL file. Alter DBNAME care2x
in the statements above to suit your installation.
Let us make this a regular feature: When anyone commits to the SQL file, make
the SQL statements on this list that will bring other installs upto date.
The table care_test_param has the nr=313 and nr = 314 missing. This is for
info only - the total number of rows in the default install will be 335 but the
last nr will be 337. This kept me bufuddled for a moment.
Regards,
Ap.Muthu
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
