Case sensitive and special characters
Posted in 2007
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life
Hi, I'd like to know how to keep and read information in my IDS 10.x, case sensitive and using some special characters like "ç", and "´", "`", "^", "~", words used in the Portuguese language. With informix 4GL is not necessary, but with some others ways to keep this information and retrieve, by example the "Paulão" word in past I used "PAULAO" and now I´m needing to do several researches like "PAULAO", "Paulao", "paulao", "PAULÃO", etc tks all henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br ________________________________________________________________________________ ____ Novo Yahoo! Cadê? - Experimente uma nova busca. http://yahoo.com.br/oqueeuganhocomisso
Did you tried by setting CLIENT_LOCALE, DBLOCALE accordingly the characters which you are trying to read ? - Ravi. henrique lima - yahoo <henrique_lima_2000@yahoo.com.br> wrote: Hi, I'd like to know how to keep and read information in my IDS 10.x, case sensitive and using some special characters like "ç", and "´", "`", "^", "~", words used in the Portuguese language. With informix 4GL is not necessary, but with some others ways to keep this information and retrieve, by example the "Paulão" word in past I used "PAULAO" and now I´m needing to do several researches like "PAULAO", "Paulao", "paulao", "PAULÃO", etc tks all henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br ________________________________________________________________________________ ____ Novo Yahoo! Cadê? - Experimente uma nova busca. http://yahoo.com.br/oqueeuganhocomisso ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Download prohibited? No problem! CHAT from any browser, without download.