StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
924440
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-05-29T04:55:49.073
FavoriteCount
0
LastActivityDate
2009-05-29T07:51:57.607
LastEditDate
2009-05-29T07:51:57.607
LastEditorUserId
80347
OwnerUserId
80347
ParentId
923876
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
So far the information is: <ol> <li>You are using direct SQL INSERT script to insert into the database.</li> <li>The data appears broken in database.</li> </ol> The problem might lie in two places: <ol> <li>In your INSERT statement, did you prefix the insert value with N? INSERT INTO #tmp VALUES (N'全澳甲流确诊病例已破100')</li> <li>If you prefix the value with N, does the String object hold the correct data? String sql = "INSERT INTO #tmp VALUES (N' " + value + "')"</li> </ol> Here I assume value is a String object. Does this String object hold the correct Chinese characters? Try print out its value and see. Updated: Let's assume the INSERT query is constructed as below: <pre><code>String sql = "INSERT INTO #tmp VALUES (N' " + value + "')" </code></pre> I assume value holds the Chinese character. Did you assign the Chinese characters into value directly? Like <pre><code>String value = "全澳甲流确诊病例已破100"; </code></pre> The above code shall work. However, if you have done any intermediate processing, it will cause problem. I did a localized TC project before; the previous architect had done several encoding conversions which are necessary in ASP; but they will create problem in .NET: <pre><code> String value = "全澳甲流确诊病例已破100"; Encoding tc = Encoding.GetEncoding("BIG5"); byte[] bytes = tc.GetBytes(value); value = Encoding.Unicode.GetString(bytes); </code></pre> The above conversions are unnecessary. In .NET, simply direct assignment will work: <pre><code> String value = "全澳甲流确诊病例已破100"; </code></pre> That is because String constants and the String object itself are Unicode compliant. The framework library, such as File IO, when reading a file which is not encoded in Unicode, they will convert the foreign encoding to Unicode; in other words, the framework will do this dirty job for you. You do not need to perform manual encoding conversion most of time. Update: Understood that ASP is used to insert data into an SQL server. I have written a small piece of ASP to insert some Chinese chars into SQL database and it works. I have a database named "trans" and I created a table "temp" inside. The ASP page is encoded in UTF-8. <pre><code><html> <head title="Untitled"> <meta http-equiv="content-type" content="text/html";charset="utf-8"> </head> <body> <script language="vbscript" runat="server"> If Request.Form("Button1") = "Submit" Then SqlQuery = "INSERT INTO trans..temp VALUES (N'" + Request.Form("Text1") + "')" Set cn = Server.CreateObject("ADODB.Connection") cn.Provider = "sqloledb" cn.Properties("Data Source").Value = ********* cn.Properties("Initial Catalog").Value = "TRANS" cn.Properties("User ID").Value = "sa" cn.Properties("Password").Value = ********** cn.Properties("Persist Security Info").Value = False cn.Open cn.Execute(SqlQuery) cn.Close Set cn = Nothing Response.Write SqlQuery End If </script> <form name="form1" method="post" action="input.asp"> <input name="Text1" type="text" /> <input name="Button1" value="Submit" type="submit" /> </form> </body> </html> </code></pre> The table is defined as belows in my database: <pre><code> create table temp (data NVARCHAR(100)) </code></pre> Submit the ASP page several times and my table contains proper Chinese data: <pre><code>select * from trans..temp data ---------------- test 测试全澳甲流确诊病例已破100 </code></pre> Hope this can help.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhy are my Chinese characters not displayed correctly in c# string
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USyinyueyouge
UserOwnerUserId
1. USyinyueyouge
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThe insertion to the database is done in asp not .Net. The retrieval is done in .Net. Do you know of anything special that has to be done in the asp?
 singulars
 PostPostId
 PO
 UserUserId
 USSean
2. COThis answer saved my life :) I didn't know the usage of N, like "values (N'......') ". Thank you very much.
 singulars
 PostPostId
 PO
 UserUserId
 USEmre

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.