2008 Nov 26 4:25 PM
Hello experts,
i have pound sign in my file.have to update the database table.
to open file iam using:
OPEN DATASET p_ifile FOR INPUT IN TEXT MODE ENCODING UTF-8 IGNORING CONVERSION ERRORS .
Its uploading into internal table but instead of £ sign its updating # into the table.
Having said that when I use
OPEN DATASET p_ifile FOR INPUT IN TEXT MODE .
its throwing me a bug .
if i use
OPEN DATASET p_ifile FOR INPUT IN TEXT MODE ENCODING default.
program dumps when reading the data from file.
plz advise.
2008 Nov 26 4:35 PM
Will the '£' actually be updated in the table or can you try to get rid of it?
Rob
2008 Nov 26 4:28 PM
Hi ,
It is considering the pond sym as the tab space in the internal table.
Regards,
bharani
2008 Nov 26 4:34 PM
OPEN DATASET p_ifile FOR INPUT IN TEXT MODE .
its throwing me a bug .why?
when its ok in other programs.
2008 Nov 26 4:35 PM
Will the '£' actually be updated in the table or can you try to get rid of it?
Rob
2008 Nov 26 4:38 PM
hi rob,
thanks for your reply..well it shud get updated along with the line.
like i have a line
tv cost £12. the whole line should get updated.
2008 Nov 26 4:50 PM
Please try with addition
ENCODING NON-UNICODE in OPEN DATASET
this option uses default code page from table TCP0C.
I think UTF-8 is as same as codepade 1100. and Euro sign not supported with UTF-8
a®
2008 Nov 26 4:47 PM
Check Thread:
[Note|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333133393338333433383331%7D.do]