I too came across the same problem with regards to the single quote and I
solved it by using a JDBC PreparedStatement. This handles all the character
escaping for you.
I am just a little puzzled as to why the űŰ characters are converted to
űŰ when they are sent to the server, but when I try to convert
them back, nothing happens. I thought that this is what URLEncoder and
URLDecoder were supposed to do, or do these methods not support these
characters ??
My application throws an error because in the database, the username field
is 40 characters long so if a username of ŰŰŰŰŰŰŰ is entered it gets
converted into ŰŰŰŰŰŰŰ when it gets sent
back to the server and because it isn't getting converted back Oracle throws
an error because what it gets converted into is longer than 40 characters.
I just assumed that this is something that URLDecoder would handle ??
Cheers
Lee
_________________________________
Lee Turner
Systems Developer
Information Technology Leeds
_________________________________
Watt Gilchrist Ltd
Ring Road, West Park
Leeds, LS16 6RA
Tel: 0113 288 3200
Fax: 0113 275 1690
http://www.wattgilchrist.co.uk
_________________________________
> -----Original Message-----
> From: R.Muthukumar [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 12:47 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Special Characters
>
> Not exactly...
> When I was not able to insert the special characters to the database, I
> used
> this method.
> And it worked with me. In oracle you can't enter a string with single
> quote.
> So, use the method appendQuote also. When I used both these methods, I was
> able to successfully insert all special characters in to Oracle.
>
> /**
> * This method will append a single quote to the string which contains
> single quote
> */
> public String appendQuote(String strValues) {
> StringBuffer result = new StringBuffer();
>
> for (int i=0;i<strValues.length();i++) {
> char c = strValues.charAt(i);
> if (c==39){
> result.append(c+"\'");
> }else{
> result.append(c);
> }
> }
> String finalValue = result.toString( );
> return finalValue;
> }
>
> ----- Original Message -----
> From: "Lee Turner" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, April 11, 2001 4:51 PM
> Subject: Re: Special Characters
>
>
> > Hi Muthu
> >
> > Thanks for the reply !! I am still a little puzzled though. Doesn't
> the
> > method you sent just replicate the functionality of URLEncoder and
> > URLDecoder ?
> >
> > Cheers
> > Lee
> >
> > _________________________________
> >
> > Lee Turner
> > Systems Developer
> > Information Technology Leeds
> > _________________________________
> >
> > Watt Gilchrist Ltd
> > Ring Road, West Park
> > Leeds, LS16 6RA
> > Tel: 0113 288 3200
> > Fax: 0113 275 1690
> > http://www.wattgilchrist.co.uk
> > _________________________________
> >
> >
> > > -----Original Message-----
> > > From: R.Muthukumar [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wednesday, April 11, 2001 12:20 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: Special Characters
> > >
> > > Hi Lee,
> > > Instead of using the URLEncoder and URLDecoder, use the asp equivalent
> of
> > > htmlEncode method. Just call this method before u insert the values
> into
> > > Oracle.
> > > public static String htmlEncode(String text) {
> > > if (text == null) {
> > > return "";
> > > }
> > >
> > > StringBuffer results = null;
> > > char[] orig = null;
> > > int beg = 0, len = text.length();
> > > for (int i = 0; i < len; ++i){
> > > char c = text.charAt(i);
> > > switch (c){
> > > case 0:
> > > case '&':
> > > case '<':
> > > case '>':
> > > case '"':
> > > if (results == null){
> > > orig = text.toCharArray();
> > > results = new StringBuffer(len+10);
> > > }
> > > if (i > beg) {
> > > results.append(orig, beg, i-beg);
> > > }
> > > beg = i + 1;
> > > switch (c){
> > > default: // case 0:
> > > continue;
> > > case '&':
> > > results.append("&");
> > > break;
> > > case '<':
> > > results.append("<");
> > > break;
> > > case '>':
> > > results.append(">");
> > > break;
> > > case '"':
> > > results.append(""");
> > > break;
> > > }
> > > break;
> > > }
> > > }
> > > if (results == null)
> > > return text;
> > > results.append(orig, beg, len-beg);
> > > return results.toString();
> > > }
> > > Rgds
> > > Muthu
> > >
> > > ----- Original Message -----
> > > From: "Lee Turner" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 11, 2001 4:24 PM
> > > Subject: Special Characters
> > >
> > >
> > > > Hi
> > > >
> > > > I am testing my application by trying it out with special
> characters.
> I
> > > > have entered űŰ (with squiggly on top for those readers that don't
> see
> > > them)
> > > > in a field in the form. This gets translated into űŰ when
> sent
> > > to
> > > > the server. However, when I try to decode this back to it original
> form
> > > (
> > > > java.net.URLDecoder.decode(req.getParameter("username")) ), it stays
> the
> > > > same and therefore űŰ gets entered into the database
> (Oracle).
> > > >
> > > > Is this correct when using these characters or am I missing
> something
> ??
> > > >
> > > > Cheers
> > > >
> > > > Lee
> > > >
> > > > _________________________________
> > > >
> > > > Lee Turner
> > > > Systems Developer
> > > > Information Technology Leeds
> > > > _________________________________
> > > >
> > > > Watt Gilchrist Ltd
> > > > Ring Road, West Park
> > > > Leeds, LS16 6RA
> > > > Tel: 0113 288 3200
> > > > Fax: 0113 275 1690
> > > > http://www.wattgilchrist.co.uk
> > > > _________________________________
> > > >
> > > >
> > >
> ==========================================================================
> > > =
> > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > > JSP-INTEREST".
> > > > For digest: mailto [EMAIL PROTECTED] with body: "set
> JSP-INTEREST
> > > DIGEST".
> > > > Some relevant FAQs on JSP/Servlets can be found at:
> > > >
> > > > http://java.sun.com/products/jsp/faq.html
> > > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > >
> > >
> ==========================================================================
> > > =
> > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > > JSP-INTEREST".
> > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> > > DIGEST".
> > > Some relevant FAQs on JSP/Servlets can be found at:
> > >
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
> ==========================================================================
> =
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
> ==========================================================================
> =
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
