Re: Subscript/Superscript

Why not try a trigger (Before Insert or Update) to accomplish something like that?
Depending on the types of data you insert into those particular columns, a trigger could work well in converting data like so:

insert into your_table (col1) values ('H2O2');

the trigger could take both of the 2's and makes them into subscripts etc.
You'd have to apply some sort of logic if you wanted to implement superscript as well. (may have to use procedures to apply the logic, depending on your needs)

avril7_at_yahoo.com (Av) wrote in message news:<4c29054a.0202272128.4e5d8314_at_posting.google.com>...
> Thanks Dan for your quick response.
>
> I know with the character set it is possible, but how is
> subscript/superscript going to be entered by the user? Is there like
> an ALT code the user can type when entering the data?
>
>
> Av
>
>
> damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message news:<3C7D6343.86680FA3_at_ci.seattle.wa.us>...
> > With the UTF8 character set ... you can store anything from any language
> > that you can support with screen and/or print drivers.
> >
> > Daniel Morgan
> >
> >
> > Av wrote:
> >
> > > Does anyone know how i can store subscript and superscripts characters
> > > in the database. We will like to store the molecular formula of a
> > > substance as part of its description. Example, H20 for water.
> > >
> > > Thanks
> > > Av
Received on Fri Mar 01 2002 - 23:57:31 CET