开发者

How to get MySql to use "[" as a quote character?

开发者 https://www.devze.com 2023-01-16 18:01 出处:网络
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.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消