locked
Encoding for AMERICAN_AMERICA.AL32UTF8 equivalent in Windows RRS feed

  • Question

  • Hi All,

    We have the data source which we are getting. We are storing it in the database and getting the data from the database.

    Once we get the data from the database, we are creating .CSV file using the below code.

    Encoding isoWesternEuropean = Encoding.GetEncoding(28591);

    swData =

    new StreamWriter(new FileStream(dataFilePath, FileMode.Create, FileAccess.ReadWrite), isoWesternEuropean);

    Once we create this file on our Windows system, we have to send it to UNIX system, which is supporting AMERICAN_AMERICA.AL32UTF8. When we send the file to UNIX system and when they are reading they are getting Junk characters. The file shouldn't have BOM character in the beginning of the file and should support France characters and also has to support AMERICAN_AMERICA.AL32UTF8 UNIX. Please let me know how can I create the file.                                                                                              

    Tuesday, February 18, 2014 1:42 PM

Answers

  • Hello,

    If it is that you want to create an external using the CSV text, then I think this article below should be helpful:

    http://matthiashoys.wordpress.com/tag/al32utf8/

    It creates an external tables are created on CSV text files which come from a Windows 7 PC and are uploaded on a Linux database server. The solution is to define the external table with the “CHARACTERSET” option.

    There are some related cases:

    https://community.oracle.com/thread/2442881?tstart=0(Setting NLS_LANG)

    https://community.oracle.com/message/9565513

    Regard.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Fred Bao Friday, February 28, 2014 2:53 AM
    Wednesday, February 19, 2014 8:01 AM