petey1
9th October 2008, 21:54
I can enter special characters into text fine. examples are the copy right ©, degree symbol º
I can see the special characters just fine in LN text too.
when i retrieve them for a download, i first create the workfile in my HP unix tmp directory. For some reason, the characters are being changed and illegible.
This did not happen to me in BaanIV (the two systems are on the same box and it's the same program for IV and LN). Anyone have a clue for me?
petey1
13th October 2008, 18:07
Below is an example of the output. I shouldn't be getting the >1/4 before the special characters of degree and copyright.
this would be degrees: ›¼º this would be copy right: ›¼©
BaaNovva
29th May 2013, 15:47
I am facing the same issue.. when writing text to windows csv file from LN Linux the 16.5°c is written as 16.5›¼Í ›¼¼›¼Í ›¼Í ›¼Í ›¼¼›¼Í ›¼¼›¼Í ›¼¼›¼Í ›¼Í ›¼Í ›¼¼›¼Í ›¼°c How to convert this before writing to file ? And from what has to be converted to what ? for ex. you have unicode to TSS and vice versa.. Any one can throw some light on this ?
Thanks
bdittmar
29th May 2013, 17:10
I am facing the same issue.. when writing text to windows csv file from LN Linux the 16.5°c is written as 16.5›¼Í ›¼¼›¼Í ›¼Í ›¼Í ›¼¼›¼Í ›¼¼›¼Í ›¼¼›¼Í ›¼Í ›¼Í ›¼¼›¼Í ›¼°c How to convert this before writing to file ? And from what has to be converted to what ? for ex. you have unicode to TSS and vice versa.. Any one can throw some light on this ?
Thanks
Hello,
i use :
function built.dataline()
{
|Reset
dataline = ""
dataline = trim$(tccom130.nama)&" "&trim$(tccom130.namb) |Companyname
&";"
&trim$(tccom110.ofbp) |Customernumber
&";"
&trim$(mailadr) |Mail
&";"
&"+"&trim$(tcmcs010.tfcd)&" "&trim$(tccom130.telp) |Phone
&";"
&"+"&trim$(tcmcs010.tfcd)&" "&trim$(tccom130.tefx) |Fax
&";"
&"Primär" |Adresstype FIXED
&";"
&trim$(tccom130.namc)&" "&trim$(tccom130.hono) |Street
&";"
&trim$(tccom130.pstc) |Postcode
&";"
&trim$(tccom130.dsca) |City
&";"
&trim$(tcmcs010.dsca) |Country
&";"
&trim$(tcmcs045.dsca) |Region
&";"
&trim$(kontaktmethode)
|Convert data
utf8.export(dataline, dataline, UTF8_STD_MODE)
|Put record to file
seq.puts(dataline, fp)
}
The convert shows characters like @, ä, ö, ü a.s.o
One original exported line:
BFI Industrie-Elektronik GmbH & Co. KG;100062117;info@bfi-elektronik.de;+49 202 2604460;+49 202 26044624;Primär;Winchenbachstr. 3 b;42281;Wuppertal;Deutschland;West ( Herr Kaiser);Telefon
Added :
Try with DEGREE and Registered Trademark sign:
BFI Industrie-Elektronik GmbH & Co. KG;100062117;info@bfi-elektronik.de 16,5° ®;+49 202 2604460;+49 202 26044624;Primär;Winchenbachstr. 3 b;42281;Wuppertal;Deutschland;West ( Herr Kaiser);Telefon
Regards
Han Brinkman
29th May 2013, 17:14
I am not completely familiar with the used technics behind this but Infor uses their own TSS encoding. You probably need the function mb.export$ to convert the string to a external, native character set.
Look at the programmers manual which resides on the Enterprise Server cd.