varchar(2500) not enough for customfield_value and fieldtypes in general

[pinochico]

#__virtuemart_products.product_gtin
Fieldtype :  VARCHAR(64)  OK for this one it's a bit more contentious, but given that the GTIN is officially a maximum of 14 characters in length (ITF-14 for multipacks) I think a VARCHAR(14) would be more appropriate.

for ISBN too?

gtin is not only for gtin

[jenkinhill]

"VARCHAR(15359)"  See https://forum.virtuemart.net/index.php?topic=140717.msg495316#msg495316

[sirius]

ok thanks jenkinhill
understood, so yes a mediumtext will be involved

hi pinochico
gtin is for gtin, it's hazardous to use it for something else than it's own purpose. And if so the name should be something else than gtin.
https://en.wikipedia.org/wiki/Global_Trade_Item_Number

This apart ISBN is now a GTIN-13 since 2007.

[pinochico]

hi sirius:

thanks for your info, we use this filed for ISBN too, but I don't check if the same as EAN, only import from Helios (value is from eshop owner) and is ok == function.

[jenkinhill]

I use GTIN for ISBN for a bookstore, but it is renamed in the language files since they only trade in the UK and everybody who deals with books uses the ISBN designator.

[pinochico]

I use GTIN for ISBN for a bookstore, but it is renamed in the language files since they only trade in the UK and everybody who deals with books uses the ISBN designator.

Exactly, we use too