They are padded all the time the char fields in question range in length from char(4) to char(10). Also a single trim() doesn't work. I need to trim(trim()) or the length of the field is still 254. I have no control over how the data will be stored in the database. I have requested they all be converted to varchar fields but it doesn't happen. If a single trim would work I would not worry so much but again I am trying to compare values held in cf variables that are now 255 to database fields that are 4-10 chars long. A trim wouldn't help me there unless I have the oracle developers trim all the values coming out of the database in the stored proc and trim(trim()) the char field. This has been going on since version 4 and we are now on version 5 of cf. Thanks
Jerry Johnson wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
