import CSV file with Spanish Accents

[manikandan muthuraj]

Hello,

I need to import a CSV file into my table with Spanish Accents. Tried to import, but the spanish accents are not inserting into the table. I've already applied "SET NAMES UTF-8" and the table Collation as utf8_general_ci. Here is my create query of the table,

CREATE TABLE `v_customer_master` (
`cus_master_id` int(10) NOT NULL auto_increment,
`cus_type` varchar(255) NOT NULL,
`company_name` varchar(255) NOT NULL,
`job_title` varchar(150) NOT NULL,
`name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`dob` varchar(30) NOT NULL,
`tax` varchar(30) NOT NULL,
`email` varchar(255) NOT NULL,
`alternate_email` varchar(255) NOT NULL,
`security_question` varchar(255) NOT NULL,
`answer` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
`pwd` varchar(255) NOT NULL,
`country` varchar(150) NOT NULL,
`state` varchar(150) NOT NULL,
`city` varchar(255) NOT NULL,
`address1` varchar(255) NOT NULL,
`address2` varchar(255) NOT NULL,
`zipcode` varchar(20) NOT NULL,
`phone1` varchar(20) NOT NULL,
`phone2` varchar(20) NOT NULL,
`mobile` varchar(15) NOT NULL,
`fax` varchar(20) NOT NULL,
`website` varchar(255) NOT NULL,
`note` text NOT NULL,
`hear_about` varchar(255) NOT NULL,
`activity_type` varchar(255) NOT NULL,
`no_of_emp` varchar(255) NOT NULL,
`newsletter` varchar(250) NOT NULL,
`sp_discount` varchar(250) NOT NULL,
`friend_name` varchar(255) NOT NULL,
`friend_email` varchar(255) NOT NULL,
`account_type` varchar(250) NOT NULL,
`business_type` varchar(150) NOT NULL,
`tax_zone` varchar(250) NOT NULL,
`discount` float NOT NULL,
`currency` varchar(250) NOT NULL,
`language` varchar(250) NOT NULL,
`photo` varchar(255) NOT NULL,
`small_logo` varchar(255) NOT NULL,
`big_logo` varchar(255) NOT NULL,
`sign` varchar(255) NOT NULL,
`assigned_to_master_dist` varchar(250) NOT NULL,
`assigned_to_dist` varchar(250) NOT NULL,
`assigned_to_agent` varchar(250) NOT NULL,
`assigned_to_engineering` varchar(255) NOT NULL,
`customer_status` varchar(255) NOT NULL,
`reg_date_time` varchar(250) NOT NULL,
`last_login_date_time` varchar(250) NOT NULL,
PRIMARY KEY (`cus_master_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23101 DEFAULT CHARSET=utf8


Can anyone assist me how to go with that.. and explain me briefly how to import the spanish accents into my table.

Thanks in advance.