Sql server 2005ä¸ASP .NETç¼ç é®é¢
ææ£å¨å次åå ³äºæçç¼ç é®é¢......ç°å¨ä¸äºä»£ç 示ä¾ãSql server 2005ä¸ASP .NETç¼ç é®é¢
ç®èè¨ä¹ï¼ä¿åå°æ°æ®åºè¾å ¥æ°æ®æ¶ï¼æ³¢å °è¯'Å'çè¯è¨specyficå符ä¸ä¼ä¿å - insted'n'被ä¿åãå¦ä¸æ¹é¢ï¼å符串ï¼Adamsæblerï¼ä¸Ã¦æ¯å¨èã
è¿éæ¯ä»£ç begind代ç ï¼ä¸ä¼ä¿åçä¸è¥¿ï¼å¹¶æ¾ç¤ºæ°æ®ï¼
Default.aspxçæmetaæ ç¾ï¼
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
表çèµ·æ¥æ¯è¿æ ·çï¼
CREATE TABLE [dbo].[Users]([Surname] [nvarchar](50) COLLATE Latin1_General_CI_AI NULL) ON [PRIMARY]
æä¸ç¥éè¿æä»ä¹éè¦è§£å³è¿ä¸ªé®é¢ã帮å©èµèµã
谢谢ï¼PaweÅ
ç»äºææç½äºä»ä¹æ¯éçãæéè¿äºÃ±åç¼å符串ä¹åï¼å®æ å¿çå符串UNICODEï¼ï¼
command.CommandText = "INSERT INTO users VALUES(N'" + Surname.Text + "')";
æè°¢ï¼ å¸ç»´å°
æ¨ç表å®ä¹ä¼¼ä¹æ¯é®é¢ãå§æ°ç¨COLLATE Latin1_General_CI_AI
å®ä¹ã AI
é¨å表示éé³ä¸ææãæ¨éè¦å°æåºè§åæ´æ¹ä¸ºLatin1_General_CI_ASï¼ä»¥ä¿çæ°æ®ã
åï¼å½æååºï¼SELECTå§æ°ï¼CASTï¼å§æ°ä¸ºvarbinaryï¼30ï¼ï¼AS表达å¼1æ¥èªç¨æ·çï¼å符âñâçå符æ¯0x6E00 - æ以å¨æ°æ®åºä¸'n'å符被åå¨ã â dragonfly 2010-09-15 20:45:17
å¦ææ¨å¨'Button1_Click'ä¸è°è¯'Surnme.Text'æ¯å¦å å«æ£ç¡®çå¼ï¼å¦ææ¨ä½¿ç¨SQL Profilerï¼é£ä¹çèµ·æ¥ä»ä¹ä»·å¼è¢«åéå°SQL Serverï¼ â 2010-09-15 21:02:00
æ¯çã Surname.Textå ·ææ£ç¡®çä»·å¼ãåæ¶ä½¿ç¨Encoding.Unicode.GetBytesæ£æ¥å®å°è¿åâ好âåèãæè¿æ²¡æç¨Profileræ£æ¥è¿å®ã â dragonfly 2010-09-15 21:19:39