Re: ODBC Character Translation

> > > Hi!
> > > When I try to duplicate a tree structure in my db, some characters
> > > turn out wrong. Bulleted lists, and 'Registred Trademark'-'R's for
> > > example. They become something like an upside-down question mark. I
> > > have narrowed it down to the ODBC layer, but I can't seem to find any
> > > info about it.
> >
> > So you can insert these characters correctly when you connect via
> > SQL*Plus? This ensures that your database character set supports
> > them.
> >
> > Which ODBC driver are you using? Assuming you're using the Oracle
> > driver, what are your NLS settings?
>
> Yes, I can. In fact, I copied a part of the tree structure via an asp
> script and the originals were all populated with these characters
> coorectly, but the copies got those weird signs.
> I'm using Oracle Provider for ODBC (don't know which version though)

There's a product called "Oracle Provider for OLE DB" and one called "Oracle ODBC Driver". Which do you have? I'd suggest going to OTN to grab the latest version for your client.

> and all settings are default.

Can you post your NLS settings? There are different defaults possible.

> This means the the db itself can handle the characters, but ODBC
> cannot write them (or get them).

Are you sure you're using the Unicode ODBC API rather than the ASCII API? Justin Received on Tue Jan 28 2003 - 19:22:33 CET