DB character set

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Wed, 05 Feb 2003 13:20:02 -0800
Message-ID: <F001.00544FBC.20030205132002@fatcity.com>

Dear List,

Life was pretty easy here before they came up with this euro symbol :-( We had WE8ISO8859P1 (the default I bevieve) as a char set on all Unix and MS (sorry we have those as well) DBs accross the board. That was also the client side char set (part of NLS_LANG) - most clients here are on MS (code page 1252), some browser based.

Well, with euro it looks like they went different directions:
- On MS: it's recommended to have WE8MSWIN1252 (super
set of good old WE8ISO8859P1)
- On Unix: it's WE8ISO8859P15

My question is:

1. if I want to stick with one char set accross the board (as we have now) for all DBs on Unix and MS AND
2. avoid (automatic, but not free) conversion on DB-Client Net communication AND
3. we need euro symbol

is there a painless solution out there?

Thanks,
Boris Dali

---

Post your free ad now! http://personals.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  INET: boris_dali_at_yahoo.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 05 2003 - 15:20:02 CST