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
Oracle Forms - Version: 10.1.2.0.2 to 126.96.36.199.0 - Release: Oracle10g to 11g Microsoft Windows (32-bit)
Checked for relevance : 4-July-2011
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.
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