{"published":"2022-08-21 10:15:55","author_url":"https://blog.hatena.ne.jp/yohei-a/","type":"rich","provider_name":"Hatena Blog","height":"190","image_url":null,"version":"1.0","width":"100%","blog_url":"https://yohei-a.hatenablog.jp/","categories":["AWS"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20220821%2F1661044555\" title=\"Redshift \u3067\u5217\u9577\u306b\u5408\u308f\u305b\u3066\u6587\u5b57\u5217\u3092\u5207\u8a70\u3081\u308b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"You can't use SUBSTRING to predictably extract the prefix of a string that might contain multi-byte characters because you need to specify the length of a multi-byte string based on the number of bytes, not the number of characters. To extract the beginning segment of a string based on the length in\u2026","author_name":"yohei-a","title":"Redshift \u3067\u5217\u9577\u306b\u5408\u308f\u305b\u3066\u6587\u5b57\u5217\u3092\u5207\u8a70\u3081\u308b","blog_title":"ablog","url":"https://yohei-a.hatenablog.jp/entry/20220821/1661044555","provider_url":"https://hatena.blog"}