Re: bytes vs chars
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 11 Mar 2016 11:56:45 -0700
Message-ID: <56E314ED.6020000_at_gmail.com>
On 11/03/2016 11:41 AM, Ilmar Kerm wrote:
> Really strange and confusing, that Oracle interprets VARCHAR2(30) by
> default as bytes, other databases that I know interpret it as
> characters that makes much more sense.
Backward compatibility. As per the docs.
Date: Fri, 11 Mar 2016 11:56:45 -0700
Message-ID: <56E314ED.6020000_at_gmail.com>
On 11/03/2016 11:41 AM, Ilmar Kerm wrote:
>
> Really strange and confusing, that Oracle interprets VARCHAR2(30) by
> default as bytes, other databases that I know interpret it as
> characters that makes much more sense.
Backward compatibility. As per the docs.
Too many DBAs 'thought processes' and scripts, as well as existing systems based on bytes.
Even simple things like reporting usage could break.
/Hans
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 11 2016 - 19:56:45 CET