Special characters and units - Mailing list pgsql-general

From Stefan Stern
Subject Special characters and units
Date
Msg-id 3D889921.4050603@gmx.net
Whole thread Raw
Responses Re: Special characters and units  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Hi all,

I'm running PHP and PostgreSQL on a webserver to present data on the www.

I got a dataset that consists of measured values, each with a different
unit (micro, kilo,).

1. Where is the best place to store the units? In the identifier of each
column?

2. Some units are "micro gramms". Is there a way to store the special
character 'micro' (ASCII 181 / HEX B5) in the database or do I have to
use 10E-6 instead?

Thanks for any suggestions.

Regards,
Stefan Stern



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Doubt on opaque returntype!!
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Special characters and units