Hi !You can also addcharacter-set-server=utf8to your my.cnfor change the content of /usr/local/mysql/support-files/mysql.serverto something like thiscase "$mode" in 'start') # Start daemon if test -x $bindir/mysqld_safe then # Give extra arguments to mysqld with the my.cnf file. This
You should insert into the beginning of your dump file the statement pointing its encoding:SET NAMES utf8; Regards,Gennady Kushnir On 19.08.2006, at 16:05, Gino Pacitti wrote:Hi allI have a database with 5 different languages used for products in different tables.I did a mysql dump and loaded that
Hi,
I guess this is more a subject for mysql mailing lists, since
completely WO unrelated :-)
And I'm not sure cross-posting is allowed on different mailing lists
at once
Anyways, did you take a look at MySql documentations ? I'm pretty
sure there are a couple of keywords when defining d
Hi all
I have a database with 5 different languages used for products in
different tables.
I did a mysql dump and loaded that into a new database on new machine
- all the foreign charaters are weird now...
how can I get a correct set of characters?
Gino
_
