Have you thought about running an ALTER TABLE sql statement yourself, instead of waiting for somebody else to do it for you? ... change the char to varchar yourself?
Do the fields need to be 254? Could you alter them to, say, char(10), char(100) ... whatnot? Maybe that would require less trimming. If you don't want to muck with the existing table, use CREATE TABLE, setting it up to your preferences, then populate it with the data from the old table, then running your application against your new table. Just some suggestions for getting around unhelpful db admins -- not that these are perfect work arounds. Even with MSSQL server, output of char fields needs to be trimmed, especially when doing comparisons. H. > -----Original Message----- > From: freddy [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March 07, 2002 1:07 PM > To: CF-Talk > Subject: Re: [OT] Re: VTML Builder > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > > > > ______________________________________________________________________ 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
