We are all learning 
What the TEXT macro does is insert a “L” before string literals if we are under a Unicode/Multibyte build and nothing when under ANSI.
All it does is tell the compiler what values to put there.
The end result is that you can use the “TEXT” macro to make it simple to create string literals of whatever character set you are using.
HTH