It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,946
×6,027

question asked: Jan 31 '14, 10:51 a.m.
question was seen: 3,136 times
last updated: Jan 31 '14, 11:53 a.m.

Related questions

RQM: Size of SMALL_STRING / MEDIUM_STRING

0
Jörg Werner (303●38●81) | 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

1
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

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.