topic Re: Name case sensitive in Application Development and Automation Discussions

Name case sensitive

Former Member — Mon, 23 Apr 2007 20:11:16 GMT

Hi frnds

When i am trying to pull the customers based on the customer names. The name field in kna1 in the database it is pulling based on the case sensitive. Why is it happening? Is there any way we change any settings?.

Thanks

Satya

Re: Name case sensitive

Former Member — Mon, 23 Apr 2007 20:17:29 GMT

Hi,

Yes..It is case sensitive...Check the domain...The lower case flag is on for KNA1-NAME1...

If the flag is on..Then it will store all the records in the case given..

Otherwise..It will store in capital letters..

So in your case..I am sure there is no settings..

In your where clause...Give in both the cases..

Thanks,

Naren

Re: Name case sensitive

Former Member — Mon, 23 Apr 2007 21:17:53 GMT

But i am not searching in the program.

I opened VD03 and then F4 and searched by name. When i do this i am getting only case sensitive names, like for example

if i type randy i am getting only names that are in small letters of that name.

if i type RANDY i am getting only names that are in capital letters of that name.

What can i do to avoid this. I need to get all names it should not check case.

Is there any way i can do that?.

Thanks

Satya

Re: Name case sensitive

Former Member — Mon, 23 Apr 2007 21:20:50 GMT

Hi,

I am not sure if there is a way around for this..

Thanks,

Naren