RQM: Size of SMALL_STRING / MEDIUM_STRING

Jörg Werner (303●35●78) | asked Jan 31 '14, 10:51 a.m.

Hello,

what is the maximum string size of SMALL_STRING and MEDIUM_STRING?

I get an error when inserting a very long string (using REST):

Caused by: com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0329E The database query could not be completed. String data, right truncation
SQL: INSERT INTO PLANNING.TEST_PLAN_MEDIUM_STRING_EXTENSIONS (JZ_PARENT_ID, INTERNAL_ID, KEY_COL, VALUE_COL) VALUES (?, ?, ?, ?)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.121
SQL State: 22001
Error Code: -302

thanks Joerg

Accepted answer

permanent link

Ara Masrof (3.2k●1●5) | answered Jan 31 '14, 11:24 a.m.
JAZZ DEVELOPER

Jorg,

I'm pretty sure these are size settings:

small 250 bytes

medium 1000 bytes

large string: 32768 bytes

I believe the strings are stored UTF-8 encoded, so 250 bytes does not equate to 250 characters

Ara

Jörg Werner selected this answer as the correct answer

Comments

Jörg Werner commented Jan 31 '14, 11:53 a.m.

Thanks Ara!

After I truncated the string to 1000 bytes it works.
Large String is no option for customized fields :-(

Regards, joerg

It's all about the answers!

Related questions

RQM: Size of SMALL_STRING / MEDIUM_STRING

Accepted answer

Your answer