Simple SQL question (I'd say)

Hey all,

INSERT INTO `townsandstates` VALUES ('', 'Nyc', 'NEWYORK', 'New York City');


I want NEWYORK to read NEW-YORK-CITY (for url rewrite purposes) but when I exceed 10 characters the search doesn't work anymore?

I'd like it like this:
INSERT INTO `townsandstates` VALUES ('', 'Nyc', 'NEW-YORK-CITY', 'New York City');

or even
INSERT INTO `townsandstates` VALUES ('', 'Nyc', 'NEWYORKCITY', 'New York City');


Any ideas?
Leo

 

Which is the type of the field ? With all type, you can define a max number of characters. It seems your max number is too smal.

 

Thanks buddy - thats what it was!