Using 'extended' characters in SQLplus

From: Albert <no_spam_contactemt_at_bigfoot.com>
Date: Thu, 10 Oct 2002 08:16:59 +0100
Message-ID: <ao39f5$qjc$1@newsg4.svr.pol.co.uk>

Hi,

I'm using Oracle on Windows.

I thought it would be nice to be able to query on '1/4'.'1/2' etc as a character, so I have converted the database to this character set.

Now when I log into SQLPlus how do I input these characters ? Do I have to convert the default Windows character set somehow ?

Also I am using ODBC & C++ to insert into the DB. How do I insert these extended characters ?

For example my raw data contains the html "frac12;" for "1/2" how do I convert this to the WE8ISO8859P1 "1/2" ?

Many thanks!

PS Duplicates "Using WE8ISO8859P1 succesfully ?" post which people mightn't read :) Received on Thu Oct 10 2002 - 02:16:59 CDT