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.

View Answers

September 19, 2013 at 11:58 PM

in jsp use this <%@page language="java" contentType="text/html; charset=UTF-8"%>

In servlet use

request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8");

In mysql Change Setting

Alter table and Set charset=utf8 and collation=utfgenerelci

Enjoy


September 19, 2013 at 11:58 PM

in jsp use this <%@page language="java" contentType="text/html; charset=UTF-8"%>

In servlet use

request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8");

In mysql Change Setting

Alter table and Set charset=utf8 and collation=utfgenerelci

Enjoy

Ads









Related Tutorials/Questions & Answers:
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
insert excel sheet into mysql as a table
insert excel sheet into mysql as a table  sir, i want to import an excel sheet into mysql5.0 database as in the table format using tomcat 6.0 by jsp
Advertisements
How to insert data into MySQL Table?
How to insert data into MySQL Table?  Hi, How to insert the data into MySQL Database? Please explain me with the examples and videos thanks. Thanks   Hi, The insert into query is used to insert the data into MySQL
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
Mysql Insert
Mysql Insert       Mysql Insert is used to insert the records or rows to the table. Understand with Example The Tutorial illustrate an example from 'Mysql Insert'.To grasp
Query to insert values in the empty fields in the last row of a table in Mysql database?
Query to insert values in the empty fields in the last row of a table in Mysql database?  I have some fields filled and some fields empty in the last row of my MYSQL database. Now I want to fill up those empty fields in the last
Mysql Multiple Date Insert
Mysql Multiple Date Insert       Mysql Multiple Column Insert is used to add or insert... illustrate an example from 'Mysql Multiple Column Insert'.To understand
Mysql Multiple Date Insert
Mysql Multiple Date Insert       Mysql Multiple Column Insert is used to add or insert... illustrate an example from 'Mysql Multiple Column Insert'. To understand an example
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving...=ps1.executeQuery(); ps2 = con.prepareStatement( "insert
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving...=ps1.executeQuery(); ps2 = con.prepareStatement( "insert
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving...=ps1.executeQuery(); ps2 = con.prepareStatement( "insert
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving...=ps1.executeQuery(); ps2 = con.prepareStatement( "insert
How to load Arabic csv to MYSQL
How to load Arabic csv to MYSQL  I tried the following set session... "D:\\trade20120314.csv" INTO TABLE trade CHARACTER SET utf8 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' ; but the arabic columns still appears
Mysql Trigger After Insert
Mysql Trigger After Insert       Mysql Trigger After Insert fired the trigger after you perform an insert a records or rows to the table. Understand with Example
insert query in mysql
insert query in mysql  insert query in mysql not working   [INSERT INTO Birthdays(firstname, lastname, birthday, group) VALUES('Sam','Smith','June','Junior
Insert Records in Table
Insert Records in Table       The Insert data in Table is used to insert  records or rows into the table in database. The Syntax used to insert records into a table
how to insert one table to anothere table
how to insert one table to anothere table  i have insert the record one table then i retrve the value of that table i insert one value at a time
Inserting values in MySQL database table
insert values in the MySQL database table. We know that tables store data in rows and column format. After creating a database table, you need to insert... Inserting values in MySQL database table   
Mysql Table
Mysql Table       MySQL Create Table Here, you will read the brief description about the MySQL create table.    Mysql Add
How to insert image in MySQL database using sql query?
Insert image in MySQL database using sql query  ... in MySQL database and then used the query to insert the data... to insert image in MySQL database using sql query?": So, lets start
MySQL PHP Insert
MySQL PHP Insert       Mysql PHP Insert is used to execute the Mysql function ( ) insert.... Understand with Example The Tutorial illustrate an example on MySQL PHP Insert
mysql select into table from another table example
mysql select into table from another table example  Can you suggest the correct example of select into table from another table example in MySQL Database. Thanks   Hi, This statement is used to insert all the records
Getting mysql table in textbox
Getting mysql table in textbox  how to get mysql table values into textbox in java using ajax and servlets
example of before insert trigger in mysql
example of before insert trigger in mysql  Hi, How to create a simple before insert trigger in MySQL? Thanks   Hi, The before insert... in MySQL database server and executed on the server itself. So, its very fast. First
Unable to upload a file to mysql database using struts1
Unable to upload a file to mysql database using struts1  Hi, Below... fileSize=formFile.getFileSize(); int insert=0; try{ Class.forName...=DriverManager.getConnection("jdbc:mysql://localhost/test","root",""); System.out.println
Mysql Alter Table Syntax
Mysql Alter Table Syntax       Mysql Alter Table is used to redefine the existing table... into Table named employees: The Query insert into add the records or rows
java program to insert data into a file and count the number of words from the file???????
java program to insert data into a file and count the number of words from the file???????  java program to insert data into a file and count the number of words from the file
Mysql Alter Table
Mysql Alter Table       Mysql Alter Table is used to redefine the existing table. Understand with Example The Tutorial illustrate an example from 'Mysql Alter Table'. To grasp
Mysql From Table
Mysql From Table       Mysql From Table is used to specify the table from which the records...)); Insert Values into Stu Insert into is used to add the records or rows to the table

Ads