Special characters in Notepad++

Murray Sobol

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

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

Murray Sobol

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

Claudia Frank

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.

Murray Sobol

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