In MySQL, the WEIGHT_STRING() function returns the weight string for the input string. The return value is a binary string that represents the comparison and sorting value of the string.

If the input string is a nonbinary value, the return value contains the collation weights for the string. If it’s a binary value, the result is the same as the input string. This is because the weight for each byte in a binary string is the byte value.

This function is a debugging function intended for internal use. It can be used for testing and debugging of collations. Note that its behavior can change between MySQL versions.

Continue reading →

In MySQL, the UNHEX() function allows you to “unhex” a string in MySQL. In other words, it allows you to convert a hexadecimal value to a human-readable string.

Specifically, the function interprets each pair of characters in the argument as a hexadecimal number and converts it to the byte represented by the number. The return value is a binary string.

Continue reading →

In MySQL, the TRIM() function trims whitespace (or other specified characters) from the start and/or end of a string.

You can specify whether to trim from the left side, the right side, or both sides of the string.

Continue reading →

In MySQL, the POSITION() function returns the position of the first occurrence of a substring within the string.

This function is actually a synonym for LOCATE(), but with a slightly different syntax. The LOCATE() function also has extra functionality, in that it allows you to define a starting position fro your search.

Continue reading →

In MySQL, the OCTET_LENGTH() function returns the length of a string, measured in bytes.

This function is actually a synonym of LENGTH().

Continue reading →

In MySQL, the OCT() function is used for converting from decimal to octal.

More precisely, it returns a string representation of the octal value of its argument.

Continue reading →

In MySQL, the RTRIM() function trims whitespace from the right-hand side of a string.

Continue reading →