About the maximum number of bytes that can be set in the Journal field.

[Ohki_Yamamoto]

How many bytes can be set in the Journal field on the ServiceNow database?

[Community Alums]

Hi @Ohki.Yamamoto ,

As such there is no max length for journal field since the values from this field are stored in other table. The message you must be getting is for the display of the value.

However, the sys_journal_field.value is of Dictionary XML type String, which in MySQL is MEDIUMTEXT, which has a maximum length of 16,777,215 characters.

So sys_dictionary.max_length isn't a hard limit as much as a physical data type determining factor. I've seen description fields on tasks where they are populated from the inbound email body and the character counter shows "-15435 characters remaining of 4000 characters" and none of the data is ever truncated from the field.

If you want to fully limit the character count, you would have to write a client script or maybe a before business rule to get the character count and abort submission/database activity.

"Provides a logical limit for the size of string fields to determine how the system displays them in the user interface and how to map them to physical database data types."

"The system maps the field length to the closest physical data type available on the database."

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Ohki_Yamamoto]

thank you.
Thank you very much for helping me!

[Community Alums]

Hi @Ohki.Yamamoto ,

Please mark the applicable answers as correct & Helpful.

Thanks,

Sandeep

[Hitoshi Ozawa · Accepted solution]

journals are kept in sys_journal_field table. The max length of column value is 8,000.

However, this is just an application limitation and ServiceNow will actually allow more characters to be entered.

Any string field that is larger than varchar(255) is given the mediumtext data type. In the client, it will be represented as an HTML textarea, instead of an HTML input. The maximum length of mediumtext is 16,777,215 bytes.

Note, that this is 16,777,215 bytes and not characters. Multibyte characters require more bytes per character.

Refer to the following documentation.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0685779

And the following thread.

https://community.servicenow.com/community?id=community_question&sys_id=cab343a5dbd8dbc01dcaf3231f96...