SQL Wave Char
Today, My colleague asked me a question that Entity Framework will generate SQL and has ESCAPE '~' at the end of the SQL. SELECT * FROM T WHERE Title LIKE 'foo%' ESCAPE '~' After the survey, some of the article that the only things we knew it is ESCAPE are used to query the data has Universal characters.There are no articles about "~".Through some of the testing, we found it represented all of the Universal characters.Which means you may be used ESCAPE '%_[^' to query has the data include it then you can just use ESCAPE '~' to replace it. SELECT * FROM T WHERE Title LIKE 'foo%' ESCAPE '%_[]^' equal SELECT * FROM T WHERE Title LIKE 'foo%' ESCAPE '~'
