Re: Need help on character set selection!

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 28 Oct 1999 12:18:31 -0700
Message-ID: <3818A187.A5D9181C@vnl.nl>

Wei Liu wrote:

> Hi,
>
> I need to store and display the characters in the extended ASCII characterset or ANSI character set, like the superscript TM for trademark and R in the circle for registered. Currently our database is set to US7ASCII and it converted those two characters into question marks. I know we have to choose another character set, but don't know which one would include those two characters. If anyone out there knows the answer, could you please email me at weil_at_mjm.com? Thanks.
>
> By the way the language we are using is AMERICAN_AMERICA. Server is Oracle 8.
>
> WL.

AFAIK, any 8 bit char set will do. Representation depends on the client. If you're displaying data on the web, you would store &gt, and not >, to give an example. WE8ISO8859P1 or WE8DEC seem reasonable charactersets, based on the location of your firm

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Thu Oct 28 1999 - 14:18:31 CDT