[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: [Patch] A little patch for kexi
From:       Adam Pigg <adam () piggz ! fsnet ! co ! uk>
Date:       2003-07-25 17:54:47
[Download RAW message or body]

Yeah, i think " is probably standard ansi for objects, mysql must also support 
`.  ' is definitely for strings, so the patch just fixes it so that it will 
work however the driver impementors wish it to work, it basically allows me 
to get my driver working :o).  I suppose it would be possible to hard code it 
to " as per ansi standard, but maybe its best left to the driver to choose so 
that if other rdbms are added in the future that dont allow " they will also 
work.

Cheers

Adam
On Friday 25 July 2003 10:05 am, Malte Starostik wrote:
> On Wednesday 23 July 2003 21:47, Adam Pigg wrote:
> > Hi
> >
> > seeing as you kexi developers are living in mysql land i thought better
> > let you have this patch.
> >
> > It may be incomplete, but ive searched the sources for lines that need
> > changed so it shouldnt be too bad, and it wont affect anything for you
> > anyway, but it will halp me in postgresql land :o)
> >
> > What it does:
> > Adds a virtual function to kexidb.h - escapeName - this returns a quoted
> > version of a table name, currently it is hardcoded to a ` character, but
> > postgresql uses a " and thus all queries fail.
>
> I haven't used mysql nor postgresql for some time, so this is rather
> theoretical. Isn't " the standard quote character for delimited names per
> ANSI  SQL? " is for object names, ' for string literals AFAIR (yes I do
> know that many RDBMS don't care too much about ANSI). Still, wouldn't mysql
> understand " just as well?
>
> Cheers,
> -Malte

-- 
adampigg.9p.org.uk
adam@piggz.fsnet.co.uk
adam@adampigg.9p.org.uk

_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]