How to strore a non english string to mysql database from java application

Question

My question is about related to MySQL database.

Can any one help me to store a non English string from java application to MySQL database?

I tried in several ways. I changed the collisions of the database columns too. But when passed a non English string to the MySQL database, it shows a "???" mark in the table. Why is this happening?

When passed a English string, that is working fine. But when sending a non English string from the java application, that stores that non English string as a "?" mark on the database.

Can any one help me to resolve this issue?

Please share the java code.and also the show create table [table] statement — Raymond Nijland
– Raymond Nijland, Commented Nov 1, 2017 at 13:51
stackoverflow.com/a/3275661/984823 to communicate to the database in UTF-8 (Unicode). And the database / table / column must be defined for containing UTF8. stackoverflow.com/questions/202205/… — Joop Eggen
– Joop Eggen, Commented Nov 1, 2017 at 17:24

user4812550 · Accepted Answer · 2017-11-01 13:50:07Z

0

yu need t change table collection to utf8_genereal_ci or any of this utf8 collection, also in columt data type to string r long string

answered Nov 1, 2017 at 13:50

user4812550

Sign up to request clarification or add additional context in comments.

3 Comments

Osanda Rajapakse Over a year ago

I have already used the collasions that you have mentioned. But I used varchar as the datatype of the column. So, will datatype "varchar" affect ?

user4812550 Over a year ago

i ve never used as varchar but as string and longstring and spanish character are welcome like this ñ or this á

Osanda Rajapakse Over a year ago

Ok. I will try and will let you know the progress. Btw, thanks a lot for your big help.

SQL.RK · Accepted Answer · 2017-11-01 13:54:15Z

0

Please use UTF8 or UTF8MB4 as character set of the MySQL and chactersetEncoding as utf8 in case you are using JDBC connection from Java Application.

answered Nov 1, 2017 at 13:54

SQL.RK

1574 bronze badges

3 Comments

Osanda Rajapakse Over a year ago

Hi, I tried with most of the collasions like above mentioned. But no luck. :(

SQL.RK Over a year ago

Have you tried charactersetEncoding in JDBC connection?

Osanda Rajapakse Over a year ago

Can you please show me how to set chactersetEncoding as utf8 ? Please. It would be big help for me.

Collectives™ on Stack Overflow

How to strore a non english string to mysql database from java application

2 Answers 2

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related