PDA

View Full Version : State name length limitation


Martin
02-04-2006, 05:28 PM
Hi,

I just found out that the length of state names, and probably other field names to (I did not check) are limited in character length.
Is there an easy way to extend the number of characters, because a state name of Chile like "Aisén del General Carlos Ibáñez del Campo" simply doesn't fit (and they have more of these long names :))

Thanks,
Martin

David
02-04-2006, 05:31 PM
Ok, added to the list...
I should an answer for both soon.

Martin
02-04-2006, 05:40 PM
Already found it, I should experiment a bit more before asking :).
I just changed the field length in MySql from varchar(32) to varchar(64).

And just to be sure I did the same on country and city names to.

Martin

David
02-04-2006, 05:48 PM
Good. Thanks for letting me know.