Actually I don't know what's causing the corruption but the "." looks like the only unvalid one in a varchar field. since after the insert the table just stopped working (not responding to SELECT or DELETE) while the rest of the tables works fine
so I'm looking for something like html markupsafe library On Tuesday, January 1, 2013 6:19:03 PM UTC+2, werner wrote: > > On 31/12/2012 23:24, alonn wrote: > > I'm using sqlalchemy orm (with turbogears) to write data from a web > > application to an mssql 2005 Db (used by another application, not > > maintained by me). > > after dealing with a serious case of data corruption (basically > > because of user data including the "." sign). > Can you give more detail on how a "." (point/full stop) in user data > corrupted your database. > > A point is valid data in lots of situations, so should not cause you > problems. > > Werner > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/7EszJDnNSfwJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
