const char*, extern const char*, My Custom Library

A #define statement's scope is limited to the compilation unit it is defined in.

A sketch is one compilation unit. A library is one or more compilation units.

You can not define a name in one compilation unit and expect it to influence another compilation unit, unless you define it in a header file included in both compilation units.