This is what I thought. that the problem is with the application and not the sql server. unfortunately I try to access the table directly (either through sqlalchemy or directly from mssql management GUI) and both fail. the table just doesn't respond to SELECT, DELETE, TRUNCATE etc
On Tuesday, January 1, 2013 11:14:27 PM UTC+2, Tomas Vondra wrote: > > On 1.1.2013 21:57, Werner wrote: > > On 01/01/2013 19:34, alonn wrote: > >> Actually I don't know what's causing the corruption but the "." looks > >> like the only unvalid one in a varchar field. > > Why would a "." in a varchar field not be valid? Just consider > > something like "Firstname MidInitial. LastName", why would that not be > > valid in a varchar column? > > > > I am pretty sure that the "." is not your problem. > > > > Provide more details and hopefully someone can help you identify your > > real problem. > > My bet is that when OP talks about "data corruption", he actually does > not mean that the database crashed and the data files are somehow damaged. > > I believe the issue is that the application assummes that the varchar > column does not contain some characters (e.g. a dot) yet the users > managed to get around the application-level checks and inserted such > values into the database. So the data are invalid from the application > point of view, but the database is perfectly healthy. > > But that's something the OP needs to explain. > > Tomas > -- 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/-/k5CgVbKH5nkJ. 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.
