Hi.... can anybody change this line for me `id` varchar(11) NOT NULL, I want to change it so that the id can be a very very long url.... SO it has to be defined different right....???? Thanx. M.V.
How long are we talking about? You could just change the varchar to something like varchar(4000). The beauty of the varchar is that you don't have to worry about the extra memory. It only allots as much as is needed for the data (not the definition).
I think the logest url will be about 150 or 200 letters. but maybe the problem are signs like "http://^*`+-...¨etc. How to i define as text... and will it allow // thanx mv
Just to make it clear, varchar() field type can store up to a max of 255 characters. if you need more than that, you go for mediumtext or text.
Ok... i got the problem with the length now... But i cant make IDs as urls, becasue of the dots and slashes.
That is a MySQL limitation? (varchar 255) I was not aware of that. I mainly use MS-SQL and the max length is much larger. I just found it. Starting in MySQL 5.0.3 the max length for varchar is 65K and 255 before that. Learn something new everyday.