Question

The columns containing binary value that include null bytes will not print properly using the %s printf() format specifier.

(a) True

(b) False

I had been asked this question during an internship interview.

The question is from Processing SQL Statements topic in chapter MySQL Programs Using C of MySQL

Answer 1

Right choice is (a) True

Explanation: The columns containing binary value including null bytes do not print properly using the %s printf() format specifier. printf() expects a null terminated string. It prints the column value only up to the first null byte.