| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL query failing |
« View previous topic :: View next topic » |
| Author |
Message
|
| raghubodduluru |
 Posted: Mon Apr 07, 2014 2:45 am Post subject: ESQL query failing |
 |
|
Newbie
Joined: 26 Mar 2014
Posts: 3
|
Hello All,
When we use the chinese characters in a comparision (LIKE or =) and using the ESQL command PASSTHRUfrom the message broker its not returning any results.
However, debugging in the line where it calls the DB and copying the variable that contains the query text and running exactly the same query in Oracle SQL Developer, it returns the results.
We are using ODBC Datadirect V6.0 drivers for Oracle to connect to our Oracle database. Our odbc.ini contains UNICODE=UTF-8 in it.
The sample query is below.
SELECT ESB.QTE_QUOTE_HEADER.QUOTE,
ESB.QTE_QUOTE_HEADER.PROCESS_ID,
ESB.QTE_QUOTE_HEADER.QUOTE_REFERENCE
FROM ESB.QTE_QUOTE_HEADER
WHERE ESB.QTE_QUOTE_HEADER.SALES_TERR_MAIN_CDE IN ('ATM', 'ATM', 'CC', 'EC', 'CPI', 'ECI', 'ECM', 'CG', 'NEC', 'NC', 'NWC', 'NCM', 'SC', 'SWC')
AND ((LOWER(ESB.QTE_QUOTE_HEADER.CUSTOMER_NAME) = '江苏恒立高压油缸股份有限公司')
OR (LOWER(ESB.QTE_QUOTE_HEADER.CUSTOMER_BILL_TO_NUMBER) = '江苏恒立高压油缸股份有限公司')
OR (LOWER(ESB.QTE_QUOTE_HEADER.CUSTOMER_SHIP_TO_NUMBER) = '江苏恒立高压油缸股份有限公司'))
AND (LOWER(ESB.QTE_QUOTE_HEADER.QUOTE_USER_NAME) = 'debankur.chatterjee'
OR LOWER(ESB.QTE_QUOTE_HEADER.QUOTE_USER_NAME_FULL) = 'debankur.chatterjee')
AND (LOWER(ESB.QTE_QUOTE_HEADER.STATE) <> 'dropped')
ORDER BY ESB.QTE_QUOTE_HEADER.QUOTE_REFERENCE,
ESB.QTE_QUOTE_HEADER.QUOTE_REVISION
Could you please help in finding the problem ?
Thanks,
Raghu |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Mon Apr 07, 2014 3:36 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
What effect does the LOWER operation have on the data when chinese characters are used?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon Apr 07, 2014 6:23 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
In the WMB toolkit, go to Window/Preferences/General/Workspace.
What is the 'Text file encoding' property set to? It should probably be 'UTF-8' if you are using Chinese characters in your ESQL.
Note that there may be other text encoding settings elsewhere in the Preferences ( I don't know whether the ESQL editor has its own property for text encoding ).
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
