example:
In [1]: db = DAL('informix://oli:x...@suse101/stammdat')
In [2]: db.define_table("personen",
...: Field("name", length=80),
...: Field("anz", "integer"),
...: primarykey=["name"],
...: migrate=False
...: )
In [3]: a = db().select(db.personen.name)[0].name
In [4]: print a
Öläf
In [5]: db(db.personen.name == a)._update(anz=2)
Out[5]: "UPDATE personen SET anz=2 WHERE personen.name='\xc3\x96l
\xc3\xa4f';"
In [6]: print db(db.personen.name == a).update(anz=2)
0
shows that 0 rows were updated although 1 row should have been
updated.
I think the cause of this problem is that the values in our database
are not utf-8 but iso-8859-1encoded and web2py explicitly encodes
values to uft-8 in funtion 'sql_represent' (gluon/sql.py) when
creating sql-statemens for updates and inserts.
How to talk to iso-8859-1 encoded legacy DBs?
Regards,
Hans
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
