JDBC to XML file interface

[GabrielSagaya]

Hi

in JDBC to XML file interface

i want to generate the XML file with encoding of ISO-8859-1 instead of UTF-8 which is normal encoding standard since i have to include foreign character

[Former Member]

Hi Gabriel,

Additing to your information after sandeep setting idea

in data type as

Text

Under File Encoding, specify a code page.

The default setting is to use the system code page that is specific to the configuration of the installed operating system. The file content is converted to the UTF-8 code page before it is sent.

Permitted values for the code page are the existing Charsets of the Java runtime. According to the SUN specification for the Java runtime, at least the following standard character sets must be supported:

1) US-ASCII

Seven-bit ASCII, also known as ISO646-US, or Basic Latin block of the Unicode character set

2) ISO-8859-1

ISO character set for Western European languages (Latin Alphabet No. 1), also known as ISO-LATIN-1

3)UTF-8

8-bit Unicode character format

4)UTF-16BE

16-bit Unicode character format, big-endian byte order

5) UTF-16LE

16-bit Unicode character format, little-endian byte order

6)UTF-16

16-bit Unicode character format, byte order

When you will go with this link.it will clear more to clear

http://help.sap.com/saphelp_nw04/helpdata/en/e1/a63d40c6d98437e10000000a155106/frameset.htm

follow this link go to Adapter/file/FTP adapter/configuring

**PS:reward points if useful***

Regards,

Sumit Gupta

[Former Member]

Hi Gabriel Sagaya ...

yes you can do it By setting receiver channel

when you configure your receiver channel then in that under the tab " processing parameter " select file type as "Text"

after that there will be a pop down in which you can give encoding type which you requie in your output

for example in your case you fill up ISO-8859-1 as encoding type and save the configuration

by this way you can get your desired output including foreign characters

hope this may solve your problem

Thanks

Sandeep Sharma

PS: If helpful please reward points

[Former Member]

please have a look at SAP Note 831162

i guess question # 2 deals with your requirement

Thanx

Aamir