Re: Does a varchar2 really use a variable amount of space?

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Thu, 06 Aug 1998 21:15:05 GMT
Message-ID: <35ca1903.51649227@news.demon.co.uk>

On Thu, 06 Aug 1998 16:23:53 GMT, p0070621_at_brookes.ac.uk (Tommy Wareing) wrote:

>On Thu, 06 Aug 1998 13:37:33 GMT, nasof_at_hotmail.com wrote:
>>Actually it will user 6 bytes: 5 for data and 1 for the length
>
>Which would limit it to 256 characters. Since the maximum is 2000/4000
>characters (v.7 / 8 respectively), it must be (?) two bytes.

Ther is 1 length byte for up to 250 characters, above that there are 3 length bytes!

Eric Received on Thu Aug 06 1998 - 16:15:05 CDT

This message: [ Message body ]
Next message: R.Schierbeek: "Re: Rollback Seg problem."
Previous message: rwessman_at_us.oracle.com: "Re: SSH client interactivity"
In reply to: Tommy Wareing: "Re: Does a varchar2 really use a variable amount of space?"
Next in thread: nasof_at_hotmail.com: "Re: Does a varchar2 really use a variable amount of space?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US