How to load Arabic csv to MYSQL

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









Related Tutorials/Questions & Answers:
How to load Arabic csv to MYSQL
How to load Arabic csv to MYSQL  I tried the following set session... ; #SET NAMES utf8; #SET character_set_database=utf8; LOAD DATA local INFILE... BY ',' LINES TERMINATED BY '\r\n' ; but the arabic columns still appears
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
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      ... The Tutorial provides you an elaborate example on Mysql CSV. To understand
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
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 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 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 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 convert .xml file to csv file
how to convert .xml file to csv file  how to convert .xml file to csv file
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
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
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
ModuleNotFoundError: No module named 'arabic-reshaper'
named 'arabic-reshaper' How to remove the ModuleNotFoundError: No module named 'arabic-reshaper' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'arabic-reshaper'  Hi, My
ModuleNotFoundError: No module named 'arabic-reshaper'
named 'arabic-reshaper' How to remove the ModuleNotFoundError: No module named 'arabic-reshaper' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'arabic-reshaper'  Hi, My
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
ModuleNotFoundError: No module named 'arabic-reshaper'
named 'arabic-reshaper' How to remove the ModuleNotFoundError: No module named 'arabic-reshaper' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'arabic-reshaper'  Hi, My
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 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
ModuleNotFoundError: No module named 'arabic-reshaper-fork'
: No module named 'arabic-reshaper-fork' How to remove the ModuleNotFoundError: No module named 'arabic-reshaper-fork' error? Thanks   Hi...ModuleNotFoundError: No module named 'arabic-reshaper-fork'  Hi
ModuleNotFoundError: No module named 'arabic-reshaper-fork'
: No module named 'arabic-reshaper-fork' How to remove the ModuleNotFoundError: No module named 'arabic-reshaper-fork' error? Thanks   Hi...ModuleNotFoundError: No module named 'arabic-reshaper-fork'  Hi
ModuleNotFoundError: No module named 'dialectal-arabic-tools'
: No module named 'dialectal-arabic-tools' How to remove the ModuleNotFoundError: No module named 'dialectal-arabic-tools' error? Thanks   Hi...ModuleNotFoundError: No module named 'dialectal-arabic-tools'  Hi
ModuleNotFoundError: No module named 'arabic-reshaper-fork'
: No module named 'arabic-reshaper-fork' How to remove the ModuleNotFoundError: No module named 'arabic-reshaper-fork' error? Thanks   Hi...ModuleNotFoundError: No module named 'arabic-reshaper-fork'  Hi
ModuleNotFoundError: No module named 'dialectal-arabic-tools'
: No module named 'dialectal-arabic-tools' How to remove the ModuleNotFoundError: No module named 'dialectal-arabic-tools' error? Thanks   Hi...ModuleNotFoundError: No module named 'dialectal-arabic-tools'  Hi
ModuleNotFoundError: No module named 'franco-arabic-transliterator'
: No module named 'franco-arabic-transliterator' How to remove the ModuleNotFoundError: No module named 'franco-arabic-transliterator' error...ModuleNotFoundError: No module named 'franco-arabic-transliterator'  
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 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 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
SQL Bulk Insert csv
SQL Bulk Insert csv      ... to the same format table in a Mysql database. Understand with ExampleADS_TO_REPLACE_1 The Tutorial covers an example from 'SQL Bulk Insert CSV'.To understand and 
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 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 connect mysql with jsp
How to connect mysql with jsp  how to connect jsp with mysql while using apache tomcat
how to load value in dropdown list after selecting value from first dropdown list using javascript
how to load value in dropdown list after selecting value from first dropdown list using javascript  how to load value in dropdown list after selecting value from first dropdown list using javascript
ModuleNotFoundError: No module named 'load'
ModuleNotFoundError: No module named 'load'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'load' How to remove the ModuleNotFoundError: No module named 'load' error
nsstring load from file
nsstring load from file  Hi, How to load file data into NSString object? Example of nsstring load from file, basically the html file data into NSSTring object. Thanks
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
jQuery Ajax load request
jQuery Ajax load request  Hi, How to use jQuery to send the request on server to load data in web page? Thanks   Hi, In the jQuery Load... and then load the data in web page. Thanks
Unwanted characters instead of arabic characters
Unwanted characters instead of arabic characters  I am using... and using it to display. the problem is: I need to display some arabic characters here... صÙ?Ù?دÙ?Ù?Ø© سÙ?Ù?د Ù?Ù?Ù?Ù?Ù?أرب like characters instead of arabic
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 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

Ads