batch file created in Notepad and saves as UTF-8 shows strange characters.

[Nina Small]

Hi,

I have set all the system variables that are retrieved with the following statement show variables like 'character_set%' to utf8.

I create a statement insert into TST values ('друштво'); and save it in Notepad as utf8 (tried with Unicode as well), but I fail to insert as it seems some strange characters appear. When I issue

mysql > source myfile.sql I get ERROR 1064 etc..

and my cyrillic text is replaced by some strange characters.

All I need to do is create a batch file with insert statements containing values in cyrillic and insert that data in my table. My TST table is InnoDB and the character sets are UTF8

Thanks.