insert query for mysql convert() using the tomcat

[zita lakshmi]

Hi


I need insert query for mysql convert() using the tomcat

 

st1.executeUpdate("Insert into arabiccontent1(`id`,`name`)value convert('"+id+"','"+name+"')using utf8)");
   

it have error.


so any one of them help me

[Rob Spoor]

Shouldn't you convert each column separately?

st1.executeUpdate("Insert into arabiccontent1 (`id`, `name`) values (convert('" + id + "') using utf8, convert('" + name + "') using utf8)");

Moving to JDBC.

[Lorand Komaromi]

zita lakshmi wrote:it have error.

And what does the error say..?

[zita lakshmi]

hi

Thanks for your reply. I have using for the following code

 
st.executeUpdate("Insert into arabiccontent (`id`, `name`) values (convert('" + id + "') using utf8, convert('" + name + "') using utf8)");
   

but it have the following error message.

Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') using utf8, convert('اليتا') using utf8)' at line 1"

how can i insert the arabic data properly. please help me.

[zita lakshmi]

hai

Manually i tried to insert the data in mysql. but i have following error.



Error

SQL query:

INSERT INTO arabiccontent( `id` , `name` )
VALUES (
convert( "444" )
USING utf8, convert( "وكيل إدارة" )
USING utf8
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') using utf8, convert("وكيل إدارة") using utf8)' at line 1



Please help me

[Prabhat Jha]

Which OS are you running on and what is the version of MySQL that you are using ? MySQL 4.x had similar problems.

Just to double check that your version supports Arabic can you check SHOW CHARSET shows you arabic or not ?

Thanks

[zita lakshmi]

hi


Mysql accept arabic charset.


Os version is window XP