Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Import/Export server character set????

Import/Export server character set????

From: Geeta Iyer <geeta.iyer_at_sprintparanet.com>
Date: Fri, 9 Jun 2000 10:57:20 -0600
Message-Id: <10523.108439@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BFD201.7BB2F830
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello all,

I have inherited a database with default character set and default nls character set of US7ASCII
Yet, when I do any export/import from/to the database.. it converts the character set

Export done in US7ASCII character set and US7ASCII NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion)

import done in US7ASCII character set and US7ASCII NCHAR character set import server uses WE8ISO8859P1 character set (possible charset conversion)

and this may be obvious, but I cannot see it.. anyone tell me why the above is happening!!

Geeta Iyer
Sprint Enterprise Network Services
Work: (303)220-4788
Pager: 800-724-3508
E-Mail: Geeta.Iyer_at_SprintParanet.com

------=_NextPart_000_0005_01BFD201.7BB2F830
Content-Type: application/ms-tnef;

        name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;

        filename="winmail.dat"

eJ8+IhQQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHBgAJAAoAOQAAAAUALgEB A5AGANAGAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAJwAAAEltcG9ydC9FeHBvcnQgc2VydmVyIGNoYXJhY3RlciBzZXQ/Pz8/AAACAXEAAQAAABYA AAABv9IzxiTtXXDmUYNGorQw2cVVf/8FAAACAR0MAQAAACIAAABTTVRQOkdFRVRBLklZRVJAU1BS SU5UUEFSQU5FVC5DT00AAAALAAEOAAAAAEAABg4AVka6M9K/AQIBCg4BAAAAGAAAAAAAAABOLJVg DvfxTrl36L7BYlNvwoAAAAsAHw4BAAAAAgEJEAEAAABIAgAARAIAANkDAABMWkZ1MD795AMACgBy Y3BnMTI1FjIA+Atgbg4QMDMzTwH3AqQD4wIAY2gKwHPwZXQwIAcTAoMAUANUVxDJB20CgH0KgXYI kHfSawuAZDQMYGMAUAsDRwu2CrEKgEhlbAkAIJkHQGwsFjQWNEkgEPCodmUgC4BoBnF0CYBRFuAg ZGEBkWERICAZA/B0aBkQARBhdWz/BUAQ4gDQGMAFwBEhFuAU8BkZ925sBCAajG9mIABVUzdBU0NJ SfUWNFkRMCwZoBiAA6AX8AJkFtFueSBleHAtCREvB3AfoiADUi90zxbQGdAYQBkmLi4YUBphfwIg GDAAIAQgIOIaixc6Rfsfkx8BbhhCHWcafxjgJVfgTkNIQVIizxZhESAyciIxIHURIAQgV0UAOElT Tzg4NTm0UDEl3SgfoAQQaQJg3yK0GyIiBACQAiApFzof9f8k3yXvJv8oDy4WKS8qPytP3yxfFzob YhnQBAAgAMAfYLJiGEBvYhSQCGBzHoCcYnUFQC+BAHBubzMy/RhBdCGhH0EuohjAFrA40N0ZkWgf YCDiAaBvGDIEIBkQ8HBwCfALgGchIY8XOj5bEgIL8DIgRwngmwGQHuB5BJAWNFNwBRD5AjAgRQIw BJBBERmBB8C0dHcFsGsGUhSQYweQpRY0V0JhOiA1sDMPUMIpP9AwLTQ3NHAWNJhQYWcEkEPBODBE YEEBwDQtMzUwRLVFtC1NC3BsQ8BAAy5AYn5AQQRFIBqwLrA7AAWgbRc/FhXaFFEASoALAAGACCAG AAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAEIAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEA HgASgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOS4wAB4AE4AIIAYAAAAAAMAAAAAA AABGAAAAADaFAAABAAAAAQAAAAAAAAAeABSACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEA AAAAAAAAHgAVgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsAFoAIIAYAAAAA AMAAAAAAAABGAAAAAIKFAAABAAAACwBDgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAEWA CCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMARoAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAA AAAAAwBHgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAALAGCACCAGAAAAAADAAAAAAAAARgAA AAAGhQAAAAAAAAMAYYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAAAgH4DwEAAAAQAAAATiyV YA738U65d+i+wWJTbwIB+g8BAAAAEAAAAE4slWAO9/FOuXfovsFiU28CAfsPAQAAAJcAAAAAAAAA OKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxE b2N1bWVudHMgYW5kIFNldHRpbmdzXGdpeWVyXExvY2FsIFNldHRpbmdzXEFwcGxpY2F0aW9uIERh dGFcTWljcm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QAAAMA/g8FAAAAAwANNP03AAACAX8AAQAA ADwAAAA8UEJFT0xKSEhLR0pDRkVBQ0ZOSklJRUFEQ0VBQS5nZWV0YS5peWVyQHNwcmludHBhcmFu ZXQuY29tPgADAAYQVwK90wMABxBKAgAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAEhFTExP QUxMLElIQVZFSU5IRVJJVEVEQURBVEFCQVNFV0lUSERFRkFVTFRDSEFSQUNURVJTRVRBTkRERUZB VUxUTkxTQ0hBUkFDVEVSU0VUT0ZVUzdBU0NJSVlFVCxXSEVOSUQAAAAAoYQ= Received on Fri Jun 09 2000 - 11:57:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US