however Db have there own particularities handling special characters. and the + along with 's. I have this when doing direct imports to some DB's so i think that there a few levels to consider.
BJ Freeman sent the following on 5/9/2008 7:09 AM: > Have you thought about escaping the characters. > http://www.theukwebdesigncompany.com/articles/entity-escape-characters.php > > [EMAIL PROTECTED] sent the following on 5/8/2008 1:37 PM: >> >From the RFC: >> >> "The characters ";", "/", "?", ":", "@", "=" and "&" are the characters >> which may be reserved for special meaning within a scheme." >> >> and >> >> "Thus, only alphanumerics, the special characters "$-_.+!*'(),", and >> reserved characters used for their reserved purposes may be used unencoded >> within a URL." >> >> However, Ofbiz is converting the '+' sign to a space. Can someone tell me >> where this conversion is happening so I can look for other possible >> exceptions? This is important to me because I am importing hundreds of >> thousands of entries and I need to handle these characters during import. >> >> Skip >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Thursday, May 08, 2008 10:14 AM >> To: OfbizUser >> Subject: Illegal Characters in an ofbiz URL >> >> >> I am importing an existing database with partyIds like P&G#1 and BEN+JERRIES >> >> I assumed that the standard URL symbols would be illegal, so I converted '&' >> to a '+' and most other punction to '_'. However, the '+' sign gets passed >> to the bash script as a space. In other words, "P+G" gets passed as "P G" >> which causes obvious problems. >> >> Is there a list somewhere of what characters are legal (or illegal) so I >> don't have to make guesses about it? >> >> Thanks in advance if this is a stupid newbee question. >> >> Skip >> No virus found in this outgoing message. >> Checked by AVG. >> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 >> 2:12 PM >> >> >> No virus found in this incoming message. >> Checked by AVG. >> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 >> 2:12 PM >> >> No virus found in this outgoing message. >> Checked by AVG. >> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 >> 2:12 PM >> >> >> >> > > > >
