Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Search problem in ANLA table for serno field when text is in Cyrillic

Former Member

‎2007 Apr 06 5:01 PM

0 Kudos
142

Hi guys,

I've encounter the following problem.

I've made an search help on ANLA table for serial number field.

The problem occurs when you put some search pattern like "<some Cyrillic symbols>"

What is observed:

when pattern is only "*" there is some data in result.

when afterwords you put the pattern like "<some Cyrillic symbols>"

where in "<some Cyrillic symbols>" you put the part of character returned from the "*" query there no any result (0 records found).

The same behaviour can be observe when you use transaction n for tabla ANAL and putting the same filters for serial number.

In my not related with SAP experience this problem is usually because there is an problem whit SQL encoding collation or with database query ( written with bad encoding collation).

The the database is oracle 9 with last upgrade from SAP, the SAP itself is with Unicode instalation for SAP 6.40.

So the question is do you have the same problem and is there an solution for it?

Thanks in advance Ogi

1 REPLY 1

Former Member

‎2007 Apr 10 2:30 PM

0 Kudos
52

The problem occures not becouse of cyryllic but, becouse that in serialno domain you can not use small caps. And some of my data is with small caps (becouse of automatic data transfer).