Just use a char datatype and the spaces will remain. â Phillip Beazley
On Wed, Jul 17, 2013 at 6:49 PM, Michael Kear <[email protected]> wrote: > This might seem a dumb way to do it, because it's not using any of the > database features or switches, but you could add a character at the end > when you insert it. Say 'Z'. That would leave your spaces intact as > being inside the field's contents. Then when you retrieve the value, just > strip off the trailing 'Z'. > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > -----Original Message----- > From: Maureen [mailto:[email protected]] > Sent: Tuesday, 16 July 2013 6:58 AM > To: sql > Subject: Re: retaining trailing space characters in sql data > There is a setting called SET ANSI_PADDING > http://support.microsoft.com/kb/316626 > If that doesn't work for you, I would store the REGEX with a special > delimiter at the end after any trailing spaces, and just strip the delimiter > off before using the expression. > On Sun, Jul 14, 2013 at 5:50 PM, Michael Dinowitz > <[email protected]> wrote: >> >> I have a database of regular expressions and I've had a problem when >> trying to save expressions that contain trailing space characters >> (such as a new line). Is there a switch in MSSQL that I can set to >> keep the space characters? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3516 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
