HarmonyOS鸿蒙Next中在使用rdb关系型数据库时，遇到中英混合的字段时使用like，contains都不能正确获取到数据

开发者您好，无法复现您的问题，demo如下：

// CommonConstants.ets
import { relationalStore } from '@kit.ArkData';

export default class CommonConstants {
  static readonly STORE_CONFIG: relationalStore.StoreConfig = {
    name: 'RdbTest.db', // 数据库文件名
    securityLevel: relationalStore.SecurityLevel.S1, // 数据库安全级别
  };
  //建表语句，4个属性id，name，age，sarlary
  static readonly SQL_CREATE_TABLE = 'CREATE TABLE IF NOT EXISTS EMPLOYEE ' +
    '(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, AGE INTEGER, SALARY REAL)';

}

import relationalStore from '@ohos.data.relationalStore'; // 导入模块
import CommonConstants from './CommonConstants'
import { ValuesBucket } from '@ohos.data.ValuesBucket';
import { BusinessError } from '@ohos.base';

export default class DBUtil {
  private context: Context = getContext(this) as Context;     //当前环境上下文
  private rdbStore: relationalStore.RdbStore | null = null;    //数据库连接对象

  getRdbStore() {
    relationalStore.getRdbStore(this.context, CommonConstants.STORE_CONFIG, (err, store) => {
      if (err) {
        console.error(`Failed to get RdbStore. Code:${err.code}, message:${err.message}`);
        return;
      }
      //获取数据库对象
      this.rdbStore = store
      //如果表不存在，则建表
      store.executeSql(CommonConstants.SQL_CREATE_TABLE);
      console.info('Succeeded in getting RdbStore.');

    })
  }

  //插入数据
  insertData() {
    let value1 = 'name鹰角网络is';
    let value2 = 35;
    let value3 = 3000.5;
    //数据集，直接读写数据库
    const valueBucket1: ValuesBucket = {
      'NAME': value1,
      'AGE': value2,
      'SALARY': value3,
    };

    if (this.rdbStore !== undefined) {
      (this.rdbStore as relationalStore.RdbStore).insert('EMPLOYEE', valueBucket1, (err: BusinessError, rowId: number) => {
        if (err) {
          console.error(`Failed to insert data. Code:${err.code}, message:${err.message}`);
          return;
        }
        console.info(`Succeeded in inserting data. rowId:${rowId}`);
      })
    }
  }


  //查询
  query() {
    if (this.rdbStore != undefined) {
      this.rdbStore.querySql("SELECT * FROM EMPLOYEE WHERE NAME = '%鹰角网络%'", async (err, resultSet) => {
        if (err) {
          console.error(`Query failed, code is ${err.code},message is ${err.message}`);
          return;
        }
        console.info(`ResultSet column names: ${resultSet.columnNames}, column count: ${resultSet.columnCount}`);
        // resultSet是一个数据集合的游标，默认指向第-1个记录，有效的数据从0开始。
        try {
          while (resultSet.goToNextRow()) {
            const name = resultSet.getString(resultSet.getColumnIndex("NAME"));
            const age = resultSet.getLong(resultSet.getColumnIndex("AGE"));
            const salary = resultSet.getDouble(resultSet.getColumnIndex("SALARY"));
            console.info(`name=${name}, age=${age}, salary=${salary}`);
          }
        } catch (err) {
          console.error(`Query failed, code is ${err.code},message is ${err.message}`);
        } finally {
          // 释放数据集的内存，若不释放可能会引起fd泄露与内存泄露
          resultSet.close();
        }
      });
    }
  }

  queryAll(){
    let predicates = new relationalStore.RdbPredicates("EMPLOYEE")
    this.rdbStore!.query(predicates).then((result) =>{

      while (result.goToNextRow()) {
        const name = result.getString(result.getColumnIndex("NAME"));
        const age = result.getLong(result.getColumnIndex("AGE"));
        const salary = result.getDouble(result.getColumnIndex("SALARY"));
        console.info(`name=${name}, age=${age}, salary=${salary}`);
      }
    }).catch((error:string) =>{
    })
  }
}

如果上述demo无法解决您的问题，麻烦您这边提供如下信息：

1.复现代码（如最小复现demo）；

2.版本信息（如：开发工具、手机系统版本信息）；