ATTENTION SQL BLOGGERS,
I’ve been blogging using the wordpress platform for about three months now and every now and then I’ve come across a certain quirkiness that I’ve finally gotten to the bottom of. I want to warn you about it and maybe save some head-scratching.
Articles with a particular string cannot be saved. When I try to use this particular string, the web server times out. At least in my environment and after checking with Brent Ozar, it’s not isolated to just me.
Here’s the string, I’m pasting it as an image for somewhat obvious reasons:
What’s really odd is that
- VARCHAR ( works (note the space).
- varchar( works.
- CHAR( works.
- and ARCHAR( works.
If this is a security “feature” it seems like a crummy one. Crummy because it hinders valid work (by us honest sql bloggers) and crummy times two because It’s not particularly effective at guarding against some perceived risk. Especially when the work-around of VARCHAR space bracket works just fine.
It seems like a known issue though: http://core.trac.wordpress.org/ticket/11486
Your mileage may vary. But try it out. See if you can save a draft of a blog post using the forbidden string. Leave a comment back here if you had trouble like I do.