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]
