I’ve got a problem with special characters:
My database (set up in UTF-8) contains special characters (japanese, chinese, or greek…).
When I use a select adapter, wM doesn’t retrieve correct characters.
I’ve the same problems with update adapters.
I’ve read this:
“In the NLS_LANG field of the adapter’s configuration (Oracle Intelligent
adapter), fill in the value “.UTF8” (without the double-quotes and don’t forget the dot in front of UTF8).”
But I don’t know where the field NLS_LANG can be filled-in. (and I don’t know if this field exist for our release: we use webMethods 6.0.1.
Has your problem resolved? Even we face the similar issue when we use webMethods select template to retrieve the values from the field which have special characters. It would be great if you could share as to what you have done if the issue is resolved.
Hi channel,
You wrote:
“In the NLS_LANG field of the adapter’s configuration (Oracle Intelligent
adapter), fill in the value “.UTF8” (without the double-quotes and don’t forget the dot in front of UTF8).”
This solution applies to Enterprise Adapter: DB Edition 4.1.1.
Since you are using IS 6.0.1, you have JDBC Adapter 6.0.1 and that is why you don’t find this option here.
The IS 6.x was tested on AL32UTF8. Therefore, webM recommends to use AL32UTF8. You can choose to use UTF8 or UTF-8 as well.
Refer to page 39 on PlatformInstallGuide.pdf
Also, click on this link for webMethods response on this issue: