Re: Special characters #,$ etc

Posted in 2003

Jonathan Leffler — Fri, 01 Aug 2003 05:19:15 GMT — source: Usenet: comp.databases.informix

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: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/