Special characters and units

From: Stefan Stern <mail2stern(at)gmx(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Special characters and units
Date: 2002-09-18 15:17:53
Message-ID: 3D889921.4050603@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-09-18 15:27:46 Re: Special characters and units
Previous Message Stephan Szabo 2002-09-18 15:14:24 Re: Doubt on opaque returntype!!