SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE ZPAYMENT(ZSYNCPAYMENT TEXT);
INSERT INTO ZPAYMENT(ZSYNCPAYMENT) VALUES
('Ä123{"t156'), ('A123{"t156');
SELECT instr(ZSYNCPAYMENT, '{"t') FROM ZPAYMENT

instr(ZSYNCPAYMENT, '{"t')

5

5

SELECT INSTR(cast(ZSYNCPAYMENT as blob), cast('{"t' AS BLOB)) FROM ZPAYMENT

INSTR(cast(ZSYNCPAYMENT as blob), cast('{"t' AS BLOB))

6

5