Re: using SET time_zone for localization
Hello.
Perhaps this can resolve some queries:
http://lists.mysql.com/mysql/177314
John Lauck wrote:
I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not
working.
What am I doing wrong?
I have verified that the session.time_zone var is set correctly.
if(defined('ZMM_USER_LOCALE')) {
$query = SET time_zone = ' .
mysql_real_escape_string(ZMM_USER_LOCALE) .'; ;
$sel_result = @mysql_query($query);
}
$query = SELECT `int_resp_id`, ;
$sel_result = @mysql_query($query);
If I make the second $query = SELECT NOW() I get the correct time
adjusted values.
Does this method only work for INSERTS or when you want to adjust the
NOW() value? Not for pulling select statements out of the db?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
using SET time_zone for localization
I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not
working.
What am I doing wrong?
I have verified that the session.time_zone var is set correctly.
if(defined('ZMM_USER_LOCALE')) {
$query = SET time_zone = ' .
mysql_real_escape_string(ZMM_USER_LOCALE) .'; ;
$sel_result = @mysql_query($query);
}
$query = SELECT `int_resp_id`, ;
$sel_result = @mysql_query($query);
If I make the second $query = SELECT NOW() I get the correct time
adjusted values.
Does this method only work for INSERTS or when you want to adjust the
NOW() value? Not for pulling select statements out of the db?
Re: RE:Re: RE:Re: Localization..
which version are u using? and pls state other info about ur OS! using with 3.23.38-max-nt in Windows2000 Advanced Server without problem when I search exactly your example. about the case %0xF4 0xF4%, have u really used it to search in where clause, or u just want to elaborate ur example? I am useing Mysql-3.23.39/40 on FreeBSD and Debian Linux, with default charset Latin1, column type is varchar(n) binary I didn't try the case %0xF4 0xF4%, but some unexpected answer come up when i search for multi-byted charactors (Big5 or UTF-8 in that column.) which is simular to this example.. - Original Message - From: shiuwaitai [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. Hi, try to use varchar or varchar binary instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. I have tried that. MySQL match all rows i needed. But i match some row i don't want too.. let me show you an example... The charactor ¤¤ in Big5 chinese is 0xA4 0xA4. The charactor ¤ô is 0xA4 0xF4, ôô is 0xF4 0xF4. To match ôô, we should use %0xF4 0xF4%, which, in result, it match ¤ô¤¤ .. 0xA4 0xF4 0xA4 0xA4 too.. i just don't want this kind of cross-charactor match happend. Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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
Re: RE:Re: Localization..
- Original Message - From: shiuwaitai [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. Hi, try to use varchar or varchar binary instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. I have tried that. MySQL match all rows i needed. But i match some row i don't want too.. let me show you an example... The charactor ¤¤ in Big5 chinese is 0xA4 0xA4. The charactor ¤ô is 0xA4 0xF4, ôô is 0xF4 0xF4. To match ôô, we should use %0xF4 0xF4%, which, in result, it match ¤ô¤¤ .. 0xA4 0xF4 0xA4 0xA4 too.. i just don't want this kind of cross-charactor match happend. Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? == ·s®ö§K¶O¹q¤l«H½c http://sinamail.sina.com.hk - 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
Re: Localization..
Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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 == ·s®ö§K¶O¹q¤l«H½c http://sinamail.sina.com.hk - 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
Re: Localization..
Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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
Re: Localization..
Date |Wed, 8 Aug 2001 03:05:20 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC Yes, i have read that too. SC that tell me how to compile mysql with multi charset, SC but not create such kind of table. SC i expect there is somthing like SC CREATE TABLE tbl_name ( SC col_name type CHARSET=char_set, SC col_name2 type CHARSET=char_set2 ) ... SC CREATE DATABASE db_name DEFAULT_CHARSET=char_set SC where can i find these? Aha. so, i think nowhere. You can't do that. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re: Localization..
Date |Wed, 8 Aug 2001 03:05:20 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC Yes, i have read that too. SC that tell me how to compile mysql with multi charset, SC but not create such kind of table. SC i expect there is somthing like SC CREATE TABLE tbl_name ( SC col_name type CHARSET=char_set, SC col_name2 type CHARSET=char_set2 ) ... SC CREATE DATABASE db_name DEFAULT_CHARSET=char_set SC where can i find these? Aha. so, i think nowhere. You can't do that. Can anyone tell me what exactly --with-extra-charset do? I can compile those charset in, but not use them? Or that's just for a localized error message? I think mysql have somthing like postgresql's CREATE DATABASE db_name ENCODEING=encode;. - 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
Re: Localization..
- Original Message - From: Grigory Bakunov [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 1:16 PM Subject: Re: Localization.. Date |Tue, 7 Aug 2001 04:01:17 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have a table which contain data of some different charsets, SC some of them are multi-byte character.. SC They are currently stored in raw, binary format.. SC In order to make % match those multi-byte characters correctly, SC I am planning to convect the table format to correct charset. SC However, i cannot find any infomation on how to create a table SC with multi-charsets. May anyone give me some hints here? Look here: http://www.mysql.com/doc/L/o/Localization.html And here: http://www.mysql.com/doc/M/u/Multi-byte_characters.html I have read these docs. I can't find any charset option in CREATE TABLE syntax. - 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
Re: Localization..
Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re: Localization..
Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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
Re: Localization..
Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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
Localization..
I have a table which contain data of some different charsets, some of them are multi-byte character.. They are currently stored in raw, binary format.. In order to make % match those multi-byte characters correctly, I am planning to convect the table format to correct charset. However, i cannot find any infomation on how to create a table with multi-charsets. May anyone give me some hints here? - 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
Re: Localization..
Date |Tue, 7 Aug 2001 04:01:17 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have a table which contain data of some different charsets, SC some of them are multi-byte character.. SC They are currently stored in raw, binary format.. SC In order to make % match those multi-byte characters correctly, SC I am planning to convect the table format to correct charset. SC However, i cannot find any infomation on how to create a table SC with multi-charsets. May anyone give me some hints here? Look here: http://www.mysql.com/doc/L/o/Localization.html And here: http://www.mysql.com/doc/M/u/Multi-byte_characters.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re[2]: Localization with MySQL
This is how I did it on http://kuehnle.de I don't rely on browser information, though. I let users make their choice. I didn't try to find a single solution for all purposes. Instead, I have a general translation table 'strings' for words or sentences that normally would appear in my code and then other tables with specialized content, i.e. a table for the menu structure, another for the short description for the carriages with a varchar field, then one with the long description for the same article, this time a text field etc. If we chose to add another language, I would have to add a new column to all these tables, which is not that much of an effort. This could have been constructed better, using a key field with the language code instead of separate columns. The translations can be handled by home working people using their browser. I have a table 'workLog' which logs their activity. They have to be identified, using a simple password dialog. I store the info in a cookie, so they don't have to bother more than once. They get a simple form on screen with the text to be translated and their input in their respective language. We didn't have trouble yet, but if the context of the text was needed, I could provide that, too. The code makes sure that there is a fallback mode. If the user chooses French and there is no Franch translation yet, the code will look for English. If there is no English, it will take German. I made a CMS system for another customer, where everything is steered by the menu table. He has plans for the full fledged menu, but only few are ready. The menu is stored in the menu table. The moment he adds (German) content to that menu item, it will appear for the surfer in German, no matter what language they chose. His translators can add the translations likewise later. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Localization with MySQL
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
Re: Localization with MySQL
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.
Localization
I sent this a couple of weeks ago at the time I joined the list, but I didn't see it. Please excuse if it is a duplicate, but I still need to know the answer. I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyone suggest how to translate the login dialog screen and other messages in libmysql.dll? Is there already a French version around? Thanks. Lisle Robins
Localization
I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyone suggest how to translate the login dialog screen and other messages in libmysql.dll? Is there already a French version around? Thanks. Lisle Robins
