maria-discuss team mailing list archive
Mailing list archive
Re: JSON and binary strings
yeap, check what's the result() from database, byte-byte, probably you got
some conversion at mysql client or at programming language
at json docs i didn't found a specific encode to c1c2c3c4c5c6....
A string is a sequence of Unicode code points wrapped with quotation marks
(U+0022). All characters may be placed within the quotation marks except
for the characters that must be escaped:
quotation mark (U+0022),
reverse solidus (U+005C),
and the control characters U+0000 to U+001F.
There are two-character escape sequence representations of some characters.
\" represents the quotation mark character (U+0022).
\\ represents the reverse solidus character (U+005C).
\/ represents the solidus character (U+002F).
\b represents the backspace character (U+0008).
\f represents the form feed character (U+000C).
\n represents the line feed character (U+000A).
\r represents the carriage return character (U+000D).
\t represents the character tabulation character (U+0009).
So, for example, a string containing only a single reverse solidus
character may be represented as "\\". Any code point may be represented as
a hexadecimal number. The meaning of such a number is determined by ISO/IEC
10646. If the code point is in the Basic Multilingual Plane (U+0000 through
U+FFFF), then it may be represented as a six-character sequence: a reverse
solidus, followed by the lowercase letter u, followed by four hexadecimal
digits that encode the code point. Hexadecimal digits can be digits (U+0030
through U+0039) or the hexadecimal letters A through F in uppercase (U+0041
through U+0046) or lowercase (U+0061 through U+0066). So, for example, a
string containing only a single reverse solidus character may be
represented as "\u005C".
The following four cases all produce the same result:
"\u002F" "\u002f" "\/" "/"
To escape a code point that is not in the Basic Multilingual Plane, the
character is represented as a twelvecharacter sequence, encoding the UTF-16
surrogate pair. So for example, a string containing only the G clef
character (U+1D11E) may be represented as "\uD834\uDD1E".