Its how the sort works. Say in an order by or in an index. Sybase and SQL
server do bit collating and db2 does byte collating by default.

If you want db2 to act like SQL Server create the database with collate
using identity.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"D OLLONE Clara "
<db2udbdba-ezmlms
hield-x59815415.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
06/25/2004 08:09
AM Subject
collating sequence










Hi everybody,

What is 'collating sequence' in database ?


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



DB2 & UDB email list listserv db2-l LazyDBA home page