CSV EXPORT NOT WORKING PROPERLY IF IE BROWSER LANGUAGE IS SET TO FR-CA (Doc ID 2247290.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.0.00.31 and later
Information in this document applies to any platform.

Symptoms

Export to CSV not displaying output properly when fr-CA is used as browser language but works fine when using en-US language and all other languages.

 

1. Create a simple Interactive Report using EMP table. Edit Globalization Attributes -->browser (use browser language preference).

2. Open IE browser --> Tools --> Internet Options --> Languages --> Add --> French (fr-CA).  Ensure that it is the first language in the list by moving it up.

3. Execute the application in the browser and export it to csv format. The issue is when you use fr_CA the open does not open properly, since it becomes ; (semi colon) delimited automatically.
The same in file in English is comma delimited.

This issue is specific to IE browser.



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