Skip to Content
author's profile photo Former Member
0
Former Member

Select with a string with accent

Posted on Dec 16, 2004 at 11:56 AM 48 Views

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Klaus Ziegler
    Klaus Ziegler
    Posted on Dec 16, 2004 at 12:07 PM
    2

    Hello Oscar,

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

    Regards

    Klaus

    Add a comment
    10|10000 characters needed characters exceeded

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

    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.