COPY...REPLACING and REPLACE Literal Restrictions

The maximum number of bytes in a literal string that is under the scope of a REPLACE or COPY...REPLACING statement when converted to UTF-8 is 1023 bytes. When Japanese Shift-JIS characters are the source of a COPY, each character is converted to 3 bytes; therefore, literals containing only Shift-JIS characters can only contain 341 characters in such scenarios.