csv import into MySQL using load-infile causes major character encoding issues
===

I've got a csv file, that I'm opened in Excel and checked the data.
I then save that csv and import it to my MySQL DB using load infile.

When I view the import via PHPMyAdmin, it seems OK, but a few characters are off. however, when I EDIT a row, All I see is:
�h�t�t�p�:�/�/�v�k�.�c�o�m�/�v�i�d�e�o�2�5�0�2

Not good.

So, I googled about and learned that Excel saves as 'unicode'. My DB info is::

    Storage engine: InnoDB
    Collation: utf8_unicode_ci

Is there a standard way of having the csv be compatible with my DB.. or visa versa?

This encoding is causing issues will my whole site :(

Here's my SQL:
I'm using Xampp locally and this will end up on an IIS machine :(

          load data local infile 'mvcsv.csv'
            IGNORE
            into table `mytable`
            CHARACTER SET UTF8
            fields terminated by '\\t'
            lines terminated by '\\n'
            IGNORE 1 LINES
            (" . substr($column, 0, -2) . ")