I've been informed that:

CharacterSet is set as follows:

If the project adds a _UNICODE preprocessor definition, the CharacterSet is Unicode. If the project adds a _SBCS preprocessor definition, the CharacterSet is NotSet. Otherwise, the CharacterSet is MultiByte.

so

target_compile_definitions(example PRIVATE _SBCS)

should do the job.