Ananda Kumar schrieb: > Before you import at the mysql prompt set below variables and then try > again to load > > set session max_error_count=500000; > set session collation_database=latin1_swedish_ci; > set session character_set_database=latin1; This is not what I need, because I use utf8 as well as in the database as in the input file and I do not have any latin1 at all. When I choose latin1 here, indeed, I don't receive an error message, but my data becomes corrupted.
When, however, I choose "utf8" and "utf8_general_ci" as "session character_set_database" and "session collation_database", I still get the same error message. :( Best regards, H. -- "Wouldn't the sentence 'I want to put a hyphen between the words Fish and And and And and Chips in my Fish-And-Chips sign' have been clearer if quotation marks had been placed before Fish, and between Fish and and, and and and And, and And and and, and and and And, and And and and, and and and Chips, as well as after Chips?" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]