batch file created in Notepad and saves as UTF-8 shows strange characters.
Posted by: Nina Small
Date: July 19, 2007 03:12AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
batch file created in Notepad and saves as UTF-8 shows strange characters.
6370
July 19, 2007 03:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.