Professional Web Applications Themes

SQL 92 - case sensitive - MySQL

Hi, I would like to know if the use of " " in the tables creation in SQL or in the fields definition, is a specification of SQL 92 ? Where can I find the SQL 92 specifications? Thanks for your help....

  1. #1

    Default SQL 92 - case sensitive

    Hi,


    I would like to know if the use of " " in the tables creation in SQL or in
    the fields definition, is a specification of SQL 92 ?

    Where can I find the SQL 92 specifications?

    Thanks for your help.


    rabaaoui abdelhak Guest

  2. #2

    Default Re: SQL 92 - case sensitive

    "rabaaoui abdelhak" <testtest.fr> wrote in message
    news:du17st$su5$1news.tiscali.fr...
    > I would like to know if the use of " " in the tables creation in SQL or in
    > the fields definition, is a specification of SQL 92 ?
    Yes it is. It's a language feature called "delimited identifiers". This
    also allows us to use SQL reserved words as identifiers, and also to include
    special characters (e.g. punctuation symbols), international characters, and
    even whitespace as part of an identifier.

    By default, MySQL uses backticks (`) instead of doublequotes ("), presumably
    because they already allowed double-quotes to be used as string delimiters,
    whereas SQL-92 specifies that single-quotes (') are the string delimiters.

    The identifier delimiter symbol is configurable by using the SQL-mode option
    ANSI_QUOTES.
    > Where can I find the SQL 92 specifications?
    It's not available for free (I've always thought this is surprising and
    disappointing).

    You can purchase the standard from ISO or ANSI. You may also be able to
    find free copies of drafts of the standard.

    See [url]http://en.wikipedia.org/wiki/SQL_programming_language#Scope[/url] for links.

    I learned the SQL-92 standard from a book called "Understanding the New SQL:
    A Complete Guide" by Jim Melton & Alan R. Simon.
    [url]http://www.amazon.com/gp/product/1558602453/[/url]

    I recently bought "SQL-99 Complete, Really" by Peter Gulutzan & Trudy
    Pelzer.
    [url]http://www.amazon.com/gp/product/0879305681/[/url]
    This one seems to have limited availability or something; Amazon.com doesn't
    stock it, but links to third-party sellers.

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. #23026 [Com]: Make Zend case-sensitive (classes, functions, remove case-insensitive)
    By nvivo at mandic dot com dot br in forum PHP Development
    Replies: 0
    Last Post: October 19th, 12:17 PM
  2. Case Sensitive
    By amit in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 31st, 12:32 PM
  3. Glob() is Case Sensitive
    By Krhis in forum PHP Development
    Replies: 1
    Last Post: July 26th, 04:30 AM
  4. getPos is case sensitive
    By Lingo Dude in forum Macromedia Director Lingo
    Replies: 9
    Last Post: July 17th, 05:29 PM
  5. Is varaible name case sensitive?
    By Hang in forum ASP
    Replies: 3
    Last Post: July 10th, 08:21 AM

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