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';