MySQL :: MySQL 5.7 Reference Manual :: 12.7 String ...
String-valued functions return NULL if the length of the result would be greater than the value of the max_allowed_packet system variable. See Section 5.1.1, “Configuring the Server”.. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the nearest integer.
DA: 27 PA: 34 MOZ Rank: 20