John Nagle <nagle@animats.com> wrote:
> Axel Schwenke wrote:
>> Maybe this was changed recently
> Yes, the manual page changed since yesterday. Compare
>
> http://web.archive.org/web/200604281...load-data.html
>
>> but the manual page you reference says:
>>
>> "Beginning with MySQL 5.0.38, if the contents of the input file use
>> a character set that differs from the default, it is possible (and
>> usually preferable) to use the CHARACTER SET clause to specify the
>> character set of the file."
>>
>> So your MySQL is too old for that feature.
>
> "Too old?" 5.0.38 isn't even released yet. 5.0.37 is the latest download.

Hehe. You're experiencing the time lag between updating the
documentation repository and releasing a new version.
To get this feature, you have to checkout MySQL source code
from the public bk repository and compile yourself:

http://dev.mysql.com/doc/refman/5.0/...urce-tree.html

Sorry for the inconvenience but apparently this is a "bleeding
edge" feature...


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/