CP850_BIN2 for non unicode systems??
This is possibly a really stupid question and I think I know the answer, but I need some one else to say yes!
We are currently running a SQL upgrade, from 2000 to 2005, for ore ECC6 platform. As part of the upgrade it is recommended that you change the DB collation from SQL_Latin1_General_CP850_BIN to SQL_Latin1_General_CP850_BIN2 which allows unicode data to be sorted properly.
My question is, if this enhancement is to correct a unicode issue, will it affect my current non-unicode system if applied. I don't want it to cause any issues if I apply it during the upgrade.
I don't think it will for various reasons, but I am not 100% can anone let me know if I am right, please!
Thanks in advance!
Clas Hortien replied
you will have no issues with your current system when you go to BIN2 now (before you upgrade to SQL 2005). And you have to keep in mind, that you have to have BIN2 for all newer releases of SAP. So if you plan to ever upgrade your system to a newer release in some point in time, you should go to BIN2 now, as otherwiese you have to perform a homogenous systemcopy with R/3 (which is not so much fun) if you miss it now. On SQL 2005 you can't change the collation easily, so if you don't have the correct one, you only can change it when you unload the data, drop the DB, create the DB in the correct collation and reload the data.