Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Seattle, WA
    Posts
    2,838
    Plugin Contributions
    0

    Default More Characters In Category Name

    Hello,

    Can't find where to increase the number of characters I can use in a category name.

    Thanks

  2. #2
    Join Date
    Sep 2004
    Location
    Western Massachusetts
    Posts
    2,945
    Plugin Contributions
    5

    Default

    You probably have to do it directly at the datbase level with phpMyAdmin - I've seen forum replies giving that solution for product name length.
    Neville
    An assumption is what you arrive at when you get tired of thinking...

  3. #3
    Join Date
    Mar 2004
    Location
    Seattle, WA
    Posts
    2,838
    Plugin Contributions
    0

    Default

    Thanks - I will look into that

  4. #4
    Join Date
    Jun 2003
    Posts
    33,720
    Plugin Contributions
    0

    Default

    Brian,

    Bunyip is absolutely correct. If I remember correctly, they are varchar 32 right now and you can increase that up to 255.
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  5. #5
    Join Date
    Mar 2004
    Location
    Seattle, WA
    Posts
    2,838
    Plugin Contributions
    0

    Default

    Yes, I found it, and for future reference the proper code to use in the SQL is

    Code:
    ALTER TABLE `categories_description` CHANGE `categories_name` `categories_name` VARCHAR( 64 ) NOT NULL
    This changes the character allowance from 32 to 64 for this table.

 

 

Similar Threads

  1. v151 increasing number of characters in category name
    By hyeboy99 in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 20 Jan 2015, 02:27 AM
  2. Special characters in Product Name
    By Stuff4Toys in forum General Questions
    Replies: 2
    Last Post: 8 Feb 2008, 08:21 PM
  3. Product Name Naximum # of Characters
    By Donn in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 7 Nov 2007, 03:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg