There's always limits on a database field, no matter what type. In this case we are talking the configuration table - mysql text fields. I'm sorry, D, you obviously hit a ceiling there!
There's always limits on a database field, no matter what type. In this case we are talking the configuration table - mysql text fields. I'm sorry, D, you obviously hit a ceiling there!
The full-time Zen Cart Guru. WizTech4ZC.com
I wouldn't alter it for this one thing. This affects the entire cart - it's the heart of the database and could affect performance.
The full-time Zen Cart Guru. WizTech4ZC.com
Sorry, have only just seen these replies. Can't believe after all that time and trouble I'm stuffed for it working as I need it too (deep sigh). Are you able to tell just how many postcodes the max limit is please?
Thanks.
From memory that DB field allows for max 256 characters (could be wrong though...).
For 5 digit US postcodes that would mean about 42 postcodes (5 digits for every postcode plus one separating comma for each postcode minus one comma at the end of the array).
Try that and let me know how many codes you are able to fit.
As an aside, how did Delia get your copy of PDP to work? I am interested what caused the problem and what her solution was.
Cheers / Frank
Hi Frank,
Ok thanks I'll have a play and see how many I can get in there and let you know.
Re Delia, I think she herself didn't really know as she changed a bunch of stuff and it sprung into life. I am about to use it on another site and so far do not having it working so when I get chance to play I'll see if I have more success with that one and let you know what I come up with.
Thanks again for coming back to me.
D.
Hi Frank,
I have been playing around with this and I can add 65,500 odd characters.
Today I have been trying to mind an add-on which will achieve the same result but am struggling to find anything. Are you able to get this to work just using the first portion of a UK postcode i.e SS0 up to SS99 say as even that would work for me?
Look forward to hearing from you.
Thanks.
Denise.
Yep, 65536 chrs to be precise
As I mentioned earlier in this thread, UK postcodes are somewhat unique - being a numerical minded person, I am struggling to come to grips with that logic .... no offense intended, they are just the way they are.
I need some time to learn about the UK postcodes and then try and incorporate a suitable code into my pending PDP v2.2
I am thinking about the 'LIKE' operand when testing for allowed postcodes - that is instead of the current '=' operand
Pls leave it with me - I have a little think about this.
Cheers / Frank
Indeed Frank, 65536 it is!
I have a list of the postcodes I need to allow which I can send over to you if it helps, but basically all UK postcodes start with two letters re;evant to their location i.e SS (Southend-On-Sea) followed by either 1 number (if you live close to the center of that place) or up to two numbers i.e. SS1 or SS99 if you live further away from the center. These are then followed by a space and then 1 further number and then a further two letters. In short a postcode will either have a LETTERLETTERNUMBER NUMBERLETTERLETTER or LETTERLETTERNUMBERNUMBER NUMBERLETTERLETTER format depending on location. Hope that helps but if you could modify to use just the first portion of UK postcodes that would be enough to control location and then take away the character issue within a database.
Make sense??!!
Bookmarks