Questions tagged [varchar]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
42 views

Increase varchar limit fot small_image attribute

I am using Magento 2.3.4.I have imported the product sheet in back end. It throws the error "Attribute small_image exceeded max length in row(s): 1".I have to import image from external url the ...
Jothi Subramanian's user avatar
5 votes
0 answers
141 views

Is it possible to reduce the default varchar size in catalog_product_flat? (M2)

I have a seemingly common problem. With too many custom attributes that are necessary and no way to change them in a way that would make the use of the default flat catalog possible I am searching for ...
Tobi's user avatar
  • 153
0 votes
1 answer
642 views

Extend Custom Attribute Value Limit from VARCHAR 255 to 500

OK had a look round and cannot seem to find an exact solution to my problem. I have a custom attribute that stores a link, on some cases this link can be up to 500 characters long. When I show show ...
Mike Tim Turner's user avatar
6 votes
1 answer
3k views

Which characters are allowed (by default) in a SKU?

A simple question with no hits on Google. What are the characters that are allowed in a SKU? The entire UTF-8 character set?
Luke A. Leber's user avatar
1 vote
3 answers
15k views

EAV attribute values stored in database

I have an attribute in use on Magento where the data has been split between catalog_product_entity_varchar and catalog_product_entity_decimal due to the datatype being changed in the database. The ...
Duncan Wardlaw's user avatar
1 vote
1 answer
98 views

Singed integers are not saving properly?

I have a custom table with column 'discount_percentage', which is a signed integer. e.g. +5 , -2 likewise I have defined the data type as Varchar for this field. But it's not saving the value ...
Sukeshini's user avatar
  • 9,955