{"provider_url":"https://hatena.blog","height":"190","blog_title":"\u65e7\u71c8\u660e\u65e5\u8a18","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fchaipa.hateblo.jp%2Fentry%2F20080828%2F1219925385\" title=\" SQLServer \u3067 text\u578b\u306e\u9805\u76ee\u306e\u6587\u5b57\u6570\u3092\u6c42\u3081\u308b - \u65e7\u71c8\u660e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"SQLServer\u3067\u306etext\u578b\u306f\u30012,147,483,647(2^31-1)\u30d0\u30a4\u30c8\u5185\u306e\u975eUnicode\u53ef\u5909\u9577\u6587\u5b57\u5217\u578b\u3067\u3059\u3002 \u3053\u306e\u3088\u3046\u306b\u5927\u304d\u306a\u30c7\u30fc\u30bf\u578b\u306a\u306e\u3067\u3001\u6587\u5b57\u6570\u3092\u6c42\u3081\u308b\u3068\u304d\u306b varchar\u578b\u306e\u3088\u3046\u306b LEN\u95a2\u6570\u304c\u4f7f\u3048\u307e\u305b\u3093\u3002 \u3057\u304b\u3057\u3001text\u578b\u3067\u3082 8000\u30d0\u30a4\u30c8\u4ee5\u4e0b\u306a\u3089\u3001\u4ee5\u4e0b\u306e\u611f\u3058\u3067\u6587\u5b57\u6570\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 \u30b5\u30f3\u30d7\u30eb\uff08Message\u9805\u76ee\u304ctext\u578b\u306e\u30b1\u30fc\u30b9\uff09 SELECT LEN(CAST([Message] AS varchar(8000))) FROM [TmpTBL] ORDER BY LEN(CAST([Message] AS varchar(8000))) DESC \u3061\u2026","author_url":"https://blog.hatena.ne.jp/chaichanPaPa/","image_url":"http://ecx.images-amazon.com/images/I/41h6MAzzm6L.jpg","type":"rich","width":"100%","title":" SQLServer \u3067 text\u578b\u306e\u9805\u76ee\u306e\u6587\u5b57\u6570\u3092\u6c42\u3081\u308b","url":"https://chaipa.hateblo.jp/entry/20080828/1219925385","author_name":"chaichanPaPa","categories":["VB-TIPS"],"published":"2008-08-28 21:09:45","version":"1.0","provider_name":"Hatena Blog","blog_url":"https://chaipa.hateblo.jp/"}