>
<christoph.huesler(a)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