SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

matching the strings of chinese characters in where clause of query.

522827Jul 12 2006 — edited Jul 12 2006

I want to retreive data from table which stores the chinese names for corresponding english name.
but normal select statement is not working

select eng_name from name_data where chinese_name like ('chinise characters')

but i can retrieve the chinese name based on its english name.

I am running this query in PB application. Database is connected through (Oracle) ODBMS connection. (Character set of PC and DB is same)

Can anybody help me in improvising the query? i feel if I could put a strong expression in where clause for selection then, it might run.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2006

Added on Jul 12 2006

2 comments

629 views