Chinese conditions cannot be queried in oracle

Chinese conditions cannot be queried in oracle

However, the following statement cannot find records with Chinese characters:

Select drdl01 from prodctl. F0005 where trim (drdl01) like 'China, China % ';

View the current database character set:

SQL> SELECT * FROM v $ nls_parameters where parameter = 'nls _ CHARACTERSET '; PARAMETER VALUE -------------------- NLS_CHARACTERSET ZHS16GBK

Check the character set of the client:
<Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> VcD4NCjxwPjxjb2RlIGNsYXNzPQ = "hljs SQL"> Obviously, the client character set is inconsistent with the database character set. You need to modify the client character set.
Search for NLS_LANG on the client server and change WE8MSWIN1252 to ZHS16GBK. Three modifications are required in total. After the modification, logoff and re-login are enabled.