Forum Discussion

kmd's avatar
kmd
Contributor
2 years ago

Looking for list of max character limitations for metadata, including annotations

Anyone have something they use?

Seems like OS has never provided a nice little reference like this.

Thanks in advance for anything anyone wants to share.

Metadata
  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    I used DanielWillis 's SQL to generate this result.  Maybe it can help:

     

     

    SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM information_schema.columns 
WHERE table_name = 'StageSourceData'
ORDER BY COLUMN_NAME

     

     

    • kmd's avatar
      kmd
      Contributor
      2 years ago

      Hm... I assume this limitation does not apply to other metadata or data source attributes.  Just tried to load a file where the Data Source was picking up a member description from the load file and refused to load due to field length (longest of the row items fields was 110 char).  

      I'm looking for something a bit more comprehensive that will provide limitations as well for text fields and annotations etc. etc.  We ran into similar problem with Thing Planner and even the OS consultant wasn't sure what the field limitation was so.... that's not good.

      But thanks very much for this.  Personally speaking, it seems like a member name over 40 characters is overkill anyhow.  Why on earth would they make the limit 500?

      • EricOsmanski's avatar
        EricOsmanski
        Valued Contributor
        2 years ago

        I am not aware of a list that current exists, but Stage Attributes are limited to 100. Annotations and Text fields don't have a max character limit, but I believe would be limited to a 2GB storage max.