## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> UNISTR[UNISTR]:::quoted UNISTR --> End((END)) ``` ## Purpose The `UNISTR` SQL function converts a text with unicodes to regular characters. See also [[CHR]]. Parameters: - Input (`varchar2`): text with unicodes. Returns: the input converted to all regular characters. ## Examples The following example converts the unicode `\20ac` to the euro sign: ```sql select unistr('\20ac') ------------------- € ``` The following example converts the unicodes `\0192` and `\03a3` to the florin and capital sigma signs: ```sql select unistr('a\0192\03a3') ------------------- aƒΣ ```