question

$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ asked SeeyaXi-msft commented

SQL2000 the strange collation

Hi, I have very old server with Windows Server 2000 and MS SQL 2000. I have to migrate the server to newer. The MS SQL server has collation: Compatibility_88_415_30003 ![108990-sqlserver.png][1] I didn't found anythink about this collation. Is this any backward compatibility collation ? Is any currect collation which works with this ancient ? Best regards [1]: /answers/storage/attachments/108990-sqlserver.png

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi anonymous user ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it dosn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered TomPhillips-1744 edited

That appears to be the server collation. That really does not matter.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I haven't seen that one before...

Given the installation path, I suspect that this instance has been upgraded from an earlier version of SQL Server. This might have something to do with it.

Another thing worth observing is that this is the RTM version of SQL 2000. Better later than never, apply Service Pack 4, and see what happens.

To view the collations of the databases on the server, you can run this query:

SELECT databasepropertyex(name, 'Collation'), * FROM sysdatabases
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi anonymous user,

You can use this query to query all current collations.

 select * from ::fn_helpcollations()

And this docs is about how to view collation information:https://docs.microsoft.com/en-us/sql/relational-databases/collations/view-collation-information?view=sql-server-ver15

There are three levels of how to change collations. The T-SQL is similar to these:
Database-level collations: ALTER DATABASE myDB COLLATE Greek_CS_AI;
Column-level collations: ALTER TABLE myTable ALTER COLUMN mycol NVARCHAR(10) COLLATE Greek_CS_AI;
Expression-level collations: SELECT name FROM customer ORDER BY name COLLATE Latin1_General_CS_AI;
Please refer to this MS docs: https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver15

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.