collation - SQL Server displaying query results as odd characters -
when attempt write data sql server db website:
http://kgd.gov.kz/en/wanted?page=0
the fields display this:
удоÑтоверение личноÑти â„–024806818 от 19.01.2010 МЮ РК
my server's collation set `sql_latin1_general_cp1_ci_as. fields set nvarchar(max)
how can display these characters correctly? pull data site appears in russian (i think these russian characters?) , display correctly.
i'm on sql server 2012. have researched on s/o , 2 threads found did not offer valid solution.
thanks.
Comments
Post a Comment