Step 1: Determine the UTF-8 encoding bit layout
The character ⟗ has the Unicode code point U+27D7. 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+27D7 to binary:
00100111 11010111. 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 10010111
FULL OUTER JOIN·U+27D7
⟗
Character Information
Code Point
U+27D7
HEX
27D7
Unicode Plane
Basic Multilingual Plane
Category
Math Symbol
Character Representations
Click elements to copy| Encoding | Hex | Binary |
|---|---|---|
| UTF8 | E2 9F 97 | 11100010 10011111 10010111 |
| UTF16 (big Endian) | 27 D7 | 00100111 11010111 |
| UTF16 (little Endian) | D7 27 | 11010111 00100111 |
| UTF32 (big Endian) | 00 00 27 D7 | 00000000 00000000 00100111 11010111 |
| UTF32 (little Endian) | D7 27 00 00 | 11010111 00100111 00000000 00000000 |
HTML Entity
⟗
URI Encoded
%E2%9F%97
Description
The Unicode character U+27D7, known as FULL OUTER JOIN, holds a significant position in the realm of computer programming, specifically within the field of relational database management systems (RDBMS). Its primary role is to define a type of SQL (Structured Query Language) operation that combines rows from two or more tables based on specified criteria, without regard for missing values. In digital text, this character often appears in code and programming contexts where SQL statements are written. Though it doesn't have any cultural, linguistic, or technical context outside of these specific scenarios, it's an essential element for programmers working with databases, as the Full Outer Join operation is crucial in data analysis and manipulation tasks. Accuracy and precision are vital when using this character to ensure that the database operations are executed correctly, resulting in the desired output.
How to type the ⟗ symbol on Windows
Hold Alt and type 10199 on the numpad. Or use Character Map.