Quote: "now I am confused, what should happen when using ""BAR"" ?"
No idea.

[Actually, I assume the compiler should replace BAR with whatever follows BAR in its constant definition so
#constant BAR 123 should mean that
""BAR"" gets replaced by
""123"" before further compiling occurs. How DBPro interprets that is anyone's guess - and Benjamin guesses (knows?) that it is a string whose value is "123" (i.e. the inner quotes are characters in the string). But I'm guessing now.
But it should be consistent and easily predictable if nothing else - which it plainly isn't.