Step 1: Determine the UTF-8 encoding bit layout
The character ⟖ has the Unicode code point U+27D6. In UTF-8, it is encoded using 3 bytes because its codepoint is in the range of
0x0800to0xffff.
Therefore we know that the UTF-8 encoding will be done over 16 bits within the final 24 bits and that it will have the format:1110xxxx 10xxxxxx 10xxxxxx
Where thexare the payload bits.UTF-8 Encoding bit layout by codepoint range Codepoint Range Bytes Bit pattern Payload length U+0000 - U+007F 1 0xxxxxxx 7 bits U+0080 - U+07FF 2 110xxxxx 10xxxxxx 11 bits U+0800 - U+FFFF 3 1110xxxx 10xxxxxx 10xxxxxx 16 bits U+10000 - U+10FFFF 4 11110xxx 10xxxxxx 10xxxxxx 10xxxxxx 21 bits Step 2: Obtain the payload bits:
Convert the hexadecimal code point U+27D6 to binary:
00100111 11010110. Those are the payload bits.Step 3: Fill in the bits to match the bit pattern:
Obtain the final bytes by arranging the paylod bits to match the bit layout:
11100010 10011111 10010110
RIGHT OUTER JOIN·U+27D6
⟖
Character Information
Code Point
U+27D6
HEX
27D6
Unicode Plane
Basic Multilingual Plane
Category
Math Symbol
Character Representations
Click elements to copy| Encoding | Hex | Binary |
|---|---|---|
| UTF8 | E2 9F 96 | 11100010 10011111 10010110 |
| UTF16 (big Endian) | 27 D6 | 00100111 11010110 |
| UTF16 (little Endian) | D6 27 | 11010110 00100111 |
| UTF32 (big Endian) | 00 00 27 D6 | 00000000 00000000 00100111 11010110 |
| UTF32 (little Endian) | D6 27 00 00 | 11010110 00100111 00000000 00000000 |
HTML Entity
⟖
URI Encoded
%E2%9F%96
Description
The Unicode character U+27D6, known as RIGHT OUTER JOIN, plays a significant role in the realm of computer science and digital text processing. This symbol is commonly employed in relational database operations and programming languages such as SQL to describe the right outer join operation, which returns all records from the right table and the matching records from the left table. In this context, it signifies the retrieval of data based on specified conditions or criteria. Although RIGHT OUTER JOIN does not hold cultural, linguistic, or artistic significance, its technical importance lies in the efficiency and accuracy with which it enables data manipulation and extraction within digital systems.
How to type the ⟖ symbol on Windows
Hold Alt and type 10198 on the numpad. Or use Character Map.