Friday, February 16, 2007

Characterset conversion

Using the SOA Suite with the DBAdapter, even for Oracle EBunisses Suite (EBS), you must be ware of your character set you are using. The application server is running in Java and using XML, so it uses by default UTF-8.

If your database is configured not for UTF-8, it will convert the incoming payload to the character set of the database. Nine-out-of-ten it will run without any errors. But using special characters you could get errors when you insert data in the database.

This issue can be solved by using a PL/SQL function to convert the data from on characterset to another one.
PL/SQL using implicit the database character set. Using 'CONVERT()' function.
  • CONVERT(string, to-characterset, from-characterset);
Example:

SELECT CONVERT('Ä Ê Í Ó Ø A B C D E ', 'UTF8', 'WE8ISO8859P1') FROM DUAL;

Click here for more information in this function:

Post a Comment