U+27D7 "⟗" Full Outer Join Unicode Character
Unicode Version 17.0
⟗
U+27D7 "⟗" Full Outer Join is a mathematical and database notation symbol representing a full outer join operation in relational algebra, which combines rows from two tables where the join condition is met on both sides, while also including unmatched rows from each table with null values in the corresponding columns from the other table. This character, part of the Miscellaneous Mathematical Symbols-A block, serves as a concise visual representation in formal logic, set theory, and database query diagrams, distinguishing the full outer join from its left and right outer join counterparts. Its design typically features a circle with a plus sign inside, symbolizing the inclusive union of all matching and non-matching data elements.
General Properties
| Code Point | U+27D7 |
| Version Added | 3.2 |
| Name | Full Outer Join |
| Block | Miscellaneous Mathematical Symbols-A |
| General Category | Math Symbol |
| Canonical Combining Class | Not Reordered |
| Bidirectional Class | Other Neutral |
Encodings
| HTML Decimal Encoding | ⟗ |
| HTML Hex Encoding | ⟗ |
| UTF-8 Encoding | 0xE2 0x9F 0x97 |
| UTF-16 Encoding | 0x27D7 |
| UTF-32 Encoding | 0x000027D7 |
| C/C++/Java Escape | \u27d7 |
Unicode Properties
| NFC Quick Check | Yes |
| NFD Quick Check | Yes |
| NFKC Quick Check | Yes |
| NFKD Quick Check | Yes |
| Numeric Type | None |
| Numeric Value | NaN |
| Line Break | Alphabetic |
| Script | Common |
| Script Extensions | Common |
| Indic Syllabic Category | Other |
| Pattern Syntax | Yes |
| Math | Yes |
| Vertical Orientation | Rotated |
| Grapheme Base | Yes |
| Grapheme Cluster Break | Other |
| Word Break | Other |
| Sentence Break | Other |