Re: restoring from sqldump with accented characters

2007-07-13 Thread Ananda Kumar
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

restoring from sqldump with accented characters

2007-07-13 Thread Peter Teunissen
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 apo