Lỗi Tiếng Việt khi thêm dữ liệu trong SQLServer - Wrong encoding when insert utf8 string into SQLServer

UPDATE t SET t.city_name = 'Long Hoàng Giang' FROM user t WHERE t.city_name = 'Long Hoang Giang';

Then when you select the result will like this 'Long Ho?ng Giang'.

Solution: Add N character before string which you want to insert or update

This bellow is correct query:

UPDATE t SET t.city_name = N'Nghệ An' FROM branch_atm_trans t WHERE t.city_name = N'Nghệ an';