I import the oracle customized embedding model ALL_MINILM_L12_V2 into 23ai free successfully. If all the data in table is in English, the vector search is good and returns expected result. but if the data is in Chinese, the APEX vector search will return nothing with error message in debug as below.
The query shown in debug:
select /*+qb_name(apex$102_7)*/i.*
from (select i.*,(SCORE(1)) "APEX$ORATEXT_SCORE"
from(select /*+ qb_name(apex$inner) */* from(select x.* from "EMP" x
where contains("V_COL",:apex$f1,1)>0
)d
)i
)i where 1=1
Error Message:
Error Stack: ORA-29900: The call to operator CONTAINS does not match operator bindings.
ORA-06553: PLS-306: wrong number of types of arguments in call to 'CONTAINS'
