Αρχικό μήνυμα από  Andreas Jung <[EMAIL PROTECTED]>:

> 
> 
> --On 13. Oktober 2005 13:20:07 +0300 "Thomas G. Apostolou" 
> <[EMAIL PROTECTED]> 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
Θωμάς Γ. Αποστόλου
Μηχανικός Λογισμικού
_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to