my only comment on this is that although you appear to have two different
problems - you don't!
pick a single solution to both cases; then when your solution needs
modification, you only have one set of code to change.
this obviously is computer science; only tenuously related to mysql.
At 02:55 PM 7/7/01 -0600, you wrote:
>I'm working on two projects for which I'm trying to build in functionality
>to localize or internationalize later.
>
>For one project, a large chunk of text would be translated into an unknown
>number of languages. For this I'm allowing the text to be a 'text' field
>in a record, with other fields holding the language code (i.e. 'en', 'fr')
>and another the charset for that language.
>
>For the second, only a set of keywords would be translated into a small
>number of languages. For this project I'm using one record per keyword,
>with the various language translations being separate fields within the
>record - the record 'id' is what drives searches in this case.
>
>I'm using an Apache server with Perl and PHP, and MySQL as a db (of course).
>
>The only steps I'm taking is to have a field specifying the language (in
>the first case) and to name the columns/fields by the language code (i.e.
>'en', 'de, 'jp') in the second. I'm also allowing twice as many
>characters for the 'jp' field, since that language requires (as I
>understand it) 'double' characters to drive it. I intend to drive the
>content by (1) selecting the language according to the 'Accept-Language'
>variable in the user's browser OR (2) allowing the user to select a
>language manually.
>
>Obviously I'm not up to speed on the exact requirements of localization
>and using other languages, and am concerned more about some pedestrian
>basics first - I'm just trying to avoid painting myself into a corner.
>
>Is there anything else I should be doing, or doing different? Can you
>point me to any resources on localization that would help me build this
>right the first time?
>
>Thank you for any assistance,
>Nelson
>--
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
----------
tom marlin
[EMAIL PROTECTED]
fax / voice mail: 714 507 3802 ext 4881
Never be afraid to try something new. Remember that
- amateurs built the ark.
- professionals built the Titanic.
