Re: [OSS] Re: To Do: Localization of PHP [MySQL, PostgreSQL, etc]

Andi, (although I am not pclouds),

sorting is a very common function in mySQL. I would select something from a
table and sort it, before displaying the result on a webpage.
(SELECT * FROM table SORT BY field)
A very simple example: a list with names, e.g. a payroll. Right now, mySQL
cannot sort by name in that example, because it cannot handle the
Vietnamese characters correctly.

Of course, you can get around with a LOT of extra coding, i.e. do all your
sorting in own SLOW routines, instead of using the built-in functionality,
but this means, that things are getting more slow, need more resources, and
localizations are not that easy anymore. Try to enter Vietnamese user names
in phpNuke and then sort them ....

It is really something different than translating error messages. If you
look at this URL http://www.mysql.com/doc/en/Localisation.html you will
see, that it is something different from translating some strings (like
error messages).

Stefan

At 13:45 03.03.2003 +0000, you wrote:
-------------------------
>ba'c pclouds,
>
>Do you think there is actually much point in localizing anything other
>than error and other systems messages in PHP & MySQL? Otherwise, wouldn't
>localization just be done via string cross-references in a MySQL,
>PostGreSQL or other database (for PHP as well)?
>
>Good examples of as much would include these localizations of PHPNuke or
>PostNuke, no?:
>http://vnlinux.org/ ([New?] VietLUG)
>http://www.hn-ams.org/ (HaNoi-Amsterdam Org)
>http://vietlug.sourceforge.net/ (Old[?] VietLug)
>
>Isn't all that's necessary explained at these URLs?:
>http://www.mysql.com/doc/en/Localisation.html
>(MySQL Manual | 4.6 MySQL Localisation and International Usage)
>http://www.onlamp.com/pub/a/php/2002/11/28/php_i18n.html
>(ONLamp.com: Internationalization and Localization with PHP [Nov. 28, 2002])
>
>best,
>Andi
>
>At 18:40 2003.03.01, you wrote:
>>Dear Stefan,
>>
>>Could you create a web page containing these tasks (php/mysql localization
>>and others) so that people can take a task when they have time?
>>
>>Regards,
>>
>>On Sat, Mar 01, 2003 at 06:31:44AM +0000, Stefan Probst wrote:
>> > Dear All,
>> >
>> > PHP, the FLOSS server-side language which is often used for dynamic
>> > webpages, needs also localization.
>> >
>> > Actually, it seems, that it bases its country-specific functions a lot on
>> > the OS.
>> >
>> > See e.g.
>> > http://www.php.net/manual/en/function.setlocale.php
>> > http://www.php.net/manual/tw/ref.mbstring.php
>> >
>> > Does anybody, e.g. in a LUG, have any experience and could write a HOWTO
>> > for Vietnamese?
>> >
>> > Have a nice Sunday,
>> > Stefan
>> >
>> >
>> >
>> >
>> > --
>> > Address to post to all list members: oss@isoc-vn.org (NOT: OSS@isoc-vn.org
>> > !)
>> >
>> > URL of List Archives:
>> > http://www.isoc-vn.org/cgi-bin/mojo/mojo.cgi?f=archive&l=oss
>> > URL to Subscribe to this list:
>> > http://www.isoc-vn.org/cgi-bin/mojo272/mojo.cgi?f=n&l=oss
>> >
>> > To unsubscribe from: OSS, just follow this link:
>> > http://www.isoc-vn.org/cgi-bin/mojo272/mojo.cgi?f=u&l=oss
>> > Click the link, or copy and paste the address into your browser,
>> > or send a mailto:oss-owner@isoc-vn.org to request manual unsubscription
>> > by the list administrator.
>> >
>> >
>>
>>--
>>Bi Cờ Lao
>>
>>
>>
>>--
>>Address to post to all list members: oss@isoc-vn.org (NOT: OSS@isoc-vn.org !)
>>
>>URL of List Archives:
>>http://www.isoc-vn.org/cgi-bin/mojo/mojo.cgi?f=archive&l=oss
>>URL to Subscribe to this list:
>>http://www.isoc-vn.org/cgi-bin/mojo272/mojo.cgi?f=n&l=oss
>>
>>To unsubscribe from: OSS, just follow this link:
>>http://www.isoc-vn.org/cgi-bin/mojo272/mojo.cgi?f=u&l=oss
>>Click the link, or copy and paste the address into your browser,
>>or send a mailto:oss-owner@isoc-vn.org to request manual unsubscription
>>by the list administrator.
>
>
>
>
>
>--
>Address to post to all list members: oss@isoc-vn.org (NOT: OSS@isoc-vn.org !)
>
>URL of List Archives:
>http://www.isoc-vn.org/cgi-bin/mojo/mojo.cgi?f=archive&l=oss
>URL to Subscribe to this list:
>http://www.isoc-vn.org/cgi-bin/mojo272/mojo.cgi?f=n&l=oss
>
>To unsubscribe from: OSS, just follow this link:
>http://www.isoc-vn.org/cgi-bin/mojo272/mojo.cgi?f=u&l=oss
>Click the link, or copy and paste the address into your browser,
>or send a mailto:oss-owner@isoc-vn.org to request manual unsubscription
>by the list administrator.

To facilitate co-ordination regarding the introduction of OSS SW in Vietnam

Subscribe to OSS:

Subscribe | Unsubscribe