There are cases when it is not possible to launch the 1C program, and a 1C dialog box appears with the message “The sort order set for the database differs from the system one!” After closing the window, the program closes (you can run it in Configurator mode).

Valery Sidorov

Cause of error and solutions

The cause of the error is a mismatch between the system settings and the 1C settings.
By the way, if operating system is localized and the regional settings are set correctly, then when installing 1C its settings will be brought into line with the system ones.

Checking the settings are correct

I. System Settings(for localized Russified version of Windows)

1. Open Start - Settings - Control Panel - Regional and Language Options.

2. On the tab Regional settings in the drop-down list there should be – Russian.

3. On the Languages tab – More details... – Languages and text input services dialog box – Options tab – The default input language should be Russian-Russian.

4. On the Advanced tab there should be – Russian.

II. 1C settings

4. In the Table Code Page window information base the drop-down list should contain – 1251 – Russian, Belarusian, Bulgarian and Serbian languages.

Notes

1. If you are using the DIMB component (distributed infobase management), - when sort order checking is disabled - you SHOULD NOT use characters of any alphabets other than Latin in the three-letter identifier of infobases included in the distributed database.

2. It should be borne in mind that disabling the sort order identity check can lead to unexpected results - for the user of the 1C program! – the order of lines, for example, when generating reports.

Fixing the error in Windows Vista

If you are using Windows Vista, then get rid of the message “The sort order set for the database is different from the system one!” the above methods will not work.

To do this:

1. Launch the 1C program. In the Launch 1C window, select the desired information base.

2. In the drop-down list In mode, select Configurator – OK.

3. The Configurator will start. Select menu Administration – Code page of information security tables...

4. In the Code page of infobase tables window, in the drop-down list, select + Current system installation– OK.

5. In the Configurator window with the message “When changing the code page, the indexes of all infobase data tables will be rebuilt! Do you want to change the code page?" click Yes.

6. After a certain period of time, depending on the size of the information security, the Configurator window will appear with the message “Code page has been changed!”, click OK.

7. Close the Configurator, you can work with the infobase.

8. To work with other information security systems, change the code page of information security tables in the same way.

After installing 1C version 7.7 on your computer and launching it, the error “The sort order set for the database differs from the system one!” usually appears, what should you do in this case?

This problem can be solved in two ways:

1. Method

You must ensure that the platform number is 7.7.
Launch 1c. Select the desired information base and open it in the “Configurator” mode.
Menu “Administration” -> “Code page of information security tables”.
In the “Code page of information security tables” window, open the item “Current system installation” -> OK.
The message “When changing the code page, the indexes of all data tables in the Information Base will be rebuilt!” will appear on the screen! Do you want to change the code page?" Click the “Yes” button.
To the message “The code page has been changed!” click OK.
Close the “Configurator” and launch the Information Base in normal mode 1C:Enterprise.

If several Information Bases turn out to be inoperative, then it is necessary to perform this procedure with each of these databases.

2. Method

Launch text editor, for example, the Notepad editor.
Then select “Save As” from the “File” menu. In the window that opens, click “File type”, select “All files”, and specify the file name as: OrdNoChk.prm. Save this file to the root directory of the infobase, or to the 1C program directory (this file can be downloaded below).
Launch the 1C program. In the Program Window, select the desired Infobase and click the “Change” button.
In the window that opens, indicate the path to the previously saved file, the 1c program is ready to launch.

If there are several Information Bases, then you need to place the OrdNoChk.prm file in each of them in this way.

Important: For beginners in 1C, it will be easier to use the second option, since there is no need to perform actions with the information base and configuration.
For any action, including the error “The sort order set for the database differs from the system one!” c information security or configuration, it is always recommended to create backups so that you can recover lost data.

The sort order set for the database does not match the system one

The cause of the error is a mismatch between the system settings and the 1C settings.
By the way, if the operating system is localized and the regional settings are set correctly, then when installing 1C its settings will be brought into line with the system ones.

Checking the settings are correct

I. System settings (for localized Russified version of Windows)

1. Open Start - Settings - Control Panel - Regional and Language Options.
2. On the Regional Settings tab, the drop-down list should be Russian.
3. On the Languages tab – More details... – Languages and text input services dialog box – Options tab – The default input language should be Russian-Russian.
4. On the Advanced tab there should be – Russian.

II. 1C settings

4. In the Code page of infobase tables window, the drop-down list should contain – 1251 – Russian, Belarusian, Bulgarian and Serbian languages.

As a last resort, it is sometimes recommended to disable sort order matching checking. To do this, you need to create a signal file named OrdNoChk.prm (with arbitrary content) in the infobase directory. But:
1. If you are using the DIMB component (distributed infobase management), - when sort order checking is disabled - you SHOULD NOT use characters of any alphabets other than Latin in the three-letter identifier of infobases included in the distributed database.
2. It should be borne in mind that disabling the sort order identity check can lead to unexpected results - for the user of the 1C program! – the order of lines, for example, when generating reports.

Troubleshooting Windows Vista

If you are using Windows Vista, then get rid of the message “The sort order set for the database is different from the system one!” the above methods will not work.

To do this:

1. Launch the 1C program. In the Launch 1C window, select the desired information base.
2. In the drop-down list In mode, select Configurator – OK.
3. The Configurator will start. Select menu Administration – Code page of information security tables...
4. In the Code page of infobase tables window, in the drop-down list, select + Current system installation – OK.
5. In the Configurator window with the message “When changing the code page, the indexes of all infobase data tables will be rebuilt! Do you want to change the code page?" click Yes.
6. After a certain period of time, depending on the size of the information security, the Configurator window will appear with the message “Code page has been changed!”, click OK.
7. Close the Configurator, you can work with the infobase.
8. To work with other information security systems, change the code page of information security tables in the same way.

If an error occurs when connecting to the sql server, copy the windows/system32 files sqlsrv32.dll and sqlsrv32.rll from a computer with winXP to a computer with Vista (after having given permission to overwrite them)

How to fix the error “The sort order set for the database differs from the system one” in 1C 7.7 on Windows 7?

How to fix the error “The sort order is different from the system one” in 1c 7.7?

Enough common problem When connecting a 1C 7.7 database in Windows 7, the error “The sort order set for the database differs from the system one” appears. Because of this, it is impossible to log into the connected database, although before this it worked fine on another computer.

In this article we will tell you how you can get rid of this error and successfully launch the selected 1C 7.7 database.

We remove the error “The sort order is different from the system one” in 1c 7.7 on windows 7

So, there are two ways to resolve this error. The first is done by changing the code page through the configurator, and the second is done using the OrdNoChk.prm file. Now we will talk about two methods in more detail.

To remove the error described above when starting 1C 7.7, you need to single-click in the database selection window to select the database that produces this error and select “Configurator” at the top, then click “OK”.

Opening the database in the configurator

Tool for changing the code page for 1C 7.7 database tables

In the window that appears, open the list and select the last item “+ Current system installation”.

Setting a new code page

Click “OK” everywhere and agree to change the code page in all database tables.

Code page change warning

After the message about the successful completion of the operation, you can close the configurator and go to this database data as usual.

The second way to fix the error “The sort order set for the database differs from the system one” in 1C 7.7 is to create an empty file named OrdNoChk.prm in the folder with the 1C program. By default it is C:\Program Files\1Cv77\BIN.

File OrdNoChk.prm in the folder with the 1C 7.7 program

All you need to do is create it in empty file with the name OrdNoChk.prm. Please note that the file extension is .prm.

This will disable code page checking when starting the database and thereby get rid of the sort order error.

Share this article on social networks! Help our site!

Join us on VK!

1C: what to do if the message “The sort order set for the database differs from the system one!” appears

Checking the settings are correct

I. System settings (for localized Russified version of Windows)

1. Open Start - Settings - Control Panel - Regional and Language Options.

2. On the Regional Settings tab, the drop-down list should be Russian.

3. On the Languages tab – More details... – Languages and text input services dialog box – Options tab – The default input language should be Russian-Russian.

4. On the Advanced tab there should be – Russian.

II. 1C settings

2. In the drop-down list In mode, select – OK.

4. In the Code page of infobase tables window, the drop-down list should contain – 1251 – Russian, Belarusian, Bulgarian and Serbian languages.

Notes

Troubleshooting Windows Vista

If you are using Windows Vista, then get rid of the message “The sort order set for the database is different from the system one!” the above methods will not work.

To do this:

1. Launch the 1C program. In the Launch 1C window, select the desired information base.

2. In the drop-down list In mode, select Configurator – OK.

3. The Configurator will start. Select menu Administration – Code page of information security tables...

4. In the Code page of infobase tables window, in the drop-down list, select + Current system installation – OK.

5. In the Configurator window with the message “When changing the code page, the indexes of all infobase data tables will be rebuilt! Do you want to change the code page?" click Yes.

6. After a certain period of time, depending on the size of the information security, the Configurator window will appear with the message “Code page has been changed!”, click OK.

7. Close the Configurator, you can work with the infobase.

8. To work with other information security systems, change the code page of information security tables in the same way.