Xref: alice comp.databases.oracle.server:35806 Path: alice!news-feed.fnsi.net!netnews.com!cpk-news-hub1.bbnplanet.com!news.gtei.net!firehose.mindspring.com!not-for-mail From: Ron Denham Newsgroups: comp.databases.oracle.server Subject: Re: Character set changes on export Date: Sat, 12 Dec 1998 20:40:57 -0500 Organization: MindSpring Enterprises Lines: 47 Message-ID: <36731B29.E82F5662@mindspring.com> References: <3672819d.457483@news.a2000.nl> <36720EA4.FC396EC7@sybrandb.demon.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Server-Date: 13 Dec 1998 01:44:05 GMT X-Mailer: Mozilla 4.06 [en] (Win95; I) I don't think you'll lose any information, however. Anybody care to comment on this? Sybrand Bakker wrote: > Hi Jan, > > Your unix user doesn't have the NLS_LANG environment variable set. In that > case NLS_LANG will default to AMERICAN_AMERICA.US7ASCII. You need to make > sure you explicitly set NLS_LANG in your login scripts to > AMERICAN_AMERICA.WE8ISO8859P1, and the database will be exported > correctly. > > Hth, > > Sybrand Bakker, Oracle DBA > > Jan Dolman wrote: > > > All our databases are configured to use an 8 bit West European > > character set. However, when I export a database, the message > > 'Exporting using US 7 bit character set' appears. I haven't checked > > yet, but I think I will lose all special characters when exporting. Is > > this correct? If so, how do I export using the 8-bit character set? > > > > We are running Oracle 7.3.3 on Solaris. I export databases using the > > exp utility from the Unix prompt or a script. > > > > Thanks > > -- > > Jan > > pantah@commonsense.a2000.nl > > (replace "commonsense" with "speed" to reply) > > ------------------------------------------------------------------------ > > Sybrand Bakker > > Sybrand Bakker > > Netscape Conference Address > Netscape Conference DLS Server > Additional Information: > Last Name Bakker > First Name Sybrand > Version 2.1