Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: difference b/w varchar and varchar2
On Sat, 4 Dec 1999 17:25:46 +0500, "Aamir Khan" <akhan_at_atlantic2000.com>
wrote:
>What is the difference between varchar and varchar2 ???
>
>Regards,
>Aamir Khan
>
as I understand it ( and I could be wrong)
varchar2 has a trailing hex00 delimiting the length of your varying length
character string, this is correctly implemented in Oracle, while
varchar has a leading length field bit 16 specifying the length
but current releases of oracle do not implement this
therefore always use varchar2
or if someday they do implement varchar
you could be in trouble
>
Received on Thu Dec 09 1999 - 11:05:42 CST