Are they padded to 255 all the time, or does that char field have a length or 255?
My understanding is that the char would return a string with the entire length of the field. That is the main difference between a char and a varchar (which would return a string only as long as the data put into the field.) 1. change it to a varchar or 2. trim() it before use. Jerry Johnson >>> [EMAIL PROTECTED] 03/07/02 03:24PM >>> I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: > > What difference does it make? If you want it fill out the info... > > it is faster than writing an email to complain about it. > > Maybe I'm being too cynical, but to me *spam* makes the > difference. I was just looking for some assurance that the > download is actually *free*, and not paid for by allowing > the people you give your info to to sell that info on for > marketing (I couldn't see any assurance on the site). > > BTW, it would have been faster for you to not criticise > my questioning than to do so (nod to Bill Hicks ;) > > - Gyrus > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
