[Zope] Show ISO-8859-7 Results in a site using UTF-8

[Thomas G. Apostolou]

Αρχικό μήνυμα από  Andreas Jung <lists at andreas-jung.com>:

> 
> 
> --On 13. Oktober 2005 13:20:07 +0300 "Thomas G. Apostolou" 
> <thomas.info at hol.gr> wrote:
> 
> >
> > Hello all,
> > i am using Zope 2.7.0 and i get some results from SQL Server 2000
> with a
> > python module's fanction witch i call from with in a DTML Method.
> 
> 2.7.0 is old. Upgrade!
> 
> >
> > The data is comming encoded in ISO-8859-7 (probably due to
> database
> > setup).
> > I changed the setting of the default encoding from ZMI to
> ISO-8859-7 for
> > the entiry site because of the data (temporarly) but now the same
> tings
> > has to be transfered and be part of another site using UTF-8.
> >
> 
> What is your question? How to migrate strings from iso-8859-7 to
> utf?
> 
> -aj
> 

Yep! How can I migrate strings from iso-8859-7 to utf-8?
Is there any way to get the entire return set to utf-8?

Here is my code...

def GetData(self, sysDSN="aVoiSys", usr="sa", mypass="atsql2k",
sTable="trdt", sFields="*"):
	id = self.id
	import dbi
	import odbc
	connection=odbc.odbc(sysDSN+'/'+usr+'/'+mypass)
	cur=connection.cursor()
	sSQL='Select '+sFields+' from '+sTable
	cur.execute(sSQL)
	data=cur.fetchall()
	cur.close()
	connection.close()
	return data


Is there any way to return the "data" encoded in utf-8? It is coming as
ISO-8859-7 from an SQL2K Server...






Thomas G. Apostolou
Software Engineer
Θωμάς Γ. Αποστόλου
Μηχανικός Λογισμικού