Home >> Oracle >> Character Data Type in Oracle

Character Data Type in Oracle

The Following Character Data types are-

1)-CHAR(255 characters)-A fixed length  string between 1 and 255 characters  in length.Maximum hold 255 characters.

Example-In case Name char(60),Name is only 20 characters in length, then entry will padded with 40 characters worth of space. these spaces will be removed when the value is retrived through.

2)-VARCHAR(255 characters)-This data type is used to store variable length alphanumeric data.Maximum hold 4000 characters.

3)-TINYTEXT or TINYBLOB-A BLOB or TEXT column with a maximum length of 255 characters.you do not specify a length with TINYTEXT or TINYBLOB.

4)-TEXT or BLOB-A BLOB or TEXT column with a maximum length of 65535 characters.Binary large object(BLOB) are used to store large amounts of binary data, such as images or other types of files.TEXT field also use large amounts of data.

5)-MEDIUMTEXT or MEDIUMBLOB-A MEDIUMBLOB or MEDIUMTEXT column with a maximum length of 16777215 characters.you do not specify a length with MEDIUMTEXT or MEDIUMBLOB .

6)-LONGTEXT or LONGBLOB-A LONGBLOB or LONGTEXT column with a maximum length of 4294967295 characters.you do not specify a length with LONGTEXT or LONGBLOB .

Post Your Comment

Next Questions
DATE Data Type
Binary Data Type
Operators
Arithmetic Operators
Character Operators
Comparison Operators
Logical Operators
Set Operators
Joins
Inner Join
Outer Join
Self Join
Cross Join
Equi Join
Anti Join
Semi Join
Create database
Drop database
Create table
Drop table
Truncate table
Alter Table
Create table AS
Global Temporary tables
SELECT Query

Copyright ©2022 coderraj.com. All Rights Reserved.