Just to expand on that, as you are using LIKE, if your host variable is say
CHAR(8) and you move "ABCD%" to it then in many cases the host variable is
automatically right-padded with spaces (COBOL and PL/1 certainly, probably
many others) and actually contains "ABCD% " (3 spaces on the end).
Make sure in your code to pad your data with the % wildcard e.g. your host
variable in this case would contain "ABCD%%%%" and that might fix your
problem.
Regards,
Greg Palgrave
Database Administrator
Shared Services
Unisys WEST
Ph : (08) 9449-3810
Fax : (08) 9449-3795
eMail : [EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED]@BANKWEST On Behalf Of
> "Sinha, Abhijit" <[EMAIL PROTECTED]>@BANKWEST
> Sent: Friday, 20 April 2001 02:06
> To: [EMAIL PROTECTED]
> Subject: RE: DB2EUG: DBCS Problem
>
> 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
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
