Left Outer Join ⟕
Usage snapshot:
- Used in content written with the Common script; suitable for UI labels and body text.
- Appears in the Unicode block Miscellaneous Mathematical Symbols-A.
History & usage: The character LEFT OUTER JOIN depicts the official name LEFT OUTER JOIN. In the name, the tokens LEFT, OUTER, and JOIN signal functional parts: a directional qualifier, a type modifier, and the action. These tokens illustrate how labels use qualifiers and operators in typographic practice, where shape or qualifier terms help readers parse meaning even when the glyph is seen alone. In generic orthography, such modifiers help distinguish a specific operation from related forms and guide interpretation in diagrams and text. Two to three practical usage contexts follow. First, in dictionaries and grammars for relational notation, the symbol appears beside explanations of join operations within the block of Miscellaneous Mathematical Symbols-A and the Common script, aiding precise reference during scholarly reading. Second, in educational primers and scholarly editions of database texts, it serves as a visual exemplar in discussions of query construction and operator hierarchy. Third, in archival transcription and typographic revivals, the symbol marks a relational join in historical materials and specimen books. Cross‑platform appearance remains consistent with screen readers and accessibility tools for computing terms and operations.
See our category page for related symbols.
Need styled alternatives? Try the Fancy Text tool.
Technical details
- Codepoint: U+27D5
- General Category: Sm
- Age: 3.2
- Bidi Class: ON
- Block: Miscellaneous Mathematical Symbols-A
- Script: Common
- UTF-8: E2 9F 95
- UTF-16: 27D5
- UTF-32: 000027D5
- HTML dec: ⟕
- HTML hex: ⟕
- JS escape: \u27D5
- Python \N{}: \N{LEFT OUTER JOIN}
- Python \u: \u27D5
- Python \U: \U000027D5
- URL-encoded: %E2%9F%95
- CSS escape: \27D5
How to type / insert
Fast copy: click the Copy button near the top of this page.
By codepoint: in many editors and IDEs, you can insert via the Unicode code U+27D5 or a built‑in character picker.
HTML: use the numeric entity ⟕ (hex) or ⟕ (decimal) when an HTML entity is needed.
Compatibility & troubleshooting
Font support: if the symbol does not render, the current font likely lacks this codepoint. Choose a font with broad Unicode coverage or allow a fallback font.
Web pages: ensure your CSS font stack includes a general fallback; avoid relying on images for common symbols to preserve accessibility and copyability.