Community
    • Login

    The problem with SQL syntax highlighting with Cyrillic identifiers.

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    6 Posts 3 Posters 3.9k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • TroshinDVT
      TroshinDV
      last edited by

      Now I get a picture with backlight.
      http://s017.radikal.ru/i431/1602/55/2156f0332f2f.png

      What to do? :(

      Claudia FrankC 1 Reply Last reply Reply Quote 0
      • Claudia FrankC
        Claudia Frank @TroshinDV
        last edited by

        Hello @Дмитрий-Трошин,

        you refer to line 15 don’t you?

        If so, use settings->style configurator->global styles->current line background and change the background color to white.

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0
        • TroshinDVT
          TroshinDV
          last edited by TroshinDV

          Excuse me, but the problem is the blue illuminated red. Red letters in the field identifiers and table names. Add a picture to illustrate the situation.
          http://s019.radikal.ru/i615/1602/b8/6648adea6afa.png

          ( Простите, но проблема в лишней подсветке красным. Красные буквы внутри идентификаторов полей и названий таблиц. Добавил картинку для пояснения ситуации. )

          Claudia FrankC 1 Reply Last reply Reply Quote 0
          • Claudia FrankC
            Claudia Frank @TroshinDV
            last edited by

            @Дмитрий-Трошин

            looks like this is an issue of the sql lexer. I tried different lexers and half of them do show the letters correctly,
            whereas the other half color some of the letters.

            Cheers
            Claudia

            1 Reply Last reply Reply Quote 0
            • glennfromiowaG
              glennfromiowa
              last edited by

              This is just a guess (sorry, not familiar enough with Cyrillic languages to test myself), but does the encoding of the file have anything to do with it? The older version of Notepad++ says ANSI, so if you select on the Encoding menu, Convert to ANSI, does that change anything?

              Claudia FrankC 1 Reply Last reply Reply Quote 0
              • Claudia FrankC
                Claudia Frank @glennfromiowa
                last edited by Claudia Frank

                Hello @glennfromiowa,

                in general, yes, but if one uses cyrillic letters I assume that he/she uses the appropriate encoding as well
                otherwise the chars aren’t displayed correctly anyway. In my case I used utf-8 and when comparing different
                lexers I can see that they behave differently. When putting all chars from 0x400 - 0x4ff in an document
                I would assume that these chars are black foreground and white background (my default setting),
                which is what is done.

                Now selecting e.g. SQL lexer, parts of the chars get colored blue while the rest stays black - not expected,
                all should still be colored black as the chars aren’t SQL keywords.
                When using python lexer anything is colored black again.

                Unfortunattely, there isn’t a pattern which chars get colored wrongly. Part of the lexers coloring the same
                chars incorrectly, whereas other lexers color other chars wrongly.

                Cheers
                Claudia

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post
                The Community of users of the Notepad++ text editor.
                Powered by NodeBB | Contributors