set this and try set session collation_database=latin1_swedish_ci; set session character_set_database=latin1;
On 7/14/07, Peter Teunissen <[EMAIL PROTECTED]> wrote:
Hi all, mysql 5.0.37 on CentOS4, default install using Mysql's rpm and using the standard mysql querybrowser and administrator on Mac OSX. I've received a sql dumpfile from a database we need to restore on our development environment. In this file there are characters with accents and apostroph like "l'état" for example. When running the file I get an sql syntax error. When I remove the accented characters the file runs fine. I've been searching through the documentation, but I didn't find a clear solution. The tables are InnoDB with the charset expicitly set to latin1 (ENGINE=InnoDB DEFAULT CHARSET=latin1) So I don't think I should need to add another charset. Still somehow the data was entered into the original database. Any hints on how I could solve this problem? Thanks, Peter Teunissen -- Never argue with idiots; they'll drag you down to their own level and beat you on experience. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
