Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Select returns not all rows

    Example:
    create table Test (UKey serial, Names char (80))
    insert into Test values (1000, 'Dr. Möller GmbH')
    insert into Test values (1001, 'B. Möllers AG')

    statements OK:
    SELECT t1.Names, t1.UKey FROM Test t1 WHERE ( t1.Names MATCHES '* Mölle*' )
    SELECT t1.Names, t1.UKey FROM Test t1 WHERE ( t1.Names MATCHES '*Möll*' )

    statements not OK (they only return one row (UK=1000)):
    SELECT t1.Names, t1.UKey FROM Test t1 WHERE ( t1.Names MATCHES '*Mölle*' )
    SELECT t1.Names, t1.UKey FROM Test t1 WHERE ( t1.Names LIKE '%Mölle%' )

    I work on a Informix Dynamic Server 2000 Version 9.21.TC1. Dones anyone has an idea, whats happen here or where to solve that problem?

    TIA Christian

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    Would appear that this is a windows issue. Your example works with 9.21 uc2.
    Fred Prose

Posting Permissions

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