Questions tagged [varchar]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
19 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 ...
0
votes
0answers
22 views

EAV - Static and Varchar Entity - What is the common between both?

I need a help on one of the following question : Q - EAV - Static and varchar entity type what is the similar in between this ? Both values can be identical for single sites Both values can be ...
4
votes
0answers
77 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 ...
0
votes
1answer
468 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 ...
5
votes
1answer
2k 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?
1
vote
3answers
11k 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 ...
1
vote
1answer
86 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 ...