{"published":"2025-10-24 09:19:09","author_name":"yohei-a","blog_title":"ablog","version":"1.0","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20251024%2F1761265149\" title=\"Redshift \u3067\u975e ASCII \u6587\u5b57\u3092\u30d5\u30a3\u30eb\u30bf\u3059\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>","provider_url":"https://hatena.blog","type":"rich","author_url":"https://blog.hatena.ne.jp/yohei-a/","height":"190","categories":["AWS","Redshift"],"width":"100%","url":"https://yohei-a.hatenablog.jp/entry/20251024/1761265149","blog_url":"https://yohei-a.hatenablog.jp/","title":"Redshift \u3067\u975e ASCII \u6587\u5b57\u3092\u30d5\u30a3\u30eb\u30bf\u3059\u308b","image_url":null,"description":"Redshift \u3067\u975e ASCII \u6587\u5b57\u3092\u30d5\u30a3\u30eb\u30bf\u3059\u308b\u3002 \u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3002 CREATE TABLE source_table ( col1 VARCHAR(100) ); CREATE TABLE target_table ( col1 VARCHAR(100) ); \u975e ASCII \u6587\u5b57\u3092\u542b\u3080\u30ec\u30b3\u30fc\u30c9\u3092 insert \u3059\u308b\u3002 insert into source_table values('ascii text1'); insert into source_table values('\u975eASCII\u30c6\u30ad\u30b9\u30c8\uff11'); insert into source_table values('asc\u2026"}