javascript - How can I prevent UTF8 strings from being allowed in my HTTP queries using JS (Node.js)? -

i have mysql table username field latin1 charset. if search table utf8 string, error:

error: er_cant_aggregate_2collations: illegal mix of collations (latin1_swedish_ci,implicit) , (utf8mb4_unicode_ci,coercible) operation 'like' 

side question: because i'm using statement, specifically?

i feel solution problem check if username parameter http query latin1 compatible string or not. if not, omit sql query.

how check if particular string compatible specific character set latin1 in javascript/node.js?

i realized solution problem convert encodings within sql using convert function.