\u5728\u5229\u7528SELECT REPLACE(‘\u5bc6\u6c34\u8857\u529e?’,’?’,”)\u53d1\u73b0\u5f97\u5230\u7684\u7ed3\u679c\u4ecd\u4e3a\u5bc6\u6c34\u8857\u529e?,\u6ca1\u7528\u5c06?\u53bb\u6389\u3002
\n\u518d\u7528SELECT CHECKSUM(‘?’),CHECKSUM(”) \u53d1\u73b0\u5f97\u5230\u7684\u7ed3\u679c\u90fd\u662f0\uff0c\u8bf4\u660e\u4e8c\u8005\u5e76\u6ca1\u6709\u5f97\u5230\u533a\u5206.
\n\u901a\u8fc7\u6539\u53d8\u7f16\u7801\u683c\u5f0f\u89e3\u51b3: SELECT REPLACE(‘\u5bc6\u6c34\u8857\u529e?’ collate Chinese_PRC_BIN2,’?’,”)
\n\u67e5\u770bmssql\u652f\u6301\u7684\u7f16\u7801\uff1aselect * from ::fn_helpcollations()<\/p>\n
\u8be6\u7ec6\uff1a
\nmssql\u9ed8\u8ba4\u4e2d\u6587\u7684\u7f16\u7801\u4e3a:Chinese_PRC_CI_AS\u5373\uff1a
\nChinese-PRC, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
\nunicode\u5b57\u7b26\u96c6Chinese-PRC \u5927\u9646\u7b80\u4f53\u5b57,\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff0c\u91cd\u97f3\u654f\u611f\uff0c\u5047\u540d\u7c7b\u578b\u654f\u611f\uff0c\u5168\u89d2\u534a\u89d2\u4e0d\u654f\u611f
\n_BIN \u4e8c\u8fdb\u5236\u6392\u5e8f
\n_CI(CS) \u662f\u5426\u533a\u5206\u5927\u5c0f\u5199\uff0cCI\u4e0d\u533a\u5206\uff0cCS\u533a\u5206
\n_AI(AS) \u662f\u5426\u533a\u5206\u91cd\u97f3\uff0cAI\u4e0d\u533a\u5206\uff0cAS\u533a\u5206\u3000\u3000\u3000
\n_KI(KS) \u662f\u5426\u533a\u5206\u5047\u540d\u7c7b\u578b,KI\u4e0d\u533a\u5206\uff0cKS\u533a\u5206\u3000
\n_WI(WS) \u662f\u5426\u533a\u5206\u5bbd\u5ea6 WI\u4e0d\u533a\u5206\uff0cWS\u533a\u5206<\/p>\n
\u5047\u540d\u7c7b\u578b:\u5e73\u5047\u540d\u662f\u65e5\u8bed\u4e2d\u8868\u97f3\u7b26\u53f7\u7684\u4e00\u79cd
\n\u91cd\u97f3:\u82f1\u6587\u5355\u8bcd\u4e2d\u7684\u91cd\u97f3,\u5982 \uff0c’a’\u4e0d\u7b49\u540c\u4e8e’\u00e1’\u3002
\n\u7528\u5f97\u6700\u591a\u7684\u662f\u5927\u5c0f\u5199\u662f\u5426\u533a\u5206\uff0c\u5168\u89d2\u662f\u5426\u533a\u5206\uff0c\u9ed8\u8ba4\u90fd\u662f\u4e0d\u533a\u5206<\/p>\n
\u53ef\u770b\u5230\u9ed8\u8ba4\u5168\u89d2\u534a\u89d2\uff0c\u5927\u5c0f\u5199\u4e0d\u533a\u5206\uff0c\u82e5\u60f3\u533a\u5206\uff0c\u91c7\u7528\u7f16\u7801\u8f6c\u6362
\nIF (‘@’ = ‘\uff20’ collate Chinese_PRC_CI_AS_WS)
\nPRINT ‘y’
\nELSE PRINT ‘n’<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u5229\u7528SELECT REPLACE(‘\u5bc6\u6c34\u8857\u529e?’,’?’,& […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1824","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=1824"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1824\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}