making SQL update query

Question

i have sql table of columns id,version,setting_key,setting_value

and i want to change the default_encodingfrom LATIN1to UTF8for all mcs(13 or 14 or 15 or .. )

i made this

UPDATE bo_user_setting SET setting_value = 'UTF8' WHERE setting_key = 'DEFAULT_ENCODING';

but it doesn't work .. any help ??

thanks in advance

do you want to execute this query in java or do you want to know whether this query is correct or not — Boola, Jun 23 '16 at 11:08
@Boola yess i am executing it in java and nothing happen to the table — mmm mmm, Jun 23 '16 at 11:13

score 0 · Answer 1 · answered Jun 23 '16 at 11:09

0

You need alter table not update

  ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;

answered Jun 23 '16 at 11:09

ScaisEdge

1 Answers1