Re[2]: Same syntax on MySQL and Microsoft SQL Server

Hi Jan, >>>We encountered that MySQL (or MyODBC) uses different >>>quoting characters for legal names and strings. >>BSJ> Well, let's put it this way : tables names between >>BSJ> square brackets only exists in Microsoft! >>That might be right, but this is how Microsoft works. JS> I'm sorry, but

Re: Same syntax on MySQL and Microsoft SQL Server

>>We encountered that MySQL (or MyODBC) uses different >>quoting characters for legal names and strings. At present we >>are using square brackets for names (like [my table], [my column] or >>[my table].[my column]) and inverted commas for strings >>(like mytxt = 'text'). >> >>Is there an option fo

Same syntax on MySQL and Microsoft SQL Server

A few months ago I tried to use MySQL as an alternative database backend for our software product. Currently we are using MS Access and MS SQL Server. We encountered that MySQL (or MyODBC) uses different quoting characters for legal names and strings. At present we are using square brackets for na