Re: Special Characters
From: Garry M. Filimonov <garry_at_fly.triniti.troitsk.ru>
Date: 1996/09/17
Message-ID: <01bba4ab$dbc982c0$bf0000c5_at_Garry.triniti.troitsk.ru>#1/1
Date: 1996/09/17
Message-ID: <01bba4ab$dbc982c0$bf0000c5_at_Garry.triniti.troitsk.ru>#1/1
You can insert any char using function: CHR(code_of_char) , but for ' char you can type it twice in string, e.g. 'The Garry''s test'.
May be this is wrong for English, but it's true for Oracle.
-- G'luck ! ----------------------------------------- Garry M. FIlimonov LASU TRINITI, Troitsk, MO, Russia garry_at_triniti.troitsk.ru Rainer Ternes <ternes_at_mpimg-berlin-dahlem.mpg.de> wrote in article <323E9B85.41C6_at_mpimg-berlin-dahlem.mpg.de>...Received on Tue Sep 17 1996 - 00:00:00 CEST
> Hi,
>
> I would like to select and insert special characters
> (e.g, ' ) in varchar2 fields.
> Does anybody know haw to do this?
>
> thanks
> Rainer
> --
> *************************************************
> Rainer Ternes
> Max-Planck-Institut fuer Molekulare Genetik
> Ihnestr. 73
> D - 14195 Berlin
> Germany
>
> Tel +49 30 84131408
> Fax +49 30 84131395
> mailto: ternes_at_mpimg-berlin-dahlem.mpg.de
> ************************************************
>