How to display the "degree" symbol?
Posted: Sat Jun 13, 2015 9:49 pm
How do I display the "degree" symbol in a vsql result set?
For example, like this for a temperature:
74°F
For example, like this for a temperature:
74°F
User 2 User Support
http://www.vertica-forums.com/
Code: Select all
dbadmin=> SELECT '72' || CHR(176) || 'F';
?column?
----------
72°F
(1 row)
Heh heh, I agree! But I'm trying to create some descriptive text to store in a table column, in that I want to store the degree symbol in the database column. The CHR(176) works perfect. Thanks!!!This is typically done at the presentation layer; not the database layer.
This is a bad idea. You won't be able to get optimized encoding. Store just the integer component, then do your formatting.usli06 wrote:I want to store the degree symbol in the database column.