Special characters #,$ etc

[Mark Denham]

Does anyone know if these characters are supposed to be allowed under SQL92
naming conventions for table and colnames?

Just wondering since it seems to be possible to use them in other products.

Mark

sending to informix-list

[Jonathan Leffler]

Mark Denham wrote:

> Does anyone know if these characters are supposed to be allowed under SQL92
> naming conventions for table and colnames?
>
> Just wondering since it seems to be possible to use them in other products.

No. You can't even start identifiers with an underscore in SQL92.

You can use them if the identifiers are delimited - set DELIMIDENT in
the environment and the column or table names in double quotes (and
don't try to cheat using double quotes for strings).

On second thoughts, don't set DELIMIDENT.


--
Jonathan Leffler #include <disclaimer.h>
Email: [email]jleffler@earthlink.net[/email], [email]jleffler@us.ibm.com[/email]
Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]