In this video, I talk and show why you shouldn’t use BigText variables anymore. BigText was the solution to the old 1000 character limitation of the Text type in NAV. Limitations that are long gone with Microsoft Dynamics 365 Business Central.
Tag Archives: BigText
How To: Use the Dictionary, RecordID, RecordRef, and BigText Data Types in AL Programming for Dynamics Business Central On Premises
There are many data types that are used in the AL programming language, used to modify code in Dynamics Business Central On Premises. This blog explains how to use the Dictionary, RecordID, RecordRef, and BigText data types.
Decode Base64 BigText
With this code you can decode a BigText variable with a Base64 coded string (in this case a PDF document)….
- abpBigPDFText -> BigText
- abpAutConvertBase64 -> DotNet ‘mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’.System.Convert
- abpAutBytes -> DotNet ‘mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’.System.Array
- abpAutMemoryStream -> DotNet ‘mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’.System.IO.MemoryStream
- abpOutStream -> OutStream
- abpRecTempBlob -> Record TempBlob
[snippet id=”1578″]
Clean workaround for wrong special characters in BigText variables
In a previous blogpost about webservices i wrote about saving the result of a xmlport to a bigtext variable and the problems witch charsets and special characters like ä,ö,ü etc.
Originaly i did a conversion from of the whole output from ansi2ascii which worked but was not very performant…
Using BigText in a Report
As you properly know BigText can be used to handle large texts.
BigText is stored in records as Blob fields, so what to do if you like to use the BigText in a Report?