Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

database

Started by sigs, May 02 2006 02:34 AM

This topic has been archived. This means that you cannot reply to this topic.

2 replies to this topic

#1
sigs

Posted 02 May 2006 - 02:34 AM

Learning Programmer

Members
34 posts

I want differnce between varchar() and varchar2() function in database

#2
Lop

Posted 10 May 2006 - 06:33 AM

Speaks fluent binary

Members
1,172 posts

Answer: Nothing

VARCHAR2 DATATYPE
The VARCHAR2 datatype specifies a variable length character string.
When you create a VARCHAR2 column, you can supply the maximum number
of bytes of data that it can hold. Oracle subsequently stores each
value in the column exactly as you specify it, provided it does not
exceed the column's maximum length. If you try to insert a value
that exceeds this length, Oracle returns an error.

You must specify a maximum length for a VARCHAR2 column. The
maximum length of VARCHAR2 data is 2000 bytes. Oracle compares
VARCHAR2 values using non-padded comparison semantics.

VARCHAR DATATYPE
The VARCHAR datatype is currently synonymous with the VARCHAR2
datatype. Oracle Corporation recommends that you use VARCHAR2
rather than VARCHAR. In a future version of Oracle, VARCHAR might
be a separate datatype used for variable length character strings
compared with different comparison semantics.