what to do with special characters like "é","ë",...

[lievemario]

hey,

I've wrote a perl script which gets data out of a mysql database and convert
it to xml.
It works with the XML::Handler::YAWriter,
here is the code;

use strict;
use DBI;
use XML::Generator:BI;
use XML::Handler::YAWriter;
my $dbh = DBI->connect ("DBI:mysql:myDB", "myUID", "myPassword",
{ RaiseError => 1, PrintError => 0});
my $out = XML::Handler::YAWriter->new (AsFile => "test.xml");
my $gen = XML::Generator:BI->new ( Handler => $out, dbh => $dbh );
$gen->execute ("SELECT *

FROM someTable");
$dbh->disconnect ();

I do not get any errors when executing the script,
but when I try to open the test.xml file, it has an error
in it:
<name>th?/name>
this should be:
<name>thé</name>

Has anyone an idea how I can solve this?

thx!

 

[Jürgen Exner]

lievemario wrote:
[...]

I do not get any errors when executing the script,
but when I try to open the test.xml file, it has an error
in it:
<name>th?/name>
this should be:
<name>thé</name>

Has anyone an idea how I can solve this?

Just use the proper encoding/character set/code page (terminology varies),
either in your database or in the generated XML file or in the XML header or
in the settings for whatever program you are using to "open" the XML file.
Actually change those "or" to "and". Although you could convert the charset
from and to it is much easier to stick to the same throughout.

jue