How to make the character not drop in the scene when the character has NoCollision attribute?

With drop you mean falling through everything?

Set useGravity to false.

GravityScale is 0.0?

nope… just switch the useGravity Option in the Physics Tab of the Defaults to false… This Option is called Enable Gravity.

See:
Unbenannt