I<3 blog's with # & $ % @ ! >
test post with mysql escape-worthy chars in
' " \ _ and % are characters that
mysql will expect escaped as \' \" \\ \_ and \% or at least that its what I did from memory.
test post with various xml escapes in
xml generally will escape < angle brackets > & "quotes" but these need to be unescaped before sending to
mysql as the "quotes" & < angle brackets > will otherwise cause confusion. A futher complciation is that in general we store ampersands and angle brackets escaped in the db, but not quotes.
Likewise we need to apply mysql escaping to the query string we send to update the DB.
Test post with " in it
There have been "some problems" where quote marks occur near a
link in the text.
The trailing aftertext has been prone to unexpected truncation in some part of the processing chain.
In particular, we have seen this when after the
link you have a "quoted phrase", and then a rather long run-on quotation in context that will overflow the 256 character aftertext linkcontext field that is where we keep the aftertext.
Annoying, huh?
