CODEWITHSUNDEEP
mysqlsqlescapingmysql-real-escape-string
Charles
Charles

Reputation: 11479

Unprintable characters in MySQL

I want to test if a certain BLOB starts with character 255 (\xff). Is there a way to encode this character in a literal string?

Table 9.1. Special Character Escape Sequences gives certain special characters but not a way to encode arbitrary characters.

Failing a way to encode characters, is there a different workaround?

Upvotes: 1

Views: 334

Answers (1)

schtever
schtever

Reputation: 3250

Use a hexadecimal literal, e.g. X'FF'. See http://dev.mysql.com/doc/refman/5.0/en/hexadecimal-literals.html

Upvotes: 3

Related Questions