Re: [SQLObject] troubles with unicode

[Petr J. <pet...@tp...>]

>   The error means there is at least one 8-bit str mixed with unicode.
> If you are sure all values are str instances - what about dbNames?
> _SO_update is called from set with dbNames from sqlmeta.columns:
>
>                args = [(self.sqlmeta.columns[name].dbName, value)
>                        for name, value in toUpdate.items()]
>                self._connection._SO_update(self, args)
>
>   Make sure all dbNames are also str, not unicode.
>

It looks the type of some fields is changed somewhere during the code
execution.
When the set method is called, types of all fields are  OK.
When the SQLObject calls SO_update start, some of the fields and values
types are changed (see the printout below).

Any hints?

Petr



 ============= set method start ===============
<type 'str'> telKontaktniOsoby <type 'unicode'> +420721870631
<type 'str'> kontaktniOsobaPrijmeni <type 'unicode'> Kračmar
<type 'str'> nazevKontaktMistaPoruchy <type 'unicode'> Vrátnice
<type 'str'> psc <type 'unicode'> 46117
<type 'str'> mesto <type 'unicode'> Liberec
<type 'str'> geocodeAccuracy <type 'str'> Z
<type 'str'> adresa2 <type 'unicode'>
<type 'str'> adresa1 <type 'unicode'> 17.listopadu 587/4
<type 'str'> zemDelka <type 'unicode'> 15.085940
<type 'str'> zemSirka <type 'unicode'> 50.770829
<type 'str'> elektrinaZaRokBezDph <type 'unicode'> 2052
<type 'str'> kontaktniOsobaJmeno <type 'unicode'> Zdeněk
<type 'str'> cisloSignysPartnera <type 'unicode'> 8
<type 'str'> telReseniPoruchy <type 'unicode'> +420485355214
<type 'str'> nazevProdejnihoMista <type 'unicode'> Kolej LBC B
<type 'str'> dnuRokOtevreno <type 'unicode'> 340
<type 'str'> najemZaRokBezDph <type 'unicode'> 5040

============ _SO_update start =====================
<type 'str'> tel_kontaktni_osoby <type 'str'> +420721870631
<type 'str'> kontaktni_osoba_prijmeni <type 'str'> Kračmar
<type 'unicode'> nazev_kontakt_mista_poruchy <type 'unicode'> Vrátnice
<type 'str'> psc <type 'str'> 46117
<type 'str'> mesto <type 'str'> Liberec
<type 'unicode'> geocode_accuracy <type 'str'> Z
<type 'str'> adresa2 <type 'str'>
<type 'str'> adresa1 <type 'str'> 17.listopadu 587/4
<type 'str'> zem_delka <type 'str'> 15.085940
<type 'str'> zem_sirka <type 'str'> 50.770829
<type 'unicode'> elektrina_za_rok_bez_dph <type 'unicode'> 2052
<type 'str'> kontaktni_osoba_jmeno <type 'str'> Zdeněk
<type 'unicode'> cislo_signys_partnera <type 'unicode'> 8
<type 'str'> tel_reseni_poruchy <type 'str'> +420485355214
<type 'str'> nazev_prodejniho_mista <type 'str'> Kolej LBC B
<type 'unicode'> dnu_rok_otevreno <type 'unicode'> 340
<type 'unicode'> najem_za_rok_bez_dph <type 'unicode'> 5040