|
Angela: On Mon, 29 October 2001, Angela Wawrzaszek wrote: > Thanks everyone for the input. I guess we are stuck between a rock and a > hard place... We want the sort just the way it is on the as/400 because > this is out "size" field. So when we sort items by their size code they > display nicely in alphabetic order by their description. But when we push > it over to sql since the sort is not the same we now have something that is > say 3" x3" (code ĞA1) displaying before the 1" X 1" (code ĞAA) because of > the difference in the sort You're probably correct that you're stuck. You actually want to sort on the information (size) that you have encoded into the character scheme rather than the characters themselves. Although the information is the same on both platforms, the characters are weighted differently, hence the conflict. Avoiding this issue was a problem for the database designer long ago, but the problem wasn't addressed. Tom Liotta -- Tom Liotta The PowerTech Group, Inc. 19426 68th Avenue South Kent, WA 98032 Phone 253-872-7788 Fax 253-872-7904 http://www.400Security.com ___________________________________________________ The ALL NEW CS2000 from CompuServe Better! Faster! More Powerful! 250 FREE hours! Sign-on Now! http://www.compuserve.com/trycsrv/cs2000/webmail/
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
