SQL server collation question

Doomhammer wrote:

Hi.
I've got following problem with collation on SQL server.
in native database, code fields in primary keys are collated following way:
1,2,10,20,100,200 etc.
in SQL option, code fields in keys are collated like this:
1,10,100,2,20,200
can you help me, how to get "standard" collation on SQL server?

thanks in advance

This IS "standard" collation on SQL (and) Native server. And, as you already saw, they are different so, you'll have to have another approach to the problems that you've got..

standard problems is filtering and one of solutions is to you "same-length" value of fields, for example:

instead of 1,2,10,20,100
use
001, 002, 010, 020, 100

try to search mibuso, there are several threads about this topic (and solutions to some of standard problems like CoA sorting)

Doomhammer wrote:

pls, can you help me to find some of topics you came up with?
i tried to search, but without success

we are migrating customer's database from 2.60 native to 4.0 SQL and this is our first SQL installation, so I am new in this problems

http://www.mibuso.com/forum/viewtopic.p ... sql+native
http://www.mibuso.com/forum/viewtopic.p ... sql+native
http://www.mibuso.com/forum/viewtopic.p ... sql+native

Doomhammer wrote:

thanx a lot, in one of your links I found reference to SQL data type property. this helped me, I set it on Integer type in tables which were affected by this problem...

MUID: ELES

glad to be helpfull