See special characters in a BLOB field.

chachitano@hotmail.com

Hi,

Is there any way to see special characters, like ú, í, é... on a BLOB field in NAV?
I'm using NAV 2018. Trying to display these kind of characters in "User Task" table on the Description BLOB field.

chachitano@hotmail.com

Thank you for that, it seems like it's sorted... The user task BLOB uses a variable named "MultiLineTextControl" which was pointing to UTF8 on Codeunit 10:

[External] WriteBlob(VAR BlobFieldRef : FieldRef;NewContent : Text) : Boolean
BlobFieldRef.CALCFIELD;
TempBlob.Blob.CREATEOUTSTREAM(OutStream,TEXTENCODING::UTF8);
OutStream.WRITE(NewContent);
BlobFieldRef.VALUE := TempBlob.Blob;

EXIT(TRUE);


I cloned the function in order to use TEXTENCODING::Windows in a customized one.

NavNab

Have you tried something like this?

TempBlob.WriteAsText('éàîï', TEXTENCODING::UTF8);

MESSAGE('%1', TempBlob.ReadAsText('', TEXTENCODING::UTF8));

chachitano@hotmail.com

Thank you for that, it seems like it's sorted... The user task BLOB uses a variable named "MultiLineTextControl" which was pointing to UTF8 on Codeunit 10:

[External] WriteBlob(VAR BlobFieldRef : FieldRef;NewContent : Text) : Boolean
BlobFieldRef.CALCFIELD;
TempBlob.Blob.CREATEOUTSTREAM(OutStream,TEXTENCODING::UTF8);
OutStream.WRITE(NewContent);
BlobFieldRef.VALUE := TempBlob.Blob;

EXIT(TRUE);


I cloned the function in order to use TEXTENCODING::Windows in a customized one.