Could you turn on the db driver debug and post what you see as the
insert and select?
from what people have posted here, I'm fairly certain my original
suspicion is correct:
SQLobject is sending in 100+ characters into a 100character field
(because of the utf expansion )
mysql 4.x is truncating the data to fit without raising an error.
they call that a design feature. i call it *(&#(*$ moronic.
you're seeing a decode error, because you've got half an octet or
something on the select because of the truncation
if you upgrate to mysql 5.x and add
[mysqld]
sql_mode=TRADITIONAL
to your config file, mysql will raise an error instead of truncating
data ( just like every other database )
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears
-~----------~----~----~----~------~----~------~--~---