When Exporting Data from Forms to Excel then Question Marks "?" Occur In The .XLS File With Arabic Locale and NLS_LANG (Doc ID 469575.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Forms - Version: 10.1.2.0.2 to 11.1.1.1.0 - Release: Oracle10g to 11g
Microsoft Windows (32-bit)
Checked for relevance : 4-July-2011

Symptoms

When trying to export data from Forms to an Excel sheet on Windows with an Arabic character set - using Webutil client_ole2 - then the Arabic characters - that can be seen in the Forms correctly - appear as question marks '?' in the relevant sheet(s). NLS_LANG is set to ARABIC_UNITED ARAB EMIRATES.UTF8 (also in the default.env file). It is an English Windows with Arabic locale setting.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms