random1 Posted March 16, 2010 Share Posted March 16, 2010 I am currenty creating a web app that supports multiple languages. I'd like some tips and help with choosing the best kinds of field formats for world-wide: - Phone numbers - Area Codes - Post Codes - Credit Cards - etc.. By world-wide I mean that the phone number is in a format that is understood world-wide to a standard. E.g Source: http://msdn.microsoft.com/en-us/goglobal/bb688129.aspx Any thoughts? - Dean Quote Link to comment https://forums.phpfreaks.com/topic/195384-mysql-and-standardisation-of-field-data-types/ Share on other sites More sharing options...
jskywalker Posted March 16, 2010 Share Posted March 16, 2010 I am currenty creating a web app that supports multiple languages. I'd like some tips and help with choosing the best kinds of field formats for world-wide: i dont see what a field-format has to do with different language.... i certainly agree, that in different country's some field may be strored with a different format, but it has nothing to do with the language people are talking in that country. Quote Link to comment https://forums.phpfreaks.com/topic/195384-mysql-and-standardisation-of-field-data-types/#findComment-1027143 Share on other sites More sharing options...
fenway Posted March 20, 2010 Share Posted March 20, 2010 CHAR columns for every single one of the above, or leading zeros will kill you. Quote Link to comment https://forums.phpfreaks.com/topic/195384-mysql-and-standardisation-of-field-data-types/#findComment-1029306 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.