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

Unable to Insert Arabic words in mysql table
Unable to Insert Arabic words in mysql table I have I java program that I want to insert arabic letters in mysql. Do you have any idea about the configuration of mysql that accepts arabic charcters. in jsp use

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

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

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

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

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

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 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

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

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 to connect mysql with jsp
How to connect mysql with jsp how to connect jsp with mysql while using apache tomcat

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

How to start learning MySQL?
How to start learning MySQL? Hello developers, I am total beginner... and want to learn MySQL. How to start learning MySQL? Which are good tutorials... at How to download and install MySQL on Windows 10? You can learn SQL from

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 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 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

How to get factorial in mysql
How to get factorial in mysql Hi, In order to improve the speed of my queries, one in particular tries to find matches between multiple tables, I... alot for a function in mysql to find factorial numbers of a number and couldn't

MySQL How to Topic
MySQL How to Topic How to installation mysql window 2000 and window XP http... database in mysql? How to create a table in mysql

How to use between in mysql.
How to use between in mysql. I want to display records inbetween two dates and also want to use where condition( like and deptname='Pediatry Department'). Syntax: SELECT column_name(s) FROM table_name

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

How do I upgrade mysql?
How do I upgrade mysql? How do I upgrade mysql

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

ModuleNotFoundError: No module named 'arabic-pronounce'
named 'arabic-pronounce' How to remove the ModuleNotFoundError: No module named 'arabic-pronounce' error? Thanks Hi, In your...ModuleNotFoundError: No module named 'arabic-pronounce' Hi, My

ModuleNotFoundError: No module named 'arabic-pronunciation'
: No module named 'arabic-pronunciation' How to remove the ModuleNotFoundError: No module named 'arabic-pronunciation' error? Thanks Hi...ModuleNotFoundError: No module named 'arabic-pronunciation' Hi

Ads