Changing comment line character in Notepad ++ langs.xml not working

Question

My company uses # comments for SQL, but the language syntax in Notepad ++ for SQL displays the comment line character as. I want to change my comment line character to #.

Everywhere I looked, it is recommended to edit C: \ Users \\ AppData \ Roaming \ Notepad ++ \ langs.xml, find the correct language tag in this file and change it to the character I want. The problem is that when I do this, nothing changes.

Here the corresponding line is copied and pasted from my langs.xml file:

<Language name="sql" ext="sql" commentStart="/*" commentEnd="*/" commentLine="#"> ... 

After making this change, I read Notepad ++ again (a couple of times), tried to open a new .sql file and apply the language style to it, switched the language to something else and back to SQL. No matter what I do, it still treats it as a comment character, even if the comment character is set to # in langs.xml.

Close / open Notepad ++ does not coincide with a "restart"? Can I make it reload the langs.xml file?

Answer 1

I had a similar problem, and updating the langs.xml file in both AppData folders and the installation did not work. In the end, I realized that he was using the Settings → Settings → Clouds → Settings on the cloud, so he used the configuration file stored in the Notepad ++ folder in the root of my DropBox. I updated this version of the file (I started Notepad ++ as an administrator) and it raised it when the program was reloaded.