Use FLEXI-STREAMS:WITH-INPUT-FROM-SEQUENCE and
FLEXI-STREAMS:WITH-OUTPUT-TO-SEQUENCE where appropriate.

tweak definition of ASSERT-EQUAL macro so this works

MySQL strings are just octets. Character encoding is done at a higher level