Are table names in FireDAC case sensitive?
Are table names in FireDAC case sensitive?
I'm converting from AbsoluteDB to FireDAC and I get errors saying it cant find table "CaseSensitive" but "casesensitive" works..
When testing my query in ex. HeidiSQL it works with both "CaseSensitive" and "casesensitive".
Is there an option to set so I don't have to go through tons of queries? :)
Using XE5 Enterprise.
I'm converting from AbsoluteDB to FireDAC and I get errors saying it cant find table "CaseSensitive" but "casesensitive" works..
When testing my query in ex. HeidiSQL it works with both "CaseSensitive" and "casesensitive".
Is there an option to set so I don't have to go through tons of queries? :)
Using XE5 Enterprise.
In fact MariaDB is a fork of MySQL by the original author. Talk about a sweet deal: Cash out, leave buyer, fork original project and bring your userbase back.
ReplyDeleteKevin Powick The first link for "MySQL gotchas" (http://sql-info.de/mysql/gotchas.html) was interesting but I disagree with point 1.9 :)
ReplyDeleteThanks to all for their insight and apologies to Eirik Apeland for taking over the topic.
No worries. It was an interesting discussion.
ReplyDelete