How to get MySql to use "[" as a quote character?
I am forced to use a dumb-as-nails Windows program (called IDCentre, made by Datacard, if you have the deep misfortune to use it) that says it can deal with ODBC databases.
So, I hooked it up to my MySQL database. All is well so far.
Then I noticed that it barfs when it attempts to do an update. The SQL that MySQL deems bad contains "[" and "]" as quote characters, which, of course, is what Microsoft开发者_运维百科 SQL Server and Access both use.
I don't think there's a way in this awful program to change how it quotes SQL. Can I go the other way? Is there a way to make MySQL use "[" and "]" as quote characters?
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
LOAD DATA INFILE. Specify the field encloser.
Thanks for all the input; I genuinely appreciate it.
I didn't have control over the IDCentre program, but I did wrangle control of the particular table it's writing to, and changed the table identifiers so that quotes of any kind aren't required. I was hoping and praying that maybe IDCentre would be smart enough to realize it didn't need quotes, and so hence wouldn't send brackets. Indeed that's what happened.
精彩评论