How to load Arabic csv to MYSQL

I tried the following

set session collation_database=utf8_general_ci;
set session character_set_database=utf8 ;
#SET NAMES utf8;
#SET character_set_database=utf8;

LOAD DATA local INFILE "D:\\trade20120314.csv"
INTO TABLE trade
CHARACTER SET utf8
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n' ;
but the arabic columns still appears as "?????? ????????????????".

I am sure that the csv file is encoded to utf8 and the default character set of server and client is as utf8 and also the columns character set and collation as utf8 .

I don't know where is the problem , any suggestions .

Thanks .

View Answers

Ads

Advertisements

how to load pdf on html
how to load pdf on html how to load pdf on html

insert arabic chacters in mysql via java - Java Interview Questions
insert arabic chacters in mysql via java Dear, I have I java rpogram that I want to insert arabic letters in mysql. Do you have any idea about the configuration of mysql that accepts arabic charcters. I will send you

Mysql CSV
file into database. Mysql CSV is used to load the text file and add to the table... Mysql CSV ... provides you an elaborate example on Mysql CSV. To understand and grasp example, we

Exporting data from mysql to csv file
Exporting data from mysql to csv file Hi friends.... I want to export the data from mysql to csv file... i am having 30 columns in my database.. Eg- text1,text2,text3,....,upto text30... i want to export this data in csv file

How to write into CSV file in Java
How to write into CSV file in Java How to write into CSV file in Java Hi, To create Comma separated value(CSV) file is very simple... Object to PrintWriter instance. How to create File to CSV in Java

php csv file uploding into mysql database table.
php csv file uploding into mysql database table. hai friends, i... fields. i have one mysql database table with two files fields, when ever i am uploding csv file, i want to fetch the datas in corresponding fields in table. can

Exporting data from mysql into csv using jsp
Exporting data from mysql into csv using jsp Hi friends.... I want to export the data from mysql to csv file using... i am having 30 columns in my... in csv file..if i export, am getting the csv file with all data in one row

upload csv to mysql db using jsp upload
upload csv to mysql db using jsp upload Hello all, Please give me the code to uplad .csv from jsp page and insert values into MySQl db. I have a table with 8 cloumns.(MDN--varchar(30),Otafdate date,crt varchar(30),dmdn

how to convert .xml file to csv file
how to convert .xml file to csv file how to convert .xml file to csv file

How create csv format in jsf ?
How create csv format in jsf ? Dear Friends , Good morning to all of you? I have a problem to create .CSV format in jsf. Actully I have... the pdf file now I want to create .csv format using this data ? Please Help me

How do I import a CSV file in R?
How do I import a CSV file in R? Hi, I have a CSV file with 900000 records and I want to load it for analytics. How do I import a CSV file in R... files, csv files, xml files, etc.. Here is example of loading the data from csv

PHP code for csv file upload into mysql
PHP code for csv file upload into mysql I want to upload a file from my pc to mysql server using upload option. while i m selecting the csv file it ll be upload the mysql database. can u send me the coding? i have tried

create dropdown cell in csv or excell from mysql data in php
create dropdown cell in csv or excell from mysql data in php Hello sir i want to create drodown cell in csv from mysql data is this is possible or not? if this is posible please share answer or reference link Thanks

How will you load a specific locale? - Java Beginners
How will you load a specific locale? HI, Please tell me how to load a specific locale in Java program. Thanks Hi Friend, You can use ResourceBundle.getBundle("Locale.UK"); For more information, visit

how to parse a csv file using standard libraries?
how to parse a csv file using standard libraries? hie i am a beginner in java i want to parse a csv file using any standard libraries i want to know how the libraries are imported and used in eclipse thanks in advance

how many ways to load the class in java
how many ways to load the class in java i know some ways to load the class. could plz tell the all the ways. there r 3 ways to create objects. 1.by using new operator 2.clone() method 3.new Instance(). and some

How to load file from the directory in J2ME?
How to load file from the directory in J2ME? Video player J2ME. I have a folder name "music". I want to display all file with extension is "*.mpg" on the List. How can I do it, plz help me

how to export the query result in SQL Server to .csv file?
how to export the query result in SQL Server to .csv file? how to write table data into CSV file using SQL SERVER 2008

how to sort multiple key columns in CSV file - Java Beginners
how to sort multiple key columns in CSV file Hi Any one can assist how to sort the multiple key columns in CSV file? Any example will be appreciated. Thanks

how to display csv file directly in IE browser .
how to display csv file directly in IE browser . here is my code : public String download(){ if(log.isDebugEnabled()){ log.info...");` response.setContentType("application/csv"); response.setHeader("Cache-Control

How to load elements from db when i press next.
How to load elements from db when i press next. Hello , I am working... at a position. I am using MySql at back end ,. My query is:- Suppose I clicked a link... page. Hope you got my point , please help me, I am unable to understand how to do

How to connect mysql with jsp
How to connect mysql with jsp how to connect jsp with mysql while using apache tomcat

how to load a table of data from oracle, to a jsp page using hashmap.
how to load a table of data from oracle, to a jsp page using hashmap. I have a jsp page which ask for project ID,team name,member name according to this data i have to retrieve their details from the database(oracle). I have

how to load values of html form into an excel table using java servlet?
how to load values of html form into an excel table using java servlet? i have written a java servlet program, which has a html form to be filled. after filling the form the servlet generates a receipt and the values should

language conversion from english to arabic in a struts project
language conversion from english to arabic in a struts project how to convert struts project to arabic language from english language without using... also into english language from arabic language Please visit

How to save form data to a csv file using jquery or ajax
How to save form data to a csv file using jquery or ajax Please let me know more about how to do this or please suggest me any sites to learn... this. i am able to read the csv file using this code if (window.XMLHttpRequest

How to connect to MySQL in JSP?
How to connect to MySQL in JSP? How to connect to MySQL in JSP..., You can use the Java JDBC code to connect to MySQL database in JSP page. Check the tutorial: Connect JSP with mysql Thanks

SQL Bulk Insert csv
SQL Bulk Insert csv ... to the same format table in a Mysql database. Understand with Example The Tutorial covers an example from 'SQL Bulk Insert CSV'.To understand and grasp this example

How alter table in MySQL?
How alter table in MySQL? Hi, I have a table and I want to alter an int field into text field. How to alter the table in MySQL? Thanks ... varchar(100); Check the tutorial Mysql Alter Column Datatype. Check more

Ads