cancel
Showing results for 
Search instead for 
Did you mean: 

Umlaute (ö, ä, ü, ß) as filter in oData service

Former Member
0 Kudos

Hi guys,

how can I handle for example german special chars in a oData call? When I do the oData call, I get no data back from it because in the backend there is no entry found in the database.

For example in a filter statement:

When I console.log the string it is: /sap/opu/odata/sap/J_8I_MCAPP_SRV/bedatawuSet/$count?$filter=Datkr eq 'CKM' and BeCode eq 'CMWANNEFÜLLEN'

At the get request which is send to the backend it is:

/sap/opu/odata/sap/J_8I_MCAPP_SRV/bedatawuSet/$count?$filter=Datkr%20eq%20%27CKM%27%20and%20BeCode%20eq%20%27CMWANNEF%C3%9CLLEN%27

At the backend I get for the corresponding filter attribute:
CMWANNEFA#LLEN

So how can I handle this?

Thank you in advance,

Bastian

Accepted Solutions (0)

Answers (2)

Answers (2)

pfefferf
Active Contributor
0 Kudos

Hello Bastian,

for that cases you have to replace the "Umlaut" by the corresponding Unicode representation:

  • Ä = \u00c4
  • ö = \u00e4
  • Ö = \u00d6
  • ö = \u00f6
  • Ü = \u00fc
  • ß = \u00df

Regards,

Florian

SergioG_TX
Active Contributor
0 Kudos
Former Member
0 Kudos

I have to use the umlaute in a filter variable and don't want to show them in the frontend.

In another case, I have a table with a binding. When I want to filter this table with attributs containing for example 'ß', no data is found although data should be found.