MySQL Forums
Forum List  »  CSV Storage Engine

import CSV file with Spanish Accents
Posted by: manikandan muthuraj
Date: September 13, 2010 09:57AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
import CSV file with Spanish Accents
6490
September 13, 2010 09:57AM


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.