Problem description max_length

[hpesata]

Hi!

I am currently working on getting data out of the problem table.

I am getting the schema out of the sys_dictionary definitions for the "problem" and the parent "task" table.

The "description" field of the "task" table has a max_length of 4000.

This is the value that I take for the destination storage, unfortunately I am encountering a problem record,

where the description field holds a 9547 character string, which of course doesn't fit into my destination,

because of the max_length attribute being 4000.

how is this possible, that the description field can exceed the max_length value of 4000 and how can I determine

the real maximum length of a field during the schema query?

Thanx in advance!

regards,

Hans

[Andre Moreira]

Hi Hans,

Here some tips on the Wiki:

Ref.: Variable Types

Ref.: System Dictionary

[]'s

Andre Moreira

[hpesata]

Hi Andre!

Thanx for Your reply!

I was reading through the Wiki articles but couldn't find any hint on how it can happen, that the description field can hold more characters than the specified 4000.

I found another problem record which has a description with more than 62000 characters !

maybe using an aggregate query on the description length would be an solution to find the real maximum value ?

Thanx and regards,

Hans

[geoffcox]

We have a couple of text fields set to length = 1,000,000 (for transferring large blobs of JSON data around).

[hpesata · Accepted solution]

Good morning!

I found a description on how large text fields are handled here:

http://www.servicenowguru.com/scripting/client-scripts-scripting/maximum-length-large-string-fields-...

Thanx and regards,

Hans