Application data is unreadable

Carol Francum, Ashford Global Systems

Published: 10 Oct 2003

I have an application developed on Oracle. This application uses Arabic language in my forms and data tables and worked good except for one error: It only displays the data in error code and users can't read the data correctly...
Check whether your database, applications and operating system are using compatible charactersets. Predicting the results when when storing an 8 bit characterset in a 7-bit database is virtually impossible. The characterset defined in NLS_LANG parameter does not change the client's characterset, it lets Oracle know what you are using on the client side so Oracle can do the conversion. There are both 7-bit and 8-bit Arabic encoding schemes.

Check out the following notes in Oracle Metalink: Note: 70117.1 - Create A Translation Using Translation Builder (Only applicable for AR8MSWIN1256 Character Set)
Note: 158577.1 – NLS_Lang explained.
Note: 226692.1 – Finding out your NLS setup
Note: 241048.1 – The priority of NLS parameters explained
Note: 225912.1 – Changing the Database Character Set - an Overview
Note: 66320.1 – Changing the database characterset or the Database national character set
Note: 13854.1 - Dump SQL command for NLS debugging

Dig Deeper on Oracle E-Business Suite

Oracle data export guide Exporting data is a common task for an Oracle DBA, but not necessarily a straightforward one. In this compliation of questions and answers, SearchOracle.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain how it's done, with step-by-step instructions and example scripts, and talk about what can and cannot be exported.

ORA-02248 error while trying to import I want to migrate from Oracle 8.05 to Oracle 9i. I exported the database in 8.05 and then tried to import it in Oracle 9i. I am getting the following error: "ORA-02248." Plesae help me solve my problem.

Installed Oracle with wrong default language I have installed Oracle 9i Server on client but by default it got installed in Dutch. I want to change it to English. I have tried doing alter system set NLS_LANG option but it did not change the setting. Please advise.

Unix script to create database export via crontab I need to find a Unix script that will run via crontab and create a full database export. The script I have attached runs OK via ./export.sh in a Unix shell (about two hours and is 22 GB in size), but when I run it via a crontab job, it takes 18 odd hours and is about three times the actual size. I would appreciate your help on this.

Character set name is not recognized Would you please guide me on why I am getting these errors when I try to run the below script? ORA-06550: line 1, column 29: PLS-00553: character set name is not recognized, ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated.

Copying a database with Arabic fonts I need to make a copy of a DB in 9i on Windows 2003 Server but I have Arabic fonts. I tried to do this with exp and imp, but all fonts in Arabic were lost. I tried to adjust the character set for the new database with no success.

Related Q&A from Carol Francum

Determining which table was just modified

Implementing Financials 11i on one box and adding another later

Avoid changing size of ACS segments

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Amazon Managed Apache Cassandra Service stokes competition

Vendors in the open source Cassandra NoSQL database market voice their concerns about AWS' entry into the field, as the cloud ...

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

SearchBusinessAnalytics

Government IT pros: Hiring data scientists isn't an exact science

There's no such thing as a data science unicorn, U.S. government experts caution. You'll need more than programmers and technical...

Tableau 2020.1 unveiled for beta testing

Featuring improvements to Explain Data, an AI product that aims to explain the reasons behind data points, the update is made up ...

Data scientist vs. data analyst: What's the difference?

Data scientists and data analysts have a lot of crossover in their roles, but they're certainly not the same. Here's a look at ...

SearchSAP

Understand and fight potential SAP exploits

Without taking the right steps to secure SAP systems, you're creating vulnerabilities for potential exploits. Here's a look at ...

Partners need to target SAP SMB market for cloud transition

In this Q&A, SAP executive Claus Gruenewald discusses how SAP partners are instrumental in servicing the SMB market and how they ...

S/4HANA Cloud integrates Qualtrics for continuous improvement

The latest version of SAP S/4HANA Cloud embeds Qualtrics XM capabilities that provide a way for users to give direct feedback ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

Don't ever put a non-Java LTS release into production

Development teams should avoid non-long-term support releases at all costs. Pay attention to the Java release cycle to make sure ...

Public API strategy considerations for enterprise adoption

As organizations look for more cost-effective ways to manage data, an evolving landscape with APIs has made the technology more ...

Ideas on how to hold a successful code hackathon

Want to host a hackathon? Here are some ideas on what a company can do to host an event that solves problems and reenergizes the ...

SearchDataCenter

Refresh your data center cooling lexicon

As the data center industry moves to improve energy efficiency, refresh your knowledge on the available cooling technology and ...

Comparing Linux distributions: Red Hat vs. Ubuntu

Before selecting a Linux distribution, compare Red Hat Enterprise Linux and Ubuntu when it comes to features, ease of use, ...

Get eco-friendly with LEED data center certification

The U.S. Green Building Council helps companies make existing and new data centers eco-friendly. HVAC, lighting and monitoring ...

SearchContentManagement

DNA as a content storage device is closer than you think

Storing content in DNA may one day be possible, but today, it's neither practical nor cost-effective. Here's where this ...

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

SearchHRSoftware

US Army HR expects migration to Azure cloud will cut IT costs

The U.S. Army civilian HR operations is hoping for lower operational costs and improved services with a shift to the Microsoft ...

H-1B lottery change may drive increase in visa applicants

The U.S. is launching an H-1B electronic registration system in March. It should make the process of applying for a visa easier, ...

Fight the skills gap with a great upskilling and reskilling strategy

Just say 'no' to a skills gap and high turnover with upskilling and reskilling. Here's a look at the ins and outs of these ...

Related Resources

Dig Deeper on Oracle E-Business Suite

Related Q&A from Carol Francum

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.