Hi,
I'm trying to set up an ASP website that works in both Russian and
English. The forms on the website should capture data, and write it off
to MySQL. At the moment, I am having a lot of trouble with russian
text, and it seems whatever I do, MySQL does not capture it correctly.
I am running MySQL 5 and MyODBC 3.51. The data appears correct on the
webpage, and looks fine in the SQL commands, but if I try to insert
data into the database, it appears as four digit character strings,
rather than cyrillic. I have set my database to use the koi8r character
set in the config wizard, and I have also set my MyODBC connection to
issue a "set character set koi8_cp1251" command on connection, but
neither of these have helped.
I really don't know what to try next. Does anyone have any suggestions?