Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2010 @ 19:48:23 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: 3738: String is longer than 31000

From:		Dieter Noeth

Hanumath Padarthi wrote:

I am facing the below error when Inserting/updating a row with more than 31000 characters in a table attribute which has been defined as varchar (64000). Is there any setting to allow more than 31000? There should be some way it should allow to Insert/Update more than 31000 if we could be able to define as 64000.

3738: String is longer than 31000

See the previous post by John Wight :-)

3738 String is longer than 31000 characters.

Explanation: Quoted strings cannot be longer than 31000 physical characters.

Generated By: LEX modules.

For Whom: End User.

Notes: To insert longer strings, the user must have a USING clause and a DATA parcel that contain the characters.

Remedy: Correct the statement to have a shorter string, and resubmit the request.

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2010 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023