Step 1: Determine the UTF-8 encoding bit layout
The character ⟕ has the Unicode code point U+27D5. 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+27D5 to binary:
00100111 11010101. 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 10010101
LEFT OUTER JOIN·U+27D5
⟕
Character Information
Code Point
U+27D5
HEX
27D5
Unicode Plane
Basic Multilingual Plane
Category
Math Symbol
Character Representations
Click elements to copy| Encoding | Hex | Binary |
|---|---|---|
| UTF8 | E2 9F 95 | 11100010 10011111 10010101 |
| UTF16 (big Endian) | 27 D5 | 00100111 11010101 |
| UTF16 (little Endian) | D5 27 | 11010101 00100111 |
| UTF32 (big Endian) | 00 00 27 D5 | 00000000 00000000 00100111 11010101 |
| UTF32 (little Endian) | D5 27 00 00 | 11010101 00100111 00000000 00000000 |
HTML Entity
⟕
URI Encoded
%E2%9F%95
Description
The Unicode character U+27D5, known as the "LEFT OUTER JOIN" symbol, serves a vital role in computer programming and digital text. It is primarily used to represent an operation in relational algebra, specifically an outer join between two sets of data. This symbol represents a type of join that includes all rows from the left table and the matching rows from the right table, if there are any matches. If no match exists, the symbol designates that NULL values should be inserted into the output. The LEFT OUTER JOIN is essential in database management systems and query languages like SQL, where it is frequently used to combine data from multiple tables for analysis or reporting purposes. While this character does not have any significant cultural or linguistic context, its importance lies in its technical application within the realm of computer science and information technology.
How to type the ⟕ symbol on Windows
Hold Alt and type 10197 on the numpad. Or use Character Map.