Home » RDBMS Server » Server Administration » ANY IDEAS WHY ?? I would really appreciate
ANY IDEAS WHY ?? I would really appreciate [message #370415] Wed, 22 September 1999 15:01
m a sivan
Messages: 34
Registered: July 1999
Member
SELECT PNET_TAB_PERSON.FMNO, PNET_TAB_PERSON.FIRST_NAME, PNET_TAB_PERSON.LAST_NAME, PNET_TAB_PERSON.DENORM_STATUS, PNET_TAB_PERSON.DENORM_DEPARTMENT_CODE
FROM PNET_TAB_PERSON
WHERE (((PNET_TAB_PERSON.LAST_NAME) Like "Müller";

FMNO FIRST_NAME LAST_NAME DENORM_STATUS DENORM_DEPARTMENT_CODE
11175 Kristina Müller Active 3250
15125 Ruth Müller Active 3310
99133 Jürgen Müller Alumni 000
2473 Michael Müller Active 2505
3285 Alfred Müller Alumni 000
19576 Ralph Müller Active 1200
20009 Markus Müller Active 1200
20006 Birgit Müller Alumni 000
21063 Hilke Müller Active 1200
21099 Stefanie Müller Active 3210
23946 Verena Müller Alumni 000
26615 Andreas Müller Active 1200
28590 Dietmar Müller Active 1200
Torsten Prochnow Offer Accept 1200
28986 J. Felix Müller Active 3210
611 Patrick Müller Alumni 000

When I execute the Query from Oracle it works fine but when I run from ACCESS link it gives me LAST_NAME of persons other than "Müller" too.
I am using ebcdic character set which access also supports (unicode)..
It works fine with EXcel and microsoft Query but access fails . why and how to rectify ??
Previous Topic: Re: PL/SQL8 Call to C Shared libraries
Next Topic: difference in primary key vs unique+not null
Goto Forum:
  


Current Time: Tue Oct 20 10:18:10 CDT 2020