{"blog_title":"\u3050\u308b\u3050\u308b\uff5e","author_name":"bleis-tift","author_url":"https://blog.hatena.ne.jp/bleis-tift/","title":"SQL Server \u306e LEN \u95a2\u6570\u306f\u6587\u5b57\u5217\u306e\u9577\u3055\u3092\u6b63\u78ba\u306b\u53d6\u5f97\u51fa\u6765\u306a\u3044\u30fb\u30fb\u30fb\u3060\u3051\u3058\u3083\u306a\u3044","version":"1.0","published":"2009-05-16 21:55:38","url":"https://bleis-tift.hatenablog.com/entry/20090516/1242478538","provider_name":"Hatena Blog","image_url":null,"categories":["SQL"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbleis-tift.hatenablog.com%2Fentry%2F20090516%2F1242478538\" title=\"SQL Server \u306e LEN \u95a2\u6570\u306f\u6587\u5b57\u5217\u306e\u9577\u3055\u3092\u6b63\u78ba\u306b\u53d6\u5f97\u51fa\u6765\u306a\u3044\u30fb\u30fb\u30fb\u3060\u3051\u3058\u3083\u306a\u3044 - \u3050\u308b\u3050\u308b\uff5e\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","width":"100%","description":"\u30b5\u30ed\u30b2\u30fc\u30c8\u6587\u5b57*1\u3092\u542b\u3080\u6587\u5b57\u5217\u3060\u3068\u3001LEN \u95a2\u6570\u6b63\u3057\u3044\u6587\u5b57\u5217\u9577\u3092\u53d6\u5f97\u51fa\u6765\u306a\u3044\u3002 -- \u3053\u306eSQL\u3092\u5b9f\u884c\u3059\u308b\u3068\u30011\u3067\u306f\u306a\u304f2\u304c\u8fd4\u3055\u308c\u308b SELECT LEN(N'\ud842\udfb7'); \u6ce8\u610f\uff1a\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u25a1\u304c\u8868\u793a\u3055\u308c\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u3051\u3069\u3001\u5b9f\u969b\u306f\u3064\u3061\u3088\u3057 (\u5409\u306e\u4e0a\u304c\u58eb\u3058\u3083\u306a\u304f\u3066\u571f) \u3067\u3059\u3002 \u4ee5\u4e0b\u3001\u25a1\u304c\u73fe\u308c\u305f\u3089\u8133\u5185\u5909\u63db\u3059\u308b\u304b\u3001\u8868\u793a\u3067\u304d\u308b\u74b0\u5883\u3067\u898b\u308b\u304b\u3057\u3066\u304f\u3060\u3057\u3042\u3002 \u3067\u3001\u5b9f\u306f\u554f\u984c\u306f LEN \u95a2\u6570\u3060\u3051\u3058\u3083\u306a\u304f\u3066\u3001\u4ed6\u306e\u6587\u5b57\u5217\u95a2\u6570\u3084\u3001\u6587\u5b57\u5217\u578b\u306b\u307e\u3067\u53ca\u3076\u3002 \u6587\u5b57\u5217\u578b \u4f8b\u3048\u3070\u3001nchar(1) \u578b\u3084 nvarchar(1) \u306e\u5217\u306b\u306f\u300c\ud842\udfb7\u300d\u3092\u683c\u7d0d\u3059\u308b\u3053\u3068\u306f\u51fa\u6765\u306a\u3044\u3057*2\u3001nchar(1) \u578b\u3084 nvarchar(1) \u578b\u306e\u5909\u6570\u306b\u2026","provider_url":"https://hatena.blog","type":"rich","blog_url":"https://bleis-tift.hatenablog.com/"}