| Author |
 Topic  |
|
|
MartijnRemmen
Starting Member
Netherlands
2 Posts |
 Posted - 06 June 2002 : 09:55:51
|
When I try to register as a new user, and I choose the country British Indian Ocean Territories, I'll get an error. Also in version 4.0 beta 3 an error is raised. The problem in version4.0 beta 3 (and I thins the same is the problem in version3.3) is that the database field country is limited to 20 characters. So this should be increased till the longest name in the country list. Or what might be a better approach is replace the countryname field by a country_id and create a seperate table with countries.
This leads to the following problem.
Sex is stored as a string, like male/female. But when a language pack is installed (at least the Dutch language pack), the values are replace by man/vrouw. But the actual values that are stored in the database also change. Because I am using a English and a Dutch forum, with a combined user table, I'll get four different values in the sex column.
Again a better approach is to just store a sex_id in the database and let the language pack decide which text should be linked with the sex_id.
Hope this helps...
Martijn Remmen
QuadriX® System Design
The Netherlands
Edited by - MartijnRemmen on 06 June 2002 10:22:38
Edited by - Davio on 06 June 2002 11:32:08
Edited by - bozden on 06 June 2002 11:51:27
[moved by bozden on 02 October 2002]
< |
Edited by - Deleted on 02 October 2002 21:50:37 |
|
|
Deleted
deleted
4116 Posts |
Posted - 06 June 2002 : 11:37:45
|
Thank you for feedback and your input.
The country field size error is known for v3.3.x, and also for v4b03.x (which has the same database structure as v3.3.x). You can find the related topic here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=14493
This will be corrected in v3.4 and thus in v4b04. You can do it by manually increasing it. Also v3.3.05 has the setup.asp which does this automatically (v4b03.x does not, even in the patches, because we omitted changes in such).
The field value will be left as a string, there won't be a country table with codes in v3.4. It would cause a couple problems: Upgrading issues, join and/or another select needed to show the country, etc. These will be in another file, more easier to edit. v4b04 will also allow to specify a default country and the translation of the default country name...
You are right with the sex field, but it is solved in the patches so that the stored code is independent from what is shown. What you call "code" is now "male" and "female" only... The reasons are about the same as above.
You seem that you missed the patches. Plase DON'T, because they fix the security issues. Follow the link in my signature to reach all v4 related info including the patches and v4b04 related development.
Think Pink
==> Start Internationalization Here< |
 |
|
| |
Topic |
|
|
|
