Special characters in Notepad++



  • 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



  • 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



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



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



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


Log in to reply