Saving Hex A0 ( non-breake space ) in DB
Author: firstname.lastname@example.org (dammie)
I have defined column varchar18 in db (in model String VC18). I am trying import txt file via form in Uniface and save data into this db column.
There is text comming "2000-2001/ABCD XL " in Hex (323030302D323030312F4D54504C20584CA0). Lenght of this text is 18, but after store I ve got $error 0120 Error on field field ; subfield too large.
I think there is problem with last symbol ( Hex A0 = Non-break space? ). If I replace it with simply " " ( Hex 20 ) import is working without errors. (I can save this text also if I delete TWO (!) other chars e.g. if I save "00-2001/ABCD XL " )
Any comments? Why I cannot save Non-break space as simple char. I need extra space (2 another chars) in DB or it is uniface that is interperting symbol " " ( Hex A0 ) as 3 symbols?