SOCI doesn't compile when using the `UNICODE` flag on Windows

[Krzmbrzl]

SOCI doesn't compile when using the `UNICODE` flag on Windows

[vadz]

Why do you need to compile SOCI itself with UNICODE defined? Note that you can compile the application including SOCI headers with it being define just fine, of course.

[Krzmbrzl]

I tried undefining UNICODE for the SOCI part but got redefinition errors of some Windows API functions - I'm using static linkage. Maybe I need only refine my approach to make things work though 👀

In any case I was wondering whether it would make sense for SOCI to deal with this somehow - even if it is only a check whether this macro is defined and emitting an error stating that compiling SOCI with UNICODE is not supported. That'd already make things easier for downstream users as they don't have to wonder where that compile error is coming from.

[vadz]

FWIW I agree that the simplest fix would be to use A variants of all A/W functions and hope that everybody uses UTF-8, which should work on all non-ancient Windows systems.