• Login
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.
  • T
    TroshinDV
    last edited by Feb 2, 2016, 11:53 AM

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

    What to do? :(

    C 1 Reply Last reply Feb 2, 2016, 12:53 PM Reply Quote 0
    • C
      Claudia Frank @TroshinDV
      last edited by Feb 2, 2016, 12:53 PM

      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
      • T
        TroshinDV
        last edited by TroshinDV Feb 2, 2016, 2:39 PM Feb 2, 2016, 2:38 PM

        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

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

        C 1 Reply Last reply Feb 2, 2016, 7:01 PM Reply Quote 0
        • C
          Claudia Frank @TroshinDV
          last edited by Feb 2, 2016, 7:01 PM

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

          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
          • G
            glennfromiowa
            last edited by Feb 4, 2016, 2:24 PM

            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?

            C 1 Reply Last reply Feb 4, 2016, 4:38 PM Reply Quote 0
            • C
              Claudia Frank @glennfromiowa
              last edited by Claudia Frank Feb 4, 2016, 4:39 PM Feb 4, 2016, 4:38 PM

              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
              6 out of 6
              • First post
                6/6
                Last post
              The Community of users of the Notepad++ text editor.
              Powered by NodeBB | Contributors