Korean (and other Unicode) characters in SQL Server 2008 R2 not displaying correctly in query results -

-

i have database needs hold data in variety of languages , alphabets. using default latin collation, text fields of unicode variety (nchar, nvarchar).

i can happily insert , retrieve unicode data database using front-end application, if view data using ssms see gibberish!

i can insert this:

극단적으로

which looks in ssms:

극단ì ìœ¼ë¡œ

but retrieved front end application this:

극단적으로

now data being stored ok, why ssms display gibberish? interestingly if use ssms edit data directly , paste in above displays (edit: turns out switching results grid text aleviates part of problem proper text displayed instead of boxes.): 

□□□□□

but if copy , paste text editor comes out as:

극단적으로

in attempt see if ssms misbehaving (/misconfigured me) used ms access , linked sql server database, displays same gibberish sql server.

this database hold static text web application, important me able view , edit data easily, not done when can see this:

극단ì ìœ¼ë¡œ

any suggestions great, stuck on this.

edit

this example of data insertions, have done in php @ moment:

$con = sqlsrv_connect("(local)", array("database" => "mydatabase")); $sql = "insert tablename (col1,col2) values (n'극단적으로',n'극단적으로')"; sqlsrv_query($con,$sql);

and example of data retrieval:

$sql = "select col1,col2 tablename"; $rs = sqlsrv_query($con,$sql); while($row = sqlsrv_fetch_array($rs)){     echo $row["col1"]." ".$row["col2"]."\n"; }

this results in being output php:

극단적으로 극단적으로

but data displayed gibberish in output window of ssms if run select on table.

i know old question, see no resolution problem, i've started encountering same problem in ssms. don't believe issue php encoding, based on edit regarding if results viewed text instead of grid problem resolved (i experience same behavior). think issue in ssms , encoding of grid output, given ssms can correctly display korean characters when viewed text.

i've managed fix issue in ssms changing font "arial unicode ms". have noticed issue has occured in other applications particularly text editor such notepad++ , notepad.

the following post seems contain more permanent fix issue (however on network computer without sufficient privileges verify it).

sql server management console doesn't work multi-byte characters

note: have been using korean/hangul data in sql server past 6 weeks without encountering issue. has occurred today, have had windows updates no other reason change in behavior. have used viewed/queried data no issues on tables have not been updated , encoded nvarchar. korean colleagues can still view data correctly in grid output in ssms.

i hope helps else stumbles upon question.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more