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
