Well you can purchase it from www.ansi.org, or get some sort of an incomplete version from http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
Again, this doesn't describe everything, and might even be something that wasn't totally complete, but that's the best I could find on the web. Ilya -----Original Message----- From: Fannin, David P. To: Sterin, Ilya Cc: [EMAIL PROTECTED] Sent: 2/28/02 3:06 PM Subject: RE: Whitespace being truncated with Oracle For my personal edification, could someone point me at the site where ANSI SQL is documented? I'm just curious to find out how far from standard Oracle is. Thanks! -dpf- ----------------------- David P. Fannin Database Administrator [EMAIL PROTECTED] UM-Rolla Computing and Information Services FAX (573) 341-4216 URL http://www.umr.edu/~dpf PHONE (573) 341-4841 ----------------------- -----Original Message----- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:46 PM To: 'Michael Peppler '; 'Jeff Hunter ' Cc: 'Peter J. Holzer '; ''[EMAIL PROTECTED] ' ' Subject: RE: Whitespace being truncated with Oracle Michael, it's sure is a standard, and though the reason I keep claiming that the behavior is correct:-) Now of course Oracle and some other vendors I don't care to mention love straying from the path and taking their own approach, but then call themselves SQL ## compliant. Oracle has a major trailing space problem that was discussed up and down this list many times. Peter, just look at the archives. But I think following the standard is the way to go. Ilya -----Original Message----- From: Michael Peppler To: Jeff Hunter Cc: Peter J. Holzer; '[EMAIL PROTECTED] ' Sent: 2/28/02 2:38 PM Subject: Re: Whitespace being truncated with Oracle Jeff Hunter writes: > I agree, it should be fixed. > > Peter J. Holzer wrote: > > >I don't think the current behaviour[1] is correct. In perl, strings can > >have trailing spaces: "test" and "test " compare as not equal. > >In Oracle varchar2 can store strailing spaces: If I store 'test ' in a > >varchar2 column, I get back 'test ' and not 'test' or 'test '. Are you *sure* that you get 'test ' back??? I'm not be an Oracle specialist, but I know that trailing spaces in varchar() columns are normally removed on insert. This is definitely the case for Sybase - irrespective of the client that is used to access the data. I also seem to recall that this behaviour is a SQL standard. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] *or* [EMAIL PROTECTED] http://www.mbay.net/~mpeppler International Sybase User Group: http://www.isug.com
