Existing in the database table contains "?" How the data query of the characters and repla-CodePudding

SQL server 2008 data tables contain "?" Characters, how to use the like query find out these data containing specific characters, trouble which great god solve, thank you

CodePudding user response:

This will change the language set, it is suggested that using SQL_Latin1_General_CP1_CI_AS collation,
Resources for https://docs.microsoft.com/zh-cn/sql/relational-databases/collations/collation-and-unicode-support? View=SQL server - 2017

Then contrast ASCII query,

CodePudding user response:

Due to the change of collation is the operation of the database level, it's best to create a new database, the original database guide to come over and then to query operations such as,

CodePudding user response:

Thank you, I try