I have pasted this text from Word Document to a NAV Blob Field: ~!@#$%^&
;*() ‘something’ “something more” end
And printed this blob fields through a NAV report as pdf, it looks like this:
It could not decode the Left Single Quotation, Right Single Quotation, Left Double Quotation, Right Double Quotation when printing.
This is my code.CALCFIELDS("Additional Comments");
StreamReader := StreamReader.StreamReader(iStream,Encoding,TRUE);
is a DotNet variable of subtype System.IO.StreamReader.'mscorlib, Version=18.104.22.168, Culture=neutral, PublicKeyToken=b77a5c561934e089'
is a DotNet variable of subtype System.Text.Encoding.'mscorlib, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b77a5c561934e089'
Your suggestion will be very much appreciated to resolve the issue.
Not sure why you are using dotnets to read from a blob, NAV can handle this.
Can you try something like:
Also, I recall if you are about to read BLOBs from SQL query etc, you need to set BLOB properties compressed=false. Even if you do that, some characters are not well recognised etc.
Then yes, you can do something like this, I used for reading an image
Thanks txeriff and PurpleHaze for your help. You are awesome.
IF NOT ISNULL(binRdr) THEN BEGIN //read value from BLOB field
IF length > 0 THEN BEGIN
WHILE i<length DO BEGIN