on 02-19-2006 2:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.