Re: translation dictionary
I guess you'd have to use MySQL 4.1 to assign different character sets to different columns. Should be straight-forward at time of table creation. David *** Hello, I'm interested in building a translation dictionary: russian - french. My database would have only one table which contains in each entry a the word and its translation. I intend to put such a dictionary on a web page. I would like to ask for some ideas on how to build such a dictionary given that I can not use more than one set of characters in mysql server. ( the russian words need on set of characters , the french ones another ). I would appreciate any hint. kind regards, Felix - 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: translation dictionary
You can try UTF-8. - Cs. I guess you'd have to use MySQL 4.1 to assign different character sets to different columns. Should be straight-forward at time of table creation. David *** Hello, I'm interested in building a translation dictionary: russian - french. My database would have only one table which contains in each entry a the word and its translation. I intend to put such a dictionary on a web page. I would like to ask for some ideas on how to build such a dictionary given that I can not use more than one set of characters in mysql server. ( the russian words need on set of characters , the french ones another ). I would appreciate any hint. - 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: translation dictionary
On 14 Mar 2003, at 0:28, felix t wrote: I would like to ask for some ideas on how to build such a dictionary given that I can not use more than one set of characters in mysql server. ( the russian words need on set of characters , the french ones another ). Presumably you're using Unicode, so that you can display both French and Russian on the same page. It might work for you to store the words as plain binary data in your tables, since the character set is relevant mostly for sorting and you won't be doing that unless you're going to allow browsing through the dictionary entries as opposed to looking up individual ones. You'd also have to take care of letter case in your application rather than in MySQL, so that you can store your values as (for example) all lowercase and then convert your search string to lowercase before putting it into your query. I haven't actually done anything with character sets yet, so I could be missing an important point. Maybe someone with more experience will chime in if I have. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - 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: translation dictionary
At 10:13 -0500 3/14/03, Keith C. Ivey wrote: On 14 Mar 2003, at 0:28, felix t wrote: I would like to ask for some ideas on how to build such a dictionary given that I can not use more than one set of characters in mysql server. ( the russian words need on set of characters , the french ones another ). Presumably you're using Unicode, so that you can display both French and Russian on the same page. It might work for you to store the words as plain binary data in your tables, since the character set is relevant mostly for sorting and you won't be doing that unless you're going to allow browsing through the dictionary entries as opposed to looking up individual ones. You'd also have to take care of letter case in your application rather than in MySQL, so that you can store your values as (for example) all lowercase and then convert your search string to lowercase before putting it into your query. I haven't actually done anything with character sets yet, so I could be missing an important point. Maybe someone with more experience will chime in if I have. One important point is that binary values are not associated with a character set. :-) For example, BLOB columns don't have a charset. TEXT columns do. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - 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
translation dictionary
Hello, I'm interested in building a translation dictionary: russian - french. My database would have only one table which contains in each entry a the word and its translation. I intend to put such a dictionary on a web page. I would like to ask for some ideas on how to build such a dictionary given that I can not use more than one set of characters in mysql server. ( the russian words need on set of characters , the french ones another ). I would appreciate any hint. kind regards, Felix ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.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