txn_ref diagnostics

DATABASE(): daleam_nyansa

Input (raw): 12abCD!@3456789#

After stripping whitespace: 12abCD!@3456789#

Table payments: YES | Column txn_ref: YES

BINARY match exists? NO

Collation match exists? NO

Server: 11.4.11-MariaDB | Collation: latin1_swedish_ci | Charset: latin1

SHOW CREATE TABLE payments

CREATE TABLE `payments` (
  `payment_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `method` varchar(40) NOT NULL,
  `txn_ref` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `paid_at` datetime NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `user_id` varchar(64) NOT NULL,
  `period_month` varchar(7) NOT NULL,
  `is_voided` tinyint(1) NOT NULL DEFAULT 0,
  `void_reason` varchar(255) DEFAULT NULL,
  `voided_at` datetime DEFAULT NULL,
  `verified_by` varchar(50) DEFAULT NULL,
  `verified_at` datetime DEFAULT NULL,
  `receipt_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`payment_id`),
  UNIQUE KEY `uniq_txn_ref` (`txn_ref`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_payments_invoice_nonvoid` (`invoice_id`,`is_voided`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

SHOW TRIGGERS LIKE 'payments'

array (
)