nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

length of String parameter

sall

Hi.
I have a information object model that have String parameter. When I open this IOB by BIRT Report Studio I entered String parameter. If length of parameter less than 50 all is very good. But when length of parameter more than 50 I am receiving exception: SQLState = 22001 Native Error = 0 Error Message = [ActuateDD][ODBC SQL Server Driver]String data, right truncation.

How I can increase length of String parameter?
Thanks.

Find more posts tagged with

Comments

CBR

This message is not BIRT but database related
Do you use the parameter in a DB query? What's the type of the corresponding database field? Seems to be the case that the field only allows up to 50 characters.

sall

<blockquote class='ipsBlockquote' >
Do you use the parameter in a DB query? </blockquote>
Yes. And I use MSSQL Server 2008 
 
<blockquote class='ipsBlockquote' >
What's the type of the corresponding database field? </blockquote>
The field has Varchar(250) type. 
 
<blockquote class='ipsBlockquote' >
Seems to be the case that the field only allows up to 50 characters. </blockquote>
When I execute query by SQL Server Managment Studio I use more than 50 characters in query of the corresponding database field