Characterset Question
From: Scott Canaan <"Scott>
Date: Fri, 22 Mar 2024 18:22:44 +0000
Message-ID: <CH3PR16MB5897B56ED70F0B526C374326C5312_at_CH3PR16MB5897.namprd16.prod.outlook.com>
We are in the process of migrating all of our Oracle databases from Red Hat 7 to Red Hat 8. In creating the new databases in Red Hat 8, we've been going with the default characterset of AL32UTF8. Many of the old databases are US7ASCII. We are having trouble with applications trying to insert into text fields in the new database. In one case, bringing data from Peoplesoft that has a degree symbol fails because that comes over as 2 bytes instead of one. I thought that AL32UTF8 should handle those characters. What needs to be done to accommodate this?
Date: Fri, 22 Mar 2024 18:22:44 +0000
Message-ID: <CH3PR16MB5897B56ED70F0B526C374326C5312_at_CH3PR16MB5897.namprd16.prod.outlook.com>
We are in the process of migrating all of our Oracle databases from Red Hat 7 to Red Hat 8. In creating the new databases in Red Hat 8, we've been going with the default characterset of AL32UTF8. Many of the old databases are US7ASCII. We are having trouble with applications trying to insert into text fields in the new database. In one case, bringing data from Peoplesoft that has a degree symbol fails because that comes over as 2 bytes instead of one. I thought that AL32UTF8 should handle those characters. What needs to be done to accommodate this?
Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659
CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 22 2024 - 19:22:44 CET