Number of Character in Fields

[lesliekirk]

Is there a list somewhere that outlines the number of characters that can entered (used) in all of the fields in the Miva admin? For example, how many characters can be used in the Product Code or Product Name field. It would be really nice to have some sort of chart that can be referred to.

[Kent Multer]

The Database Reference Manual tells the type and length of the fields in most the tables. If you know how to use phpMyAdmin, you can actually check the DB to see how many characters a field can hold. Of course, you have to know enough about the DB structure to figure out which table column corresponds to which admin text box.

In general, I think, codes (such as product codes, category codes, etc.) are 50 characters, and names are 100.

[Gordon - Phosphor Media]

Leslie:

Our free Database Viewer will let you view ANY store or domain table. If you hover over a field name, it will display the data type (integer, char, boolean etc) and maximum characters.

The Database Reference is OK but it hasn't been updated since late 2014 so many tables have been added and fields have been added, so it is somewhat out of date.

As Kent mentioned, the most common codes (product, category) are 50 chars and names are 100 chars.