Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: EXTENDED CHARACTERS
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D0E4895.D13FB2B8_at_exesolutions.com...
> Sylvain Dumont wrote:
>
> > the bug is coming only when i select "ENABLE EXEC SYNTAX" IN THE DSN
> > (SQLSERVER MIGRATION SECTION) ... i try with Shema Database,Owner and
Empty
> > and i got always the same problem
> >
> > exec KSP_TEST 0,'TéEST'
> > ------------------------>>>>>>>NOT WORKING.
> > BUT IF I WRITE
> > CALL KSP_TEST (0,'TéEST')
> > ------------------------->>>>IS WORKING
> >
> > the call statement work and the exec statement does'nt work..the
probleme is
> > NOT the nls_lang becausse the é work with the call statement.
> >
> > you can make the test with winsql software!!!
> >
> > thank's
>
> I can't say that my French is as good as your English. But I see the name
SQL
> Server and I do not see the word Oracle. What does this have to do with
> comp.databases.oracle.misc?
>
> Daniel Morgan
>
He is using Oracle as database, any Oracle ODBC driver, and the syntax above. His diacritical characters end up as bogus. He insists there is a bug in *all* Oracle ODBC drivers. Metalink doesn't show any bugs with respect to ODBC and NLS. Guess it is his dsn mangling that is causing it, but I don't think he will believe that. Someone should reproduce this in a 'clean' Oracle environment.
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Mon Jun 17 2002 - 16:33:33 CDT