Re: How to check for special charcters in an email address using plsql code?

Frank,
I am not sure what type of character it is and that the reason I would like to filter them out.

Thanks,
Rao

Frank van Bortel wrote:
> vkatekan_at_yahoo.com schreef:
> > Thank you, Frank. But somehow the escape_sc function is not working for
> >
> > n_d_t_at_yahoo.coma
> > email address. Any thoughts, why it's not filtering out this one and is
> > there any generic plsql function to validate an email address?
> >
> > Regards,
> > Rao
> >
> >
> >
> > Frank van Bortel wrote:
> >> vkatekan_at_yahoo.com schreef:
> >>
> >>> Hi There,
> >>> I am trying to write a plsql function to filter an email address which
> >>> has a special address in it. I tried to filter them out by creating a
> >>> table for bad charcters (i.e Chr(0...31 & 127...255), but this is also
> >>> filtering out an email address with '_' charcter and just wondering
> >>> how can I accomplish this one.
> >>>
> >>> Thank you very much in advance for all your inputs.
> >>>
> >>> Regards,
> >>> Rao
> >> escape_sc (Special Characters) and escape_url functions should be able
> >> to accomplish that
> >
> What's that - a mutibyte character? Are these allowed at all?
> or is that why you want to filter them out?
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Mon Aug 21 2006 - 10:58:04 CDT