I haven't used a database yet that will accept '' like this. However, I'm not
versed in all databases so I wont say that there aren't any outhere that this
would be acceptable.
However, in most cases this will not work. Changing a string from
I'll be happy
to
I''ll be happy
doesn't fix the problem.
If you escape the ' like \' or use a prepared statement you will be fine.
Another alternative is to use the URLEncoder and URLDecoder classes. This
takes all non alpha-numeric characters not including periods and changes them
into their HTML equivalent. This would convert any possible character or
string that would cause a problem with databases such as escape characters and
such.
Matt
Quoting RBonazzo <[EMAIL PROTECTED]>:
> hi, for insert data in database the single quote will be 2 single
> quote
> use this for example:
> String aString="I'll be happy";
> aString=replace(aString,"'","''");// the second parameter are a single
> quote
> and the third are 2 single quote
>
> //
> private String replace(String testo, String StrdaSost, String
> StrNuovo)
> {
> int index=0;
> String Buffer = testo;
>
> if (Buffer.equalsIgnoreCase("")) return Buffer;
>
> while((index = Buffer.indexOf(StrdaSost, index)) >= 0) {
> Buffer = Buffer.substring(0,index)+ StrNuovo +
> Buffer.substring(index + StrdaSost.length());
>
> index += StrNuovo.length();
> }
> return Buffer;
> }
>
> I hope this will help you
> regards
> Rinaldo Bonazzo
> [EMAIL PROTECTED]
>
> ----- Original Message -----
> From: "Tom & Sharon Kochanowicz" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, September 20, 2001 9:00 PM
> Subject: Re: replacing apostrophes
>
>
> > Strings are immutable, you need to create a new String, for example:
> >
> > String str = "aaabbbccc";
> > String str2 = new String(str.replace('a','b'));
> >
> > T. Kochanowicz
> >
> >
> > -----Original Message-----
> > From: A mailing list for discussion about Sun Microsystem's Java
> Servlet
> > API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Barbara Johnson
> > Sent: Thursday, September 20, 2001 1:54 PM
> > To: [EMAIL PROTECTED]
> > Subject: replacing apostrophes
> >
> >
> > Hello All,
> >
> > I need to replace apostrophes from in the text a user puts in a form
> input
> > textboxe before the text goes into the mysql database. If apostrophes
> go
> > into the database it gets corrupted.
> >
> >
> > I tried the "replace" function and can use it to replace a letter but
> am
> > having trouble with the syntax to use
> > to tell it to replace an apostrophe because the function says to
> use
> single
> > quotes around the variables that you are replacing.
> >
> > This works:
> > String str = "aaabbbccc";
> > out.println (str.replace('a','b'));
> >
> > This doesn't work:
> > String str = "aaabbbccc";
> > out.println (str.replace(''',''''));
> >
> >
> > I tried subsituting the outer single quotes with double quotes. That
> doesn't
> > work either.
> > Any suggestions would be appreciated.
> > Thanks,
> > Barbara Johnson
> > Instructional Applications Programmer
> > [EMAIL PROTECTED]
> > Northeastern Ohio Universities College of Medicine
> >
> >
> ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives:
> http://archives.java.sun.com/archives/servlet-interest.html
> > Resources:
> http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> >
> ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives:
> http://archives.java.sun.com/archives/servlet-interest.html
> > Resources:
> http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> >
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
> http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
