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]
