Re: [Wikitech-l] MySQL 4.1

On Jan 14, 2005, at 9:07 PM, NSK wrote: From the RELEASE-NOTES of 1.4beta4: ''''' Thinking of using MySQL 4.1? Please read this first! ''''' ''''' Your PHP installation probably uses the OLD protocol ''''' ''''' http://dev.mysql.com/doc/mysql/en/Old_client.html ''''' Unless you know what you are doing and have properly configured PHP and MySQL 4.1 to work together, I recommend you do not try to use the not-quite-compatible MySQL 4.1, but stick with MySQL 4.0. If you have configured PHP and MySQL 4.1 to work correctly together, then there are still pitfalls due to MySQL 4.1's character set system: * The default character set for the server should be latin-1, not UTF-8. The UTF-8 mode will cause data corruption and will probably simply fail when trying to create the tables. * When backing up data with mysqldump, be sure to set the character set again to latin-1, or UTF-8 and compressed data will be IRRETRIEVABLE CORRUPTED by a silently performed data conversion. * There are probably other silent data corruption problems not yet discovered where MySQL thinks it knows more about your data than it really does and conveniently "converts" it for you. -- brion vibber (brion @ pobox.com)