SQL server collation question

Doomhammer
Doomhammer Member Posts: 211
edited 2006-11-01 in NAV/Navision Classic Client
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
Martin Bokůvka, AxiomProvis

Answers

  • Phenno
    Phenno Member Posts: 630
    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
    Doomhammer Member Posts: 211
    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
    Martin Bokůvka, AxiomProvis
  • Phenno
    Phenno Member Posts: 630
    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
    Doomhammer Member Posts: 211
    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
    Martin Bokůvka, AxiomProvis
  • Phenno
    Phenno Member Posts: 630
    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 :)

Categories