Convert Text to UTF-8?

Hi,

I'm sure someone has come across this before - I just can't find an answer...

I've got a list of countries in a relational DB which I am bringing
into Plone in different languages according to the language setting
(i.e. Spain for english, España for Spain).  However when it brings
the list in (via a SQL method to get the data and a DTML method to
format it in a drop-down list) all the characters with accents are not
displayed properly.

As Plone used UTF-8 encoding, I've been trying to find a way to
convert the names into UTF-8, but with no luck.  From what I can tell,
it would need to convert something like 'España' into 'Español'.

Anyone know how to convert these text strings or of a better way I
should be approaching this?

Cheers,

Duane

-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php