topic Re: Select with a string with accent in Application Development and Automation Discussions

Select with a string with accent

Former Member — Thu, 16 Dec 2004 11:56:21 GMT

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 --

Re: Select with a string with accent

former_member183804 — Thu, 16 Dec 2004 12:07:15 GMT

Hello Oscar,

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

Regards

Klaus

Re: Select with a string with accent

Former Member — Thu, 16 Dec 2004 12:07:37 GMT

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.