>>> <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