Current Position:Home > ESB or BPEL file adapter and special characters

ESB or BPEL file adapter and special characters

Update:10-11Source: network consolidation
Advertisement
Hi,
We have a scenario where we import rows from .csv file through an ESB project into a database. We use the file adapter for this. There appears to be a problem with special characters (like é). Both in the ESB control (with variable tracking) and in the database, they appear as upside down questionmarks (¿). I've tried doing the same with a BPEL project (file adapter as client PL) and in the BPEL console, I also see strange characters instead of the expected special characters (diamond shaped characters, like ♦ to be precise).
I can't find anything about character sets of character set conversions in the documentation. What am I missing?
Regards,
Arjan

The Best Answer

Advertisement
see
http://download-west.oracle.com/docs/cd/B31017_01/inte
grate.1013/b28994/nfb.htm#CIAEFBHHI've looked into the properties mentioned. They are set when you go through the wizard. Everything is set to UTF-8, which should provide me with all special characters I need.
BPEL does the exact same thing, so I'm starting to believe that the problem really is with the file adapter.
Regards,
Arjan
  • ESB or BPEL file adapter and special characters Update:10-11

    Hi, We have a scenario where we import rows from .csv file through an ESB project into a database. We use the file adapter for this. There appears to be a problem with special characters (like é). Both in the ESB control (with variable tracking) and

  • Firefox doesn't reconvert special characters in the file names when download a file with any special characters in the file name Update:10-11

    <blockquote>Locking duplicate thread.<br> Please continue here: [/questions/815207]</blockquote><br> if i try to download a file with any special characters in file name (e.g. File_Name.pdf), it doesn't reconvert them from the &quo

  • How to find EOF in BPEL File adapter Update:10-11

    Hi All, I am using file adapter in BPEL(SOA 11G) to read a csv file. The CSV file is very large so we have are processing the files in batched of 20000 records.I am inserting the records form CSV file to a staging table and after that I am invoking a

  • Mac file name restrictions/special characters Update:10-11

    What are the Mac OS file name restrictions? What are the special characters to avoid? Is this a legitimate file name? Are the colons allowed? /Users/Joe/Desktop/MyDocument 3:2:06.xls   Windows XP Pro  Thanks, Sagesse. I'm new to the Mac OS. Is it tie

  • Need help in setting file name with special characters in attachment Update:10-11

    Hi We have a requirement where we need to set the file name that contains special characters (like Russian) and send mauil using Java mail. If we set the file name as such, the attachment in the email contains garbled filename Can you pl let me know

  • How to make BPEL File Adapter read only new files? Update:10-11

    Hello we have BPEL processes that define to run from bpel component - file adatper- when a file come into location that it is path on the linux server . the bpel start run when "File Adapter" bpel component recognize that new file come to the lo

  • BPEL File Adapter Logical Path Issue Update:10-11

    I am trying to write the BPEL Error Messages using a file adapter. But I could not parameterize the logical directory. I need a solution of changing it in the BPEL console after deploying it I am Invoking a FileAdapter Web service using logical direc

  • Soa Suite 10g. ESB Project. File Adapter - load in 2 folders Update:10-11

    Hi, friends! Help me please to solve next task. A have some ESB Project, which has 2 adapters: DbAdapter (In) and FileAdapter(out). If new rows appears in some table in DB (in CLOB field), I must save it in folder on disk. It's simple to save it in O

  • Files with accented / special characters dissapear / not visable Update:10-11

    I did everything which was suggested in threath http://discussions.apple.com/thread.jspa?threadID=875688&threadrate=2&messageid= 4170111#4170111 but have another problem which maybe new: All the files appeared when I first used the USB HD on my Ai

  • Output from Adapter ? (Special characters) Update:11-30

    Hi, I am downloading a page with som special characters (from iso-8859-2). The special characters becomes ? in the XML from the Adapter (WebIntergrationAdapter). <AdapterResult> <Text> Milo?evi?, Slobodan, f. 1941</Text> Does someone kno