CHAR : CHAR « PL SQL Data Types « Oracle PL/SQL Tutorial

Oracle PL/SQL Tutorial 1.  Introduction 2.  Query Select 3.  Set 4.  Insert Update Delete 5.  Sequences 6.  Table 7.  Table Joins 8.  View 9.  Index 10.  SQL Data Types 11.  Character String Functions 12.  Aggregate Functions 13.  Date Timestamp Functions 14.  Numerical Math Functions 15.  Conversion Functions 16.  Analytical Functions 17.  Miscellaneous Functions 18.  Regular Expressions Functions 19.  Statistical Functions 20.  Linear Regression Functions 21.  PL SQL Data Types 22.  PL SQL Statements 23.  PL SQL Operators 24.  PL SQL Programming 25.  Cursor 26.  Collections 27.  Function Procedure Packages 28.  Trigger 29.  SQL PLUS Session Environment 30.  System Tables Data Dictionary 31.  System Packages 32.  Object Oriented 33.  XML 34.  Large Objects 35.  Transaction 36.  User Privilege Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL / SQL PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Oracle PL/SQL Tutorial » PL SQL Data Types » CHAR   21. 2. 1. CHAR The CHAR datatype is used to hold fixed-length character string data. A CHAR string always contains the maximum number of characters. Strings shorter than the maximum length are padded with spaces. The CHAR datatype typically uses 1 byte per character. The CHAR datatype has a maximum length of 32767 bytes. The Syntax for the CHAR Datatype variable_name CHAR(size); variable_name is whatever you want to call the variable. size is the size, in bytes, of the string. Here are some examples: employee_name CHAR(32); employee_comments CHAR(10000); employee_name := 'James Gennick'; employee_name := 'Jeff Gennick'; Because CHAR variables are fixed length and the preceding strings are each less than 32 characters long, they will be right-padded with spaces. Thus the actual values in employee_name would be 'James                    ' and 'Jeff                     ' When doing string comparisons, the trailing spaces count as part of the string. Oracle has one subtype defined for the CHAR datatype, and it is called CHARACTER. It has exactly the same meaning as CHAR. 21. 2. CHAR 21. 2. 1.  CHAR 21. 2. 2.  CHAR type variable 21. 2. 3.  Compare CHAR and VARVHAR32 variables for equality 21. 2. 4.  Constants are compared using blank-padded comparison semantics, so the trailing spaces won't affect the result. 21. 2. 5.  Fixed length strings are also compared with blank-padded comparison semantic 21. 2. 6.  Comparison of a fixed length string and a literal 21. 2. 7.  Compare a variable length string against a fixed length, and the trailing spaces do matter. 21. 2. 8.  The maximum lengths of varchar2 strings do not matter, only the assigned values 21. 2. 9.  Assigning an empty string to the character variable is exactly the same as assigning NULL to it.

w___w___w_.___j__av__a2__s__.com__ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.