Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Special characters in Notepad++

    General Discussion
    2
    5
    4680
    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.
    • Murray Sobol
      Murray Sobol last edited by

      I have a table defined as:
      CREATE TABLE a1_error_handler
      (
      error_code char(9) not null,
      language_code varchar2(10) DEFAULT ‘EN’ not null,
      title_nbr number(5) not null,
      description varchar2(500) not null,
      CONSTRAINT pk_a1_error_handler PRIMARY KEY (error_code, language_code)
      using index
      tablespace smartsoft_index
      )
      tablespace smartsoft_data
      /

      It contains data as follows:
      ‘400MX0146’,‘EN’,17,‘A file name can’‘t contain any of the following characters: \ / : * ? " < > |’
      Notice the special characters: \ / : * ? " < > |
      How do I define them in Notepad++ (or add to them)??

      Thanks
      Murray

      Claudia Frank 1 Reply Last reply Reply Quote 0
      • Claudia Frank
        Claudia Frank @Murray Sobol last edited by

        Hello @Murray-Sobol,

        what do you mean by

        How do I define them in Notepad++ (or add to them)??

        ??
        In regards to coloring in SQL?
        Or do you have problems adding datasets containing such chars to the table?
        Then it isn’t a npp question rather than a SQL or database question.

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0
        • Murray Sobol
          Murray Sobol last edited by

          In regards to coloring them…
          If I add a few more special characters I would like to see them also colored.

          Claudia Frank 1 Reply Last reply Reply Quote 0
          • Claudia Frank
            Claudia Frank @Murray Sobol last edited by

            Hello @Murray-Sobol,

            well it depends, when using a UDL then you can easily add it to the already configured keyowrds/operators etc… by using the Language->Define your language and select the proper UDL.
            When using a builtin lexer than you can only add it as keywords by using
            Settings->Style Configurator->Select the lexer and fill in user defined keywords.

            1 Reply Last reply Reply Quote 0
            • Murray Sobol
              Murray Sobol last edited by

              I used the Style Configurator to add keywords like MERGE etc for SQL
              Thanks Claudia

              1 Reply Last reply Reply Quote 0
              • First post
                Last post
              Copyright © 2014 NodeBB Forums | Contributors