Professional Web Applications Themes

Special characters #,$ etc - Informix

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...

  1. #1

    Default Special characters #,$ etc


    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
    Mark Denham Guest

  2. #2

    Default Re: Special characters #,$ etc

    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]jlefflerearthlink.net[/email], [email]jlefflerus.ibm.com[/email]
    Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

    Jonathan Leffler Guest

Similar Threads

  1. Special characters
    By phil_dude in forum Macromedia ColdFusion
    Replies: 2
    Last Post: September 10th, 02:06 PM
  2. xml and special characters
    By German Hernandez in forum Macromedia Flash Data Integration
    Replies: 4
    Last Post: May 14th, 12:02 AM
  3. Escaping special characters
    By Jamie Bohr in forum PHP Programming
    Replies: 7
    Last Post: June 29th, 03:03 PM
  4. More special characters in FH
    By maciekk in forum Macromedia Freehand
    Replies: 1
    Last Post: July 19th, 11:11 AM
  5. Special Characters - Mac vs. PC - Help
    By tracetm2 webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 2
    Last Post: August 29th, 06:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139