Hi,
I forgot to mention. this happens only for Japanese characters. If in the same
database, a record is added with english characters this query gets that record name.
Its not working only for the Japanese characters.
Thats what confuses me and we cannot test it out here as we cannot type the japanese
characters.
Regards,
Ragu
--
On Thu, 19 Apr 2001 19:26:19
Palgrave, Greg wrote:
>
>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
>
>
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
