Increasing PostalCodeFilter length from 255 to max

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
cmorganmcp
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 36
Joined: Mon Dec 08, 2008 10:41 am

Increasing PostalCodeFilter length from 255 to max

Post by cmorganmcp » Mon Oct 18, 2010 3:29 pm

Is there any reason I shouldn't be able to increase the field size in the database for dbo.ac_ShipZones column PostalCodefilter from nvarchar(255) to nvarchar(max)? I have a ton of FedEx zones I'd like to enter and I'm having to split them across multiple zones because of this limit. Is there any chance increasing this could adversely affect anything?

-chad

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Increasing PostalCodeFilter length from 255 to max

Post by mazhar » Tue Oct 19, 2010 4:45 am

I think it should work. Internally system is using String type to map on db nvarchar so for API it doesn't makes any difference.

Post Reply