Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQM: Size of SMALL_STRING / MEDIUM_STRING

Questions
Tags
Users
Badges
Jörg Werner
(303●38●81) 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

0 votes

1 answer
3,355 views
0 votes

Accepted answer

Permanent link
Ara Masrof
JAZZ DEVELOPER (3.2k●1●5) Jan 31 '14, 11:24 a.m.
 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

1 vote

Comments
Jörg Werner
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 log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jan 31 '14, 10:51 a.m.

Question was seen: 3,355 times

Last updated: Jan 31 '14, 11:53 a.m.

Confirmation Cancel Confirm