англикотApplication Primary Language - English (United Kingdom) (en-gb)
Application Language Derived From - Application Primary Language
Automatic CSV Encoding - YES
автор
Automatic CSV Encoding
Automatic CSV Encoding controls the encoding of all comma-delimited (CSV) report output in an application. The default value for Automatic CSV Encoding is No. If Automatic CSV Encoding is set to Yes, CSV report output is converted to a character set compatible with localized desktop applications. The character set for the CSV encoding is determined by the Application Language Derived From setting.
The encoding of pages in Application Builder is determined by the character set of the database access descriptor (DAD) used to access Oracle Application Express. For example, if the character set of the database access descriptor is AL32UTF8, all pages in all applications in the Oracle Application Express user interface are encoded in UTF-8.
By default, the CSV output from report regions is encoded in the same character set as the database access descriptor. However, some desktop spreadsheet applications require that the data is encoded in the client desktop operating system character set. In the case of multibyte data, the CSV output from report regions will often appear corrupted when opened by a desktop spreadsheet application. This is because the CSV output is encoded differently than what is required by the desktop application. Enabling Automatic CSV Encoding resolves this issue.
For example, if the user's language preference for an application is de, the CSV data is encoded in Western European Windows 1252, regardless of the Database Access Descriptor character set setting. If the user's language preference is zh-cn, the CSV data will be encoded in Chinese GBK.
1.
2.
3.
4.
5.
6.
select nls_language, nls_territory, nls_windows_charset
from apex_040000.wwv_flow_languages
where lang_id = 'en-gb';
NLS_LANGUAGE NLS_TERRITORY NLS_WINDOW_CHARSET
-------------------- -------------------- --------------------
ENGLISH UNITED KINGDOM WE8MSWIN1252
Мне кажется, кириллица теряется при преобразовании UTF8 к WE Windows 1252.
Попробуйте поставить Automatic CSV Encoding=NO и дождаться ответа об настройках DAD.
