General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Identifying corrupted tables
From time to time, as we distribute tables across our network we are afflicted with a problem: randomly, data in character fields is lost and the individual characters are each replaced by chr(0). To identify tables with this problem we have code to scan our tables record by record, character field by character field until an occurence is found. It occurred to me that there might be a different way to code this.
Q1: Is there some low-level approach to locating occurences of chr(0) in our table fields? If so...
Q2: Would it be faster than our current approach?
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only