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

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

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

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.

For 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.

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 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.

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.

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.

For 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.

At the moment, few people use 1C version 7.7, but there are still organizations that, for one reason or another, cannot switch to newer platforms. In my practice, I haven’t seen configurations written in 7.7 for a long time. But just recently I had to deal with 7. In the process I encountered such a problem. When running on different versions of Windows, the same error constantly appears. Namely, the sort order set for databases differs from the system one. There are two ways to solve this; let’s look at each of them in more detail.

How to disable 1c code page checking

Changing the code table

The easiest way is to change the code page in the 1C program. To do this, launch the program in configurator mode. Next, go to Administration - Code page of information security tables.

In the window that appears, select + Current system installation and click OK.

After which the program should start, but there is one caveat: if users from different operating systems work in this configuration, for example Windows XP and Windows 7, then when starting on a different version you will need to do similar actions each time.

Disabling code page checking

This method is much better and simpler. You can disable code page checking in 1C. To do this, you need to create a file named ordnochk.prm and place it in the program folder at this path C:\Program Files\1Cv77\Bin. If you do not have a Bin directory, place the file in the directory above. C:\Program Files\1Cv77\

The 1C program is on a different path for me, so don’t pay attention to it. That’s all, if something doesn’t work out, write in the comments, I’ll try to answer and help everyone.

There are times when it is impossible to start the 1C program, and a dialog box appears with the message The sort order set for the database is different from the system one!. After closing the window, the program closes (you can run it in Configurator mode).

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 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.

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.

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.

For 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.

There are times when the program cannot be launched 1C, and a window appears 1C with a message "The sort order set for the database is different from !".

After closing the window, the program closes (you can run it in the mode Configurator).

Cause of error and solutions

Reason for error – mismatch between settings and settings 1C.

By the way, if the operating system is localized and the regional settings are set correctly, then during installation 1C its settings will be brought into line with .

Checking the settings are correct

I. settings(for localized Russified version Windows)

1. Open Start – > Settings –> Control Panel –> language and regional standards.

2. On the tab Regional settings there should be in the dropdown list – Russian.

3. On the tab Languages – > More details… – window Text input languages ​​and services –> tab Options – > Input language there must be – > Russian-Russian.

4. On the tab Additionally there must be –> Russian.

II. 1C settings

1. Launch the program 1C. In the window Launch 1C

2. In the dropdown list In mode select Configurator –> OK.

3. Start Configurator. Select menu Administration –> Code page of information security tables…

4. In the window there should be in the dropdown list –> 1251 – > Russian, Belarusian, Bulgarian and Serbian languages.

Notes

1. If you use the component (distributed infobase management), – when disabling sort order checking, – You SHOULD NOT use characters from any alphabets other than Latin in the three-letter identifier of infobases that are part of a distributed database.

2. Be aware that disabling sort order identity checking may result in unexpected – for the 1C program! – the order of lines, for example, when generating reports.

Fixing the error in Windows Vista and Windows 7+

If you are using Windows Vista And Windows 7+ , 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.

You'll have to go another way:

1. Launch the program 1C. In the window Launch 1C select the required information base.

2. In the dropdown list In mode select Configurator – >OK.

3. Start Configurator. Select menu Administration – > Code page of information security tables…

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