christoph.huesler@css.ch 17/10/2006 15:59 >>>
Hi Ricardo,
You are probably running mysql with a default encoding of utf-8. Try changing it to latin1. The reason for this error is, that mysql cannot store indexes longer than 1000 bytes. When using latin1, everything is fine. But with utf-8, each character needs 3 bytes, which exceeds that limit. hth
-- chris
Hi Chris,
I got the point and did some tests here. Default encoding as reported by Navicat Connection Information window says 65001 (UTF-8) both in source and target databases. phpMyAdmin also both running on source and target servers reports the not same info:
Target:
MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: utf8_unicode_ci
Source:
MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: latin1_bin
In spite of the errors while exporting/importing, Navicat for Mac OS X did the trick. It throws the same error from time to time, but it normally ends the direct data transfer without a glitch. I am not able to understand why, but the work is done now.
Any input that helps to clarify this behaviour will be welcome! Thanks.
All the best,
Ricardo
-- Ricardo Rodríguez Your XEN ICT Team
mediawiki-l@lists.wikimedia.org