Kenneth wrote:
> On Fri, 19 Mar 2004 15:14:21 +0100, Frank van Bortel
> <fvanbortel_at_netscape.net> wrote:
>
>
>>Kenneth wrote:
>>
>>
>>>I checked your URL which stated that a VARCHAR2 column can hold 4K of
>>>chars. Not true, 4K = 4 * 1024 = 4096. A VARCHAR2 can only hold 4000
>>>chars.
>>>
>>
>>And not even that is true, it can hold up to 4000 byte of characters.
>
>
> Yep. Which results in a maximum of 4000 chars with a single-byte
> charset. As I said.
>
> - Kenneth Koenraadt
>
>
>
>
>>--
>>
>>Regards,
>>Frank van Bortel
>>
>
>
You did not mention the single-byte charset, which causes confusion
when just stating a varchar2(4000) column can hold 4000 characters.
The whole point is, it's not characters, it's bytes.
--
Regards,
Frank van Bortel
Received on Sat Mar 20 2004 - 06:07:37 CST
