FAQ: Search results containing the Chinese numeral zero are incorrect in a SQL Server environment
## Answer
SQL Server specifications.
---
## Answer
In a SQL Server environment, searching for values that contain the Chinese numeral 〇 (zero) may not return the expected results. When searching, the Chinese numeral 〇 (zero) is considered to be a null character. For example, if you search for "三〇一" using the search criteria of like, not only "三〇一" but also "三一" and "三〇〇一" will be included in the search results and output. Also, items that contain only the Chinese numeral 〇 (zero) are considered to be unset (empty).
This phenomenon is an SQL Server operation specification.
## Related Information
[Searches that contain the Chinese numeral 〇 (zero) do not return correct results in an environment using SQL Server dictionary order collation - Microsoft Support](https://support.microsoft.com/ja-jp/topic/sql-server-%E3%81%AE%E8%BE%9E%E6%9B%B8%E9%A0%86%E7%85%A7%E5%90%88%E9%A0%86%E5%BA%8F%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E7%92%B0%E5%A2%83%E3%81%A7-%E6%BC%A2%E6%95%B0%E5%AD%97%E3%81%AE%E3%80%87-%E3%82%BC%E3%83%AD-%E3%82%92%E5%90%AB%E3%82%80%E6%A4%9C%E7%B4%A2%E3%81%8C%E6%AD%A3%E3%81%97%E3%81%84%E7%B5%90%E6%9E%9C%E3%82%92%E8%BF%94%E3%81%95%E3%81%AA%E3%81%84-23374a9c-32e7-e026-52cb-d54aff0db8f9)