Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: value too large why oh why?

Re: value too large why oh why?

From: dombrooks <dombrooks_at_hotmail.com>
Date: 16 Feb 2007 13:41:30 -0800
Message-ID: <1171662090.732279.289130@h3g2000cwc.googlegroups.com>


With variable length charactersets, a character could take n bytes. The default semantics of a column length, e.g. VARCHAR2(50), is bytes.

See parameter NLS_LENGTH_SEMANTICS.

Maybe your column should be VARCHAR2(50 CHAR). Received on Fri Feb 16 2007 - 15:41:30 CST

Original text of this message

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