Skip to Content
author's profile photo
Former Member

Select with a string with accent

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

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Dec 16, 2004 at 12:07 PM

    Hello Oscar,

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

    Regards

    Klaus

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Dec 16, 2004 at 12:07 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded