How to set up smartphones and PCs. Informational portal
  • home
  • In contact with
  • Windows 7 is different from the system. The sort order set for databases differs from the system sort order

Windows 7 is different from the system. The sort order set for databases differs from the system sort order

At the moment, few people use 1C version 7.7, but still there are organizations that, for one reason or another, cannot switch to newer platforms. In my practice, I have not 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 sort order. There are two ways to solve it, we will analyze each of them in more detail.

How to disable code page check 1s

Changing the code table

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

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

After that, 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 you start on a different version, you will need to do such actions every time.

Disable codepage check

This way is much better and easier. You can disable the code page check in 1C. To do this, you need to create a file called ordnochk.prm and place it in the folder with the program along this path C:\Program Files\1Cv77\Bin. If you do not have a Bin directory, upload the file to the directory above. C:\Program Files\1Cv77\

The 1C program lies with me in a different way, so do not pay attention to it. That's all if something did not work out, write in the comments I will try to answer everyone and help.

The reason for 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 correctness of the settings

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

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

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

3. On the Languages ​​tab - More ... - the Text Input Languages ​​and Services dialog box - the Options tab - The default input language should be Russian-Russian.

4. On the Advanced tab, it 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.

Simplest. Starting with release 7.70.027, 1C introduced the ability to disable the check. To do this, you need to place an empty file with the name "OrdNoChk.prm" in the folder with the program (usually "C:\Program Files\1Cv77\BIN\") or in the database folder. Everything. To find out the release number of your program, you need to select the "About" item in the "Help" menu. In the window that opens, the first line will be something like "1C:Enterprise 7.7 (7.70.027)". Here's what you see in parentheses is the release number of your program.

Notes

1. If you are using the URIB component (distributed infobase management), - when checking sort order is disabled, - SHOULD NOT use characters of any alphabet 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 check for the identity of the sort order can lead to unexpected - for the user of the 1C program! - the order of the lines, for example, when generating reports.

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

For this:

1. Run the 1C program. In the Start 1C window, select the desired infobase.

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

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

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

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 IB size, the Configurator window will appear with the message "Code page changed!", click OK.

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

8. To work with other IBs, change the code page of the IB tables in the same way.

There are cases when it is not possible to start the 1C program, and the 1C 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 start it in the Configurator mode).

Valery Sidorov

Cause of the error and solutions

The reason for 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 correctness of the settings

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

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

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

3. On the Languages ​​tab - More ... - the Text Input Languages ​​and Services dialog box - the Options tab - The default input language should be Russian-Russian.

4. On the Advanced tab, it 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 URIB component (distributed infobase management), - when checking sort order is disabled, - SHOULD NOT use characters of any alphabet 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 check for the identity of the sort order can lead to unexpected - for the user of the 1C program! - the order of the lines, for example, when generating reports.

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

For this:

1. Run the 1C program. In the Start 1C window, select the desired infobase.

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

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

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

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 IB size, the Configurator window will appear with the message "Code page changed!", click OK.

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

8. To work with other IBs, change the code page of the IB tables in the same way.

There are times when the program fails to run 1C, 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 the error and solutions

Cause of error mismatch 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 correctness of the settings

I. settings(for the localized Russian version Windows)

1. Open Start > Customization> Control Panel> language and regional standards.

2. Tab Regional Options dropdown should be Russian.

3. Tab Languages > More… – window Text input languages ​​and services > tab Parameters > Input language should be – > Russian-Russian.

4. Tab Additionally should be> Russian.

II. 1C settings

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

2. Drop down list In mode select Configurator > OK.

3. Run Configurator. Select menu Administration > Code page of IB tables

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

Notes

1. If you are using a component (distributed infobase management),when disabling sort order checking,DO NOT use characters of any alphabet other than Latin in the three-letter identifier of the infobases included in the distributed database.

2. Be aware that disabling sort order identity checks can lead to unexpected for the 1C program!the order of the lines, for example, when generating reports.

Troubleshooting 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 sort order!" the above methods will not work.

We'll have to go the other way:

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

2. Drop down list In mode select Configurator >OK.

3. Run Configurator. Select menu Administration > Code page of IB tables

4. In the window Code page of infobase tables select from the dropdown list + Current setting >OK.

Top Related Articles