Re: java.sql.SQLException: Data size bigger than max size for this type: 3991
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 25 Jul 2008 14:13:30 GMT
Message-ID: <1216995206.742649@proxy.dienste.wien.at>
>
> CREATE TABLE ct_tb_crs_ovrvw
> (
> nm_prgrm_id NUMBER,
> vc_prgrm_ovrvw VARCHAR2(4000),
> vc_prgrm_otcm VARCHAR2(4000),
> vc_trgt_odnc VARCHAR2(4000),
> vc_lang VARCHAR2(100),
> ch_sft_dlt char,
> vc_crtd_by VARCHAR2(100),
> dt_crtd_dt DATE,
> vc_mntn_by VARCHAR2(100),
> dt_mntn_dt DATE
> );
> and i m tryying to put the values in vc_prgrm_ovrvw field.
> db charector set is UTF-8
Date: 25 Jul 2008 14:13:30 GMT
Message-ID: <1216995206.742649@proxy.dienste.wien.at>
uday <uday1067_at_gmail.com> wrote:
>> > i have been using setString() of prepared statement. but it is giving >> > me >> > java.sql.SQLException: Data size bigger than max size for this type: >> > 3991 exception. where as as per my understanding, the size of varchar2 >> > is 4000. >> >> > can someone suggest the solution >> >> Well, how is the field defined? What is the value you want to store? >> What is the database character set?
>
> CREATE TABLE ct_tb_crs_ovrvw
> (
> nm_prgrm_id NUMBER,
> vc_prgrm_ovrvw VARCHAR2(4000),
> vc_prgrm_otcm VARCHAR2(4000),
> vc_trgt_odnc VARCHAR2(4000),
> vc_lang VARCHAR2(100),
> ch_sft_dlt char,
> vc_crtd_by VARCHAR2(100),
> dt_crtd_dt DATE,
> vc_mntn_by VARCHAR2(100),
> dt_mntn_dt DATE
> );
> and i m tryying to put the values in vc_prgrm_ovrvw field.
> db charector set is UTF-8
See Metalink note 144808.1
4000 is the hard limit in the number of *bytes* that can be stored in any VARCHAR2 field.
In UTF-8, a character can take more than one byte.
Even if you had defined the field as VARCHAR2(4000 CHAR) as generally is advisable in an UTF-8 database, you're still stuck with a physical limit of 4000 bytes per VARCHAR2 field.
If the string you are trying to store is not more than 4000 characters long, it must contain some characters that take up more than one byte to trigger the message.
> please suggest some solution.
Use CLOB. Or a different DBMS.
Yours,
Laurenz Albe
Received on Fri Jul 25 2008 - 09:13:30 CDT