User Manual

08.14.2024

MANUAL

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)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.