Change maximum name length for category from 400 to 500

Hi

I need to change the maximum category name length from 400 to 500, where can I find this parameter?

It´s for nopCommerce 4.00.

Thank you :-)

Open your DB and run this query

ALTER TABLE [dbo].[Category] ALTER COLUMN [Name] NVARCHAR (500) NOT NULL;

Open your DB and run this query

ALTER TABLE [dbo].[Category] ALTER COLUMN [Name] NVARCHAR (500) NOT NULL;

Thanks, but I checked the table and the value is 800, but you are only allowed 400 chars?

from DB:
Key  Column  Type  Length  Prec.  Scale  Nullable  Default  Rule  Id.  Id. start  Id. seed  
  Name  nvarchar  800         False         False

Change this and recompile whole project. Here is a link to see it bigger

https://image.ibb.co/erDf3R/change_Category_Map_here.png

Thank you, that worked perfectly :-)

WeroShop.dk wrote:

never a problem :) glad i was helpful!!

What if I need to change the Category description text to be larger than 1000 chars where is that located?

I'll look, but category is an nText in the DB and i think it holds over 40k characters.