I'm working with SQL Server tables that have a mixture of VARCHAR and NVARCHAR columns. Unless I'm mistaken OrmLite currently only supports enabling Unicode strings globally for a given connection. To workaround this constraint I've defined an additional named connection which is configured to UseUnicode, on a service-by-service basis I'm enabling the named connection using the ConnectionInfo attribute. However this means I have to be careful to ensure any db statements don't end up mixing VARCHAR and NVARCHARs - to avoid performance issues with suboptimal index usage.

It would be helpful it properties on the data model could be annotated with an attribute to indicate if they are Unicode - or not.