I discovered the unistr sql function, which shows the unicode symbol of an hexadecimal input.
eg> select unistr('\2713 ') tick from dual;
As such I constructed a dynamic (sql) LOV in apex, converting the Y/N codes into a unicode symbol. See the tick symbol query above.
Linking the LOV to a reporting column (text shown as LOV) changed the Y/N values of the column in a nice symbol.
✓ You also have unicode symbols for airplanes, balloons, stars, ... Please use them wisely. ✔
eg> select unistr('\2713 ') tick from dual;
As such I constructed a dynamic (sql) LOV in apex, converting the Y/N codes into a unicode symbol. See the tick symbol query above.
Linking the LOV to a reporting column (text shown as LOV) changed the Y/N values of the column in a nice symbol.
✓ You also have unicode symbols for airplanes, balloons, stars, ... Please use them wisely. ✔
