where in database do custom fields store?

[kiasati]

Hi
I have some custom fields in "Editor" type to show some text in product page.
but it has character limit. how can i increase the limit or remove the limitation?
where in database do custom fields store?

[Studio 42]

Hi, the limit is  2500 char for customfield_value.
The table is #___virtuemart_product_customfields
You should not change this because you can loose your changes on update Virtuemart and this can slowdown your shop if you need it to search in customfields(2500 is already big).
I have this type of field in my plugin, if you need a simple editor. See My Addon and parameters, it use the params and have a maximum length of 65,535 char(minus params name) this is more then the product_desc itself, limited to 18400 char for the same reason as custom value.

[kiasati]

Hi, the limit is  2500 char for customfield_value.
The table is #___virtuemart_product_customfields
You should not change this because you can loose your changes on update Virtuemart and this can slowdown your shop if you need it to search in customfields(2500 is already big).
I have this type of field in my plugin, if you need a simple editor. See My Addon and parameters, it use the params and have a maximum length of 65,535 char(minus params name) this is more then the product_desc itself, limited to 18400 char for the same reason as custom value.

Thanks a lot for answering
so i thought of another solution. i'll make another custom field and show it right after the first one.

another problem:
the type of this custom field is "Editor".
but in the backend the entry box is not an editor. it's an simple text box to put code in it. what is the problem and how can i fix this?

[Studio 42]

I wrote my plugin to solve all this problem in Virtuemart.
Sometime this is a Javascript problem or you need to reload the product form.