what is the difference between string and string utf-8??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-09-2017 11:41 PM
we are confused .please explain the difference between string and string utf-8??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2017 03:01 AM
Hello Sreevani,
| String | For 254 characters or less, the string field will be a single-line text field. Anything 255 characters or over will appear as a multi-line text box. Note: The database may translate the value you provide in the Max length field to the closest matching database field type. For example, a max string length of 80 maps to the nearest database field type of VARCHAR(100). For Oracle instances, users will not be able to increase the max length of a string field to anything greater than 4000 through the application UI as this requires the CLOB data type in Oracle. If you require a field to be larger than this, you can log an incident to request that our DBA make this change for you. |
| String (Full UTF-8) | A string field that can contain UTF-8 character encoding. The description above about the number of characters applies to this field type. |
Reference:
Thanks,
Dravvy
Please Hit like, Helpful or Correct depending on the impact of the response
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2017 06:09 AM
According to the reference (see below) ServiceNow uses UTF-8. UTF-8 uses a maximum of three bytes per character. The type "String (Full UTF-8)" supports 4 byte UTF.
References and additional info:
Best regards,
Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2018 08:16 AM
Just one slight difference i've noticed in platform behavior between the two options:
I've noticed that when adding a String vs String Full UTF on a form (like Incident form) that for the Full UTF I was unable to create the choice list on the field from the form designer. It appears that you can still create the choice list by editing the dictionary entry for the field.
this observation was from Instanbul, both on a sandbox instance and a production owned instance.
