FYI everybody:

I have yet to find a MySQL Schema manager (or diff-tool) that supports
field collations. This type of change is not picked up by any differ I
have managed to get up and running. If you are sure you have a tool
that does this I would be very interested in a quick reply.

Example field:
name varchar(255) character set utf8 collate utf8_swedish_ci default
NULL
changed into:
name varchar(255) character set utf8 collate utf8_bin default NULL

The reason I have used these collations was that MySQL (on out
production server running Ubuntu) did not bend to my will simply by
setting the collation on the table. My data did not read and write
correctly until I set the collation on each field. Strange, I know.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to