Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Guanajuato, Mexico
    Posts
    8

    Question Unanswered: matchs accented strings

    how do maths of accented strings with not accented strings, something like accent-insensitive.
    so Andres and Andrés they are equivalent

    select name from employees where name like "Andres%"
    results
    Andres Palacios
    Andrés Perez
    Andres Lopéz
    Andrés Sanchez

    this I need

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hola Moespi,

    Esto depende del GLS que estes usando en la base de datos, por favor chequea la variable BD_LOCAL o prueba definiendo la variable DBNLS=[0|1|2]

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •