Solved

How can you add character length limit on an attribute within a catalog item without creating a rule ?

  • 25 January 2024
  • 2 replies
  • 71 views
P
Badge +1

Hi, 

 

What is Fractional digit used for? Can it help to identify character length within an attribute?

 

icon

Best answer by Pele 29 January 2024, 20:19

View original

2 replies

ivysakh
Rank
Badge +1

Hi,

In this context, the column size specifies the maximum length for a particular attribute, which is 500 characters. Fractional digits, on the other hand, represent the number of digits to the right of the decimal point in a numerical value. For instance, in the number 123.456, the fractional digits are 456. This portion of the number represents a fraction of a whole.

P
Rank
Userlevel 1
Badge

Hi @Psingh,

the property Fractional digits indicates how many numbers are there after the decimal separator - typically used in floating point numerical types. Since your attribute in the screenshot isn’t a floating point but rather a STRING type (NVARCHAR to be precise) this property doesn’t apply, hence is 0. It won’t help you in any way to indicate the actual string data length.

The maximum length of the string for your attribute is 500 characters (assuming 1byte per character and abstracting from the complexity of multi-byte characters & collations).

To see the string length of this attribute in a data set you could profile the data or set up a rule in a DQ monitoring project.

Hope this helps.

Petr

Reply


Community Terms of Use & ConditionsCookie settings