Found in any pb11.5, 12.5 in reading sql2008 data, read the BIT type 1 to 1

When connecting sql2014 charindex parameters (parameter 1, 2), 2 types of error parameters can't be a TEXT, but the parameter sequence and Pb chaindex pos function is the opposite!

How to solve?

CodePudding user response:

The first question, the database can not use bit types,

CodePudding user response:

With an odbc connection directly try

Or don't use bit database type, use char (1) can also

Try the pos directly