Re: Using multiple character sets (Russian English)
Egor, Thank you for the response. You are the perfect person to answer my questions regarding Russian character sets. :) I two follow-up questions: 1. Will this work even though I am using two different character sets? I just want to be clear on what I am describing: one column of my table will contain English words (Latin1?) and the other column will contain the words written in Russian (Cyrillic fonts). It will not be Russian words written with Latin letters. 2. I have done some research since I first posted my question and I have read that I need MySQL v4.1 to support multiple character sets. I am using v3.23.57-Max. Have you used MySQL for multiple character sets in the same table for versins prior to 4.1? Again, thank you for your assistance, Egor, and for anyone else who may be able to assist. Best regards, Rachel. --- Egor Egorov [EMAIL PROTECTED] wrote: Rachel Rodriguez [EMAIL PROTECTED] wrote: I have experience using MySQL and SQL commands in general, but I am going through my first experience with working with multiple character sets. I am working on a Russian/English translation project and I'd like to create a table where column1 contains words in Russian and column2 contains the word translated into English. Russian character set should be cp1251, which I have confirmed is installed on the MySQL server (3.23.57-Max running on Linux). At this time, it is not possible for us to upgrade beyond this version of the MySQL server. How do I issue SQL commands in English: (insert into TableName values...) values that are of type varchar in both Russian and English: (null, cyrillic_russian_word, english_word); You can do it as you wrote above :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using multiple character sets (Russian English)
Just an update (but a good one): I have this working now if I issue all of my SQL statements direct from the MySQL monitor. Egor was 100% correct that this can be done. As a native English speaker, I was confused on how MySQL would handle characters that were not of the Western European type since this is my first time trying this. I have an off-topic question for those on the list that use scripts with mixed character sets for the values: Our MySQL server is running on Linux, but I am doing my development on Windows 2000. I want to now create a .sql script to issue all of my commands to create my tables and populate the tables. I've done this many times (in English) with no problems, but now that some of my values contain words written in Cyrillic, the MySQL server will not display them correctly when I do a select query afterwards. I am using Notepad and saving as UNICODE format. Does anyone have a suggestion for a text editor under Windows, or an encoding that I should be using other than UNICODE to preserve my Cyrillic words? Or does the problem not exist in the text editor? I just can't handle the idea of sitting at the MySQL monitor and issuing each insert command for my Russian words and my English translations. Help! :) Thank you again. Rachel. --- Rachel Rodriguez [EMAIL PROTECTED] wrote: Egor, Thank you for the response. You are the perfect person to answer my questions regarding Russian character sets. :) I two follow-up questions: 1. Will this work even though I am using two different character sets? I just want to be clear on what I am describing: one column of my table will contain English words (Latin1?) and the other column will contain the words written in Russian (Cyrillic fonts). It will not be Russian words written with Latin letters. 2. I have done some research since I first posted my question and I have read that I need MySQL v4.1 to support multiple character sets. I am using v3.23.57-Max. Have you used MySQL for multiple character sets in the same table for versins prior to 4.1? Again, thank you for your assistance, Egor, and for anyone else who may be able to assist. Best regards, Rachel. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using multiple character sets (Russian English)
Hello, I have experience using MySQL and SQL commands in general, but I am going through my first experience with working with multiple character sets. I am working on a Russian/English translation project and I'd like to create a table where column1 contains words in Russian and column2 contains the word translated into English. Russian character set should be cp1251, which I have confirmed is installed on the MySQL server (3.23.57-Max running on Linux). At this time, it is not possible for us to upgrade beyond this version of the MySQL server. How do I issue SQL commands in English: (insert into TableName values...) values that are of type varchar in both Russian and English: (null, cyrillic_russian_word, english_word); Any guidance is appreciated. Thank you. Sincerely, Rachel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Thoughts on MySQL training?
Many thanks to all for responding to my query regarding MySQL training. Your honest opinions were greatly appreciated! BTW, the general consensus was that it was quality training and worth the price. Thank you, Rachel __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thoughts on MySQL training?
I was wondering if anyone on the list has attended any of the training listed on the mysql.com site. If yes, was it worth the costs in your opinion? I'm trying to justify the costs to my management. Thank you, Rachel = __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Thoughts on MySQL training?
I should have been more specific: we're looking at the Using and Managing MySQL training. Opinions appreciated. ~RR --- Rachel Rodriguez [EMAIL PROTECTED] wrote: I was wondering if anyone on the list has attended any of the training listed on the mysql.com site. If yes, was it worth the costs in your opinion? I'm trying to justify the costs to my management. Thank you, Rachel = __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Thoughts on MySQL training?
I should have been more specific: we're looking at the Using and Managing MySQL training. Opinions appreciated. ~RR --- Rachel Rodriguez [EMAIL PROTECTED] wrote: I was wondering if anyone on the list has attended any of the training listed on the mysql.com site. If yes, was it worth the costs in your opinion? I'm trying to justify the costs to my management. Thank you, Rachel = __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]