I am inserting parsed text from a utf-8 xml file into a mysql
database.
there is a little problem, where i have to clarify.
In my xml file i have entries like this.
<style">高中语文教学目标与检测(下编)</style><<style>ä¸å¦è¯æ–‡</style>
when i parse the data only the second entry is correctly inserted.
I use the myDatabase.executesql() command.
insert into refs_test(title,abbrev_series_title) values ("8bed
\u6587,Zxyw", "\xe4\xb8\xad\xe5\xad\xa6\xe8\xaf\xad\xe6\)
i tried to encode all the strings using encode.(utf-8) then every
entry was in (\xe4\xb8\xad\x)
but in the database i see the same.
if i print the sql command in the console i have the correct string
and it works when i copy and paste it.
can somebody give me a tipp?
thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
