<?php
require '/tmp/cdx-store-category9-C.Hr1w83/db.php';
$tests=[];
foreach(['NAME'=>128,'CATEGORY_PATH'=>255,'CREATE_BY'=>32]as $column=>$length){
 $left=str_repeat('😀',$length);$right=str_repeat('😀',$length-1).'😁';
 $result=$q("SELECT RAWTOHEX(CHARTOBIN(?)) AS LEFT_HEX,RAWTOHEX(CHARTOBIN(?)) AS RIGHT_HEX,CASE WHEN NVL(RAWTOHEX(CHARTOBIN(?)),'#') <> NVL(RAWTOHEX(CHARTOBIN(?)),'#') THEN 1 ELSE 0 END AS DIFFERENT FROM DUAL",[$left,$right,$left,$right]);
 $check($result[0]['left_hex']===strtoupper(bin2hex($left))&&$result[0]['right_hex']===strtoupper(bin2hex($right))&&(int)$result[0]['different']===1,'Full4-byte capacity hex '.$column);
 $tests[$column]=['characters'=>$length,'bytes'=>strlen($left),'hex_characters'=>strlen($result[0]['left_hex']),'different'=>$result[0]['different'],'raw'=>$result];
}
echo json_encode(['lane'=>'C','DML'=>0,'DDL'=>0,'SELECT'=>3,'passed'=>true,'tests'=>$tests],JSON_PRETTY_PRINT|JSON_UNESCAPED_UNICODE),"\n";