On Wed, Jun 15, 2011 at 8:34 AM, Treeve Jelbert <tre...@scarlet.be> wrote: > I have been converting some code which was written to access a database from > python. > > The origin code was for postgresql/sqlite but Firebird objects to some names > of the type '_xyz'. Apparently the leading underscore has special meaning in > Python. > > After changing the affected names, every seems to work with Firebird-2.5 > > What does the SQL standard say about such names?
Here's what the 2008 standard has to say... The first character of an unquoted identifier is an <identifier start>. Subsequent characters are <identifier extend>. "An <identifier start> is any character in the Unicode General Category classes “Lu”, “Ll”, “Lt”, “Lm”, “Lo”, or “Nl”. NOTE 77 — The Unicode General Category classes “Lu”, “Ll”, “Lt”, “Lm”, “Lo”, and “Nl” are assigned to Unicode characters that are, respectively, upper-case letters, lower-case letters, title-case letters, modifier letters, other letters, and letter numbers. 2) An <identifier extend> is U+00B7, “Middle Dot”, or any character in the Unicode General Category classes “Mn”, “Mc”, “Nd”, “Pc”, or “Cf”. NOTE 78 — The Unicode General Category classes “Mn”, “Mc”, “Nd”, “Pc”, and “Cf” are assigned to Unicode characters that are, respectively, nonspacing marks, spacing combining marks, decimal numbers, connector punctuations, and formatting codes." (Page 148 of the Foundation document) > > Should I complain to the writers of the original code? > You might, but I doubt they'll be happy to hear from you. Good luck, Ann ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel