|
To attempt to answer the "why it does this" question: Some databases (most databases?) use the apostrophe/single tick (') as a string separator. That means that the TEXT of your reply goes into these string separators when it is put into the database. For example: 'Hello, guys.' If one types apostrophes and they aren't "escaped" by doubling them, the string becomes corrupted and the database insert will fail. Example: 'That's mine.' In the above example, the database server looks at the string, says the "THAT" part is the string and "S MINE." has just been tacked on the end and is invalid. Most schemes handle this by pre-processing your strings and doubling the apostrophes: Example: 'That''s mine.' Two apostrophes together indicate to the database that a SINGLE apostrophe should be inserted LITTERALLY into the string. Still, other ways around the problem are to replace all single apostrophes with a double-quote -- as you have seen. I am NOT saying this is what is actually happening, just tletting you guys know what *may* be happening. Thanx,
Matt
| 
