Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!diablo.theplanet.net!news.theplanet.net!not-for-mail From: "Albert" Newsgroups: comp.databases.oracle.misc Subject: Using 'extended' characters in SQLplus Date: Thu, 10 Oct 2002 08:16:59 +0100 Lines: 23 Message-ID: NNTP-Posting-Host: modem-71.ohio.dialup.pol.co.uk X-Trace: newsg4.svr.pol.co.uk 1034234149 27244 62.137.86.71 (10 Oct 2002 07:15:49 GMT) NNTP-Posting-Date: 10 Oct 2002 07:15:49 GMT X-Complaints-To: abuse@theplanet.net X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: newsfeed1.easynews.com comp.databases.oracle.misc:87632 X-Received-Date: Thu, 10 Oct 2002 00:16:12 MST (news.easynews.com) 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 :)