> >>> print customerName
> ImmobiliŠre (whatever)
> >>> customerName
> 'Immobili\x8are (whatever)'
>
> There should be a small E with a grave accent (è) instead of the capital S
> with a caron (Š) I'm getting.
>
> I've tried applying various encodings, but to no avail:
>
> When executed from
Perfect! Thanks Evert.
I realise now that I don't fully grasp the concepts of encoding and
collation and their relationship.
--
Emmanuel
On Wed, Oct 6, 2010 at 10:38 PM, Evert Rol wrote:
>
>
> > >>> print customerName
> > ImmobiliŠre (whatever)
> > >>> customerName
> > 'Immobili\x8are (whate
Hi tutors,
I'm trying to fetch data from an MS SQL Server database with pymssql, but
non-ascii results get garbled.
>>> import pymssql
>>> conn = pymssql.connect(user='sa', password=myPassword, host=server,
database=targetDatabase, as_dict=True)
>>> curs = conn.cursor()
>>> curs.execute("select C
