cancel
Showing results for 
Search instead for 
Did you mean: 

collations in MSSQL 2000

Former Member
0 Kudos

Hello,

I've an SQL 2000 SP3 that is installed with SQL_Latin1_General_CP850_BIN2 collation.

I've attached a non-unicode database that has SQL_Latin1_General_CP850_BIN collation.

When I upgrade to ECC 5.0, I got error that the collation is different.

My question: Can I change the collation of the non-unicode database to SQL_Latin1_General_CP850_BIN2 ? What are the consequences of that ?

Please advise,

Dimitry Haritonov

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Dimitry,

You can check SAP Note 600027, which describes the

collation changes. Also SAP requires that all new

installations require the BIN2 collation.

Regards

Srikishan

Former Member
0 Kudos

Dear Srikishan,

Only unicode systems require BIN2 because of the sorting problem that is exists in BIN (this is als described in note 600027.

Non unicode systems don't need bin2, as far as I know.

Kind regards,

Dimitry

former_member110461
Active Contributor
0 Kudos

Hi,

If you read that note - all new SAP installations require BIN2.

Paul

Former Member
0 Kudos

Hello,

qoute from the note 600027:

<i>SAP requires that ALL new installations of an SAP system use this collation. This note explains how to apply the collation before you install an SAP system.

<b>For existing NON-UNICODE SAP systems there is presently no need to convert them to the new collation</b>.</i>

Regards,

Dimitry

Message was edited by: Dimitry Haritonov

Former Member
0 Kudos

If you installed ECC 5.0 as Unicode, the collation of the database should be BIN2. To migrate your BIN db to BIN2 you can consider DTS tool integrated with MSSQL or R3COPY.

Regards,

Mike

Former Member
0 Kudos

Hello,

First of all I would like to state that: There is no need to change the collation of the existing system to BIN2 if it is an non-unicode system !

Secondly, nobody answered my question:

Is there any consequenses of changing a db collation from BIN to BIN2 if it is a non unicode system ?

Regards,

Dimitry

Former Member
0 Kudos

Hi Dimitry,

There seems to be a mismatch between the collation setting

of the MSSQL Server 2000 and the database.

The installation guide for ECC 5.0 at http://service.sap.com/instguides -> mySAP Business suite

-> ERP -> ERP2004 -> ECC 5.0

Section 1.6.1.1 descibes the collation settings. Please check the prerequisites, I believe some of them may apply to your situation.

As far as the change of db collation from bin to bin2 for

non-unicode is concerned, there are no such serious

consequences, as SAP itself recommends this change in the

guide.

Regards

Srikishan