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