If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Changing # of characters

Changing # of characters

Started by robertg on 31 May 2012, 3:11 PM · Views: 642

Results 1 to 4 of 4
31 May 2012, 3:11 PM
#1
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Changing # of characters

I want to increase the number of characters I can type for the Products Name: section.
Where do I go to extend number of characters that I can type. It's known as title when on the line.:unsure:

31 May 2012, 4:36 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Changing # of characters

RobertG:

I want to increase the number of characters I can type for the Products Name: section.
Where do I go to extend number of characters that I can type. It's known as title when on the line.:unsure:

You need to increase the VARCHAR value in the database fields for products_name

The following TABLES have that as a field:
orders_products
products_description
customers_wishlist

Find the FIELD (products_name) in each of these tables and then (using the "change" feature in phpMyAdmin, change the VARCHAR value from 64 to something larger. Don't go mad... you should be able to get away with VARCHAR = 128 .

Bear in mind that overly-long product names may clutter your site visually.

20 years a Zencart User

3 Jul 2012, 4:40 AM
#3
adem_i avatar

adem_i

New Zenner

Join Date:
Jul 2010
Location:
Sydney, Australia
Posts:
86
Plugin Contributions:
0

Re: Changing # of characters

schoolboy:

You need to increase the VARCHAR value in the database fields for products_name

The following TABLES have that as a field:
orders_products
products_description
customers_wishlist

Find the FIELD (products_name) in each of these tables and then (using the "change" feature in phpMyAdmin, change the VARCHAR value from 64 to something larger. Don't go mad... you should be able to get away with VARCHAR = 128 .

Bear in mind that overly-long product names may clutter your site visually.

Where are the contents of the ez page stored in the database? which table is it in? I've been looking for ages, but not really sure how to find it.

relatively new to Zen Cart

3 Jul 2012, 8:54 AM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Changing # of characters

Your post is off-topic, but why do you want to access the content in the dbase? there is no need...

20 years a Zencart User