Re: [Informa-developer] exporting informa Database / partially OT

[Niko S. <nik...@us...>]

On Monday 07 February 2005 10:28, Marco Mistroni wrote:
> Hello all,
> 	I need to export informa database because I want to change
> version of mysql db (from 4.0 to the latest)
>
> I am currently using DbUnit to export data in XML file, that then
> will be imported again using DbUnit.
>
> The problem with informa db is that there are some fields in the
> channels table which contains 'weird' characters, such as the
> column 'site' ..
>
> Anyone have any idea on how to export informa db?

Hmm, this could be related to using the wrong character encoding, 
have you tried setting those options when generating the mysql 
dump. At least when creating a JDBC connection it should be 
possible to enable unicode characters by:

jdbc:mysql://localhost/informa?useUnicode=true&characterEncoding=utf-8

Or did you encounter another solution to this problem? Please let us 
know if you found out about more details.

Thanks,
Niko