Issue Inserting hebrew in mysql table from a batch file
<p>When i run the sql script, the hebrew data in mysql table appears to be garbage like <code>"ÎíÎ£ÎòÎæÎºÎÖÎö ,ÎÆÎƒ ÎöÎóÎôÎƒ Î®Î£ ÎÉÎÖÎ¿ÎòÎñÎö".</code></p>

<p>the table collation is <code>**utf8_general_ci**</code> in table as well as database.</p>

<p>Here is my sql script</p>

<pre><code>CREATE TABLE IF NOT EXISTS `tbl_lang` (
  `name` varchar(250) NOT NULL,
  `hebrew` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tbl_lang` (`name`, `hebrew`) VALUES
('Title', 'סלובקיה ,גן העדן של אירופה'),
('Form', 'טופס הצעת מחיר');
</code></pre>

<p>Any help will be appreciated. Thank you.</p>