#707 Add functionality to ignore characters in a query.
Not sure if this is the right category to put this in or not.
There are CMS's that like to wrap their tables in different characters to allow for code portability and prefixing tables. One that falls into this is Drupal which wraps its table names in braces (i.e. {users}). While developing code for Drupal, if you would like to check your query you can print it out to the screen, but you then need to manually remove the wrapping characters.
I would like to add functionality so you could add (in a textfield by the Delimiter field) characters that could be ignored. I've tested this locally and haven't run into issues but would like to get others to test it as well. There is also the option to set default characters in the config file by adding a line like $cfg['CharacterIgnore'] = '{}';
The field shows up next to the Delimiter text field on the sql_query form. I'm open to changing the lable for this field if anyone has suggestions.
I'm not sure if this is something what should be included, the use case here seems to be quite limited...
I agree that the use case is too limited. Thanks anyway!
I understand the use case listed might seem limited but I've found no other way to allow for ignoring characters in other applications either, though I've heard numerous people complain about having to remove characters manually.
Perhaps there is a different way that this could be implemented that would make it less limited?
"numerous people" were talking about removing characters also for Drupal?