Post reply

Can Siebel use SQL 2000 in a non binary sort order?

  • November 30, 2004 at 2:02 pm

    #84940

    We are currently configured to use a case-insensitive sort order under SQL 2000 which, according to the Sieble Supported Platforms documentation, is allowed.  However, the installation guide and searches of the Siebel Support Web indicate that the Support Platforms documentation is wrong and that we will not be able to do the following if we don't change the sort order for our SQL Server installation.
     

    The question is, which document is right?  And, if Siebel works fine with case-insensitivity on their primary platform (Oracle), then why (even how) does it only work in a case-sensitive environment on other platforms such as MS-SQL Server?   Why can't a merge be done in SQL Server if it can be done in Oracle?

  • November 30, 2004 at 9:22 pm

    #531995

    While I can't directly answer your question of 'why Siebel can't use SQL 2000 in a non binary sort order' - that requirement is set by the vendor - I can give you some info that may help so that you do not have to change the sort order for our SQL Server installation.

    The good news is, in SQL Server 2000, you may set the sort order/collation at the database level.  So, you can set the Siebel db for binary, w/o affecting the other dbs and the entire server sort order.

    Check out books on-line for the exact syntax. It looks like Alter database Siebel collate (binary sort order)

    Hope that helps!

    RSP  http://www.pearlknows.com

  • March 1, 2007 at 9:57 am

    #692665

    The Answer is NO. Siebel is not going to work you will face problems with some views and when you upgrade to other versions. S

    iebel always recomends to use binary sort Order.

    Example : It should look like this when you query DB

    Character Set = 1, iso_1

        ISO 8859-1 (Latin-1) - Western European 8-bit character set.

    Sort Order = 50, bin_iso_1

        Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set

    Locale ID = 33280     -This represents Binary sort order.

     

    Hope this helps

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply