{"id":14,"date":"2009-12-06T21:50:11","date_gmt":"2009-12-07T02:50:11","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=14"},"modified":"2011-09-26T21:52:26","modified_gmt":"2011-09-27T02:52:26","slug":"sql-language-elements-characters","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2009\/12\/sql-language-elements-characters\/","title":{"rendered":"SQL Language elements (characters)"},"content":{"rendered":"

characters<\/strong>, the basic symbols of keywords and operators in SQL language are the single-byte characters that are part of all IBM character sets.<\/p>\n

charaters of language are classified as letters, digits or special characters.<\/strong><\/p>\n

A letter<\/em> is any of the 26 uppercase (A through Z) or 26 lowercase (a through z) letters, plus the three characters $, #, and @, which are included for compability with host database products.<\/p>\n

A digit <\/em>is any of the charaters 0 through 9.<\/p>\n

A special character<\/em> is any of characters listed below:<\/p>\n

\n

\n
\n
\nCharacter<\/td>\n | Description<\/td>\n | Character<\/td>\n | Description<\/td>\n<\/tr>\n
\n<\/td>\n | space or blank<\/td>\n | –<\/td>\n | minus sign<\/td>\n<\/tr>\n
\n“<\/td>\n | quotation mark\/double quote\/double quotation mark<\/td>\n | .<\/td>\n | period<\/td>\n<\/tr>\n
\n%<\/td>\n | percent<\/td>\n | \/<\/td>\n | slash<\/td>\n<\/tr>\n
\n&<\/td>\n | ampersand<\/td>\n | :<\/td>\n | colon<\/td>\n<\/tr>\n
\n‘<\/td>\n | apostrophe\/single quote\/singe quotation mark<\/td>\n | ;<\/td>\n | semicolon<\/td>\n<\/tr>\n
\n(<\/td>\n | left parenthesis<\/td>\n | <<\/td>\n | less than<\/td>\n<\/tr>\n
\n)<\/td>\n | right parenthesis<\/td>\n | =<\/td>\n | equals<\/td>\n<\/tr>\n
\n*<\/td>\n | asterisk<\/td>\n | ><\/td>\n | greater than<\/td>\n<\/tr>\n
\n+<\/td>\n | plus sign<\/td>\n | ?<\/td>\n | question mark<\/td>\n<\/tr>\n
\n,<\/td>\n | comma<\/td>\n | _<\/td>\n | underline\/underscore<\/td>\n<\/tr>\n
\n|<\/td>\n | vertical bar<\/td>\n | ^<\/td>\n | caret<\/td>\n<\/tr>\n
\n!<\/td>\n | exclamation mark<\/td>\n | [<\/td>\n | left bracket<\/td>\n<\/tr>\n
\n{<\/td>\n | left brace<\/td>\n | ]<\/td>\n | right bracket<\/td>\n<\/tr>\n
\n}<\/td>\n | right brace<\/td>\n | <\/td>\n | <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n All multi-byte characters are treated as letters, except for the double-byte blank, which is a special character.<\/p>\n","protected":false},"excerpt":{"rendered":" characters, the basic symbols of keywords and operators in SQL language are the single-byte characters that are part of all IBM character sets. charaters of language are classified as letters, digits or special characters. A letter is any of the 26 uppercase (A through Z) or 26 lowercase (a through z) letters, plus the three characters $, #, and @, which are included for compability with host database products. A digit is any of the charaters 0 through 9. A special character is any of characters listed below: Character Description Character Description space or blank – minus sign “ quotation\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16,25],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nSQL Language elements (characters)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n