Hi!!!

I have a linked server to Oracle 8.05. It's working.
i.e.
SELECT CPF FROM OPENQUERY
(ORAPROD, 'SELECT pf.CPF as CPF
FROM DBACDL.CADASTRO_MOVIMENTO mov, DBACDL.CDL_PF pf
where pf.codpf = mov.codpf')

I would like compare the result this SELECT with a table in the SQL-Server 2000.
i.e.
select CODPF, PF, CPF FROM DBACDL.CDL_PF
WHERE CPF in (SELECT CPF FROM OPENQUERY
(ORAPROD, 'SELECT pf.CPF as CPF
FROM DBACDL.CADASTRO_MOVIMENTO mov, DBACDL.CDL_PF pf
where pf.codpf = mov.codpf'))

When I execute this instruction, the SQL Query Analyser shows:

Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.


AMERICAN is set in the NLS_LANGUAGE Oracle configuration.
What can choose COLLATION NAME in the SERVER OPTION propeties?

Thank you.