RE: [SQLObject] Reserved Words

[Ian S. <Ian...@et...>]

> Does SQL-Object check for reserved words prior to the creation of a =20
> table? Not only those in the SQL standards, but those specific to a =20
> database. If so, this list should include words from all supported =20
> databases and cross check these.

We talked in the past about reserved words for databases. It was felt =
that it would be better to use fieldname quoting. For instance you can't =
have fieldname called SELECT in Firebird but you can have one called =
'select'.

The problem with quoting is that it makes your fieldnames case =
sensitive..

But I don't know whether there was ever a concensus to actually =
implement the quoting scheme (maybe not all DB's support it? I know that =
Firebird, Postgresql and Oracle? do).


> -----Original Message-----
> From: Brian Ray [mailto:br...@se...]
> Sent: Monday, September 13, 2004 1:31 PM
> To: sql object
> Subject: [SQLObject] Reserved Words
>=20
>=20
> Does SQL-Object check for reserved words prior to the creation of a =20
> table? Not only those in the SQL standards, but those specific to a =20
> database. If so, this list should include words from all supported =20
> databases and cross check these.
>=20
> For example, I used the word 'leading' in my SQLite database. When =20
> switching the connection to MySQL, I got an error. The error was not =20
> all that helpful. However I see on the MySQL site that=20
> 'leading' is a =20
> reserved word.
>=20
> Not a big deal, but thought I would let you know.
>=20
> Thanks, Brian
>=20
> SQLite keywords: http://www.sqlite.org/lang.html
> MySQL: http://dev.mysql.com/doc/mysql/en/Reserved_words.html
> Postgres: http://www.postgresql.org/docs/7/interactive/syntax.htm
> firebird:http://www.ibexpert.info/firebird/documentation/=20
> Firebird%20Release%20Notes%20v1.5/New%20Reserved%20Words/18057.html
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your=20
> judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.=20
> Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>=20