Select with a string with accent

[Former Member]

Hello

I have a select where I do:

SELECT SINGLE tipcu

INTO tmp

FROM ZMTVTIPO

WHERE zztipo EQ cadena AND

tipcu = wa_material-tipcu.

where "tipcu" has a type numc of 2 characters and zztipo is a char of 20 characters and both belong to the primary key of ZMTVTIPO.

My problem is that the strings of zztipo are words in spanish and some of them have accents. When "cadena" does not have a word with accent it works properly and it matches but when "cadena" conteins one of those words with accent the select does not match.

might anyone help me?

Thanks in advanced.

-- Oscar --

[former_member183804]

Hello Oscar,

is the logon language during storing the same as during retrival ?

Regards

Klaus

[Former Member]

Since you say, you have words with Spanish, I suggest you have a field called <b>SPRAS</b> of type <b>LANGU</b> in the table. One of the probable reasons, why it wouldn't match would be that character does not fall in the English alphabetical set or the default language, that you are using.

Let us know, if this works.

Regards,

Subramanian V.