SQL query with Unicode character in the middle

Question

I have question to update issue with unicode character -

character á has unicode U+00E0 But how to do it in the middle of String?

update `table` set 
`column` = "String with á sign in the middle"
where
`Column` = .......

How does the string with unicode á look like?

Thanks

let say - I would like to put "String with á sign in the middle" this á - how to do it with Unicode? — DRastislav, Feb 05 '14 at 13:43
UPDATE `test`.`test` SET `name` = 'String with á sign in the middle' WHERE `test`.`name` = '33333' LIMIT 1 ; this is working fine — Nanhe Kumar, Feb 05 '14 at 13:46
possible duplicate of [MySQL unicode literals](http://stackoverflow.com/questions/3632410/mysql-unicode-literals) — Marcus Adams, Feb 05 '14 at 13:53
hi Marcus, Iam able to write á as ASCII, but it doesn´t work :( — DRastislav, Feb 05 '14 at 13:57
Then see this one too: http://stackoverflow.com/questions/279170/utf-8-all-the-way-through — Marcus Adams, Feb 05 '14 at 13:59

Mahmoud.Eskandari · Accepted Answer · 2018-11-04T13:48:46.587

1

Send this query before your main query:(for setting the connection charset)

mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'") or die();

it's maybe helping you.

edited Nov 04 '18 at 13:48

answered Feb 05 '14 at 13:45

Mahmoud.Eskandari

1,460
3
20
32

Maybe stupid question - Isnt there no possibility to put \U+00E0 instead of á sign ? e.g. "String with \U+00E0 sign in the middle" – DRastislav Feb 05 '14 at 13:46
I know it,Do you want I delete my Answer?? – Mahmoud.Eskandari Feb 05 '14 at 13:51
You can if you want :) – DRastislav Feb 05 '14 at 13:52
[MySQL documentations](http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_character_set_database) says you shouldn't set `character_set_database` directly. – Marcus Adams Feb 05 '14 at 13:58

SQL query with Unicode character in the middle

1 Answers1