Raghu,
One suggestion if you have not thought of it already: Try to make sure that
:EMPNAME does not have leading or trailing spaces before using it in the
query.
Abhijit
-----Original Message-----
From: Raghu Raman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 12:13 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: DBCS Problem
Hi all,
We have a DB2 System using Japanese language.
When we do a query like "select * from employee where UCASE(empname) like
UCASE(:EMPNAME) it returns no records.
(:EMPNAME value comes from our application)
But when i do "select * from employee" i could see the record.
The query couldn't be given out here in US as our keyboards are not
configured for Japanese. The other team in Japan complains that they are
unable to get the records.
Our database parameter values are
Database territory = US
Database code page = 1208
Database code set = UTF-8
Is there any settings problem or should i change the query to something else
?
any help would be appretiated.
Thnx.
Regards,
Ragu
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
