What is the VARCHAR2 datatype?

May I please have a description of the VARCHAR2 datatype? This datatype is used in our catalogue database and I cannot find an explanation that will provide a clear understanding.

Published: 15 Nov 2005

May I please have a description of the VARCHAR2 datatype? This datatype is used in our catalogue database and I cannot find an explanation that will provide a clear understanding.

The VARCHAR2 datatype is used to hold character data, including numbers. This datatype is "variable" in the sense that it will not allocate space for unused characters. For instance, if you define your column as VARCHAR2(30), it can hold up to 30 characters. If you are using a single-byte character set, those 30 characters can require 30 bytes of storage space. If you store a five-letter word in that column, the VARCHAR2 datatype does not require all 30 bytes to be allocated. Rather, it only needs the space to store that five-letter word, or five bytes in a single-byte character set.

A complete description of all datatypes can be found in the Oracle documentation.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Dig Deeper on Oracle database design and architecture

PL/SQL datatypes in Oracle Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more in this PL/SQL tutorial for beginners and experts.

Access bfile image with SQL prompt Can I access an image that is stored through the bfile datatype with the SQL prompt?

Limit on CLOB datatype in Oracle 10g In Oracle 10g, does the 32K limit on the CLOB datatype still apply?

Finding size of files in BLOB datatype I have a table named DOCUMENT with a BLOB datatype for storing files. I want a query to find the size of each file stored in that BLOB object.

ORA-00932 using length function An article on this Web site said the length function could tell me the length of a long datatype column. However, in SQL*Plus I received the following error: "ORA-00932: inconsistent datatypes: expected NUMBER got LONG."

Correct use of CLOB datatype I have a database design where CLOB datatypes are being used in place of VARCHAR2 datatypes. The VARCHAR2 datatypes are not large. I believe this was done was to use ConText indexes for Web page searches. I need some ammunition regarding the use or incorrect use of CLOBs.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Please create a username to comment.

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.