Shulou(Shulou.com)06/01 Report--

Problem: query database statement reported an error "the data types text and varchar are not compatible in the equal to operator."

Resolve:

Select * from table name

Where cast (field name of the query as varchar (max)) = 'value of the query'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.