answersLogoWhite

0


Best Answer

Char data types are predefined in length and will always take that much bits in the database regardless of the length of the word/record store in it. Varchar2 on the other hand means variable length. The max lenght is defined, but actual bit sizes taken in the database depends on the word/record stored in the data field up to the length defined. ~ Wale

User Avatar

Wiki User

โˆ™ 2006-06-15 17:45:04
This answer is:
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between Oracle data types char and varchar2?
Write your answer...
Submit
Related questions

What is the difference between the three types of ballistics?

What is the difference between the three types of ballistics


Explain the difference between the two types of skeletal muscle tissue?

explain the difference between the two types of skeletal muscle tissue?


What is the answer to the riddle How can you tell the difference between two types of trees?

You can tell the difference between two types of trees, because they leaf clues.


What is the difference between the different types of protists?

no


What s difference between types of proficiency test?

different types of proficiency


How can you tell the difference between to types of trees?

The leaves


What is the difference between different types of milk?

Taste It!


What are the Other database types instead of oracle?

MsSqlServer


Difference between the types of matter?

Matter is made from atoms; so this question changes itself to "What is the difference between types of atoms". That difference lies primarily in the number of protons that exist in the atom's nucleus.


Different between oracle datatypes char20 and varchar20?

In Oracle, the char(20) datatype is a fixed length character string. It will always use 20 characters in the block. If the value contained in the field is less than 20 characters, it will be padded on the right (or the left, depending on coding) with spaces. In Oracle, the varchar(20) datatype is a variable length character string. It will use betwen 1 and 21 characters in the block, 1 for the length, and 0-20 for the data. Its effective length can range between 0 and 20 characters. Note, however, that a string of length 0 is indistinguishable from a null value. This is a deviation from the SQL standard that Oracle acknowledges, but fixing it would break too much existing code. Note also that comparing a char against a varchar is problematic. With the trailiing spaces, the char is not the same as a varchar containing the same characters. Predicates involving these mixed types should use the rtrim expression on the char datatype. (Example: while rtrim(mycharvalue) = myvarcharvalue) Note also that varchar is obsolete. Current code should use varchar2, such as varchar2(20).


Difference between different types of operating system?

fgfghgh


What is the difference between the two types of weathering?

they are opposite in their spelling


What is the difference between the different types of emulsifying agents?

lecithin


Difference between types of displacement addressing modes?

wewe


What is the difference between the three types of Pacific Islands?

Hey


What determines the difference between types of electromagnetic radiation?

The wavelength


What is one difference between the two types of reproduction?

hth


What are the different types of resumes and what is the difference between them?

alot of work


What is difference between 3 types of language?

Your mom hahahahahahaha


What is the difference between forms and types of energy?

enegry unstill


In English Difference between various and different?

There's no signifigant difference between the two, each is used in certain contexts. "There are dozens of different dog types", versus, "there are various dog types."


What are different types of search engines?

Identify 5 types of search engines and explain the difference between


What is the difference between a tragedy in itself and a tragedy of itself?

what is the tragedy and what is types of tragedy what is the tragedy and what is types of tragedy


What is the difference between a mushroom and a toadstool?

There is no difference; both refer to reproductive structures of certain types of fungi.


Difference between the various types of fiber optic cables?

Nothing