Small and medium business | Business Central, N...

Shift_JIS encoding in Business Central SaaS version

(0) Share

Report

Posted on by Dharmender

Hi All,

In BC SaaS version, it is only possible to export a file with TextEncoding::Windows/UTF-8/ASCII.

But one our customer want to export file with specific encoding type (shift_jis) and which is possible in NAV and BC Onprem versions with help of .NET variables. Is there any workaround to achieve below source code in BC SaaS version?

//[DotNet Variable: FilestreamWriter , FileEncoding ]

TextFile.WRITEMODE(TRUE);

TextFile.TEXTMODE(TRUE);

TextFile.CREATE(FileName);

TextFile.CREATEOUTSTREAM(FileOutStream);

FilestreamWriter := FilestreamWriter.StreamWriter(FileOutStream,FileEncoding.GetEncoding('shift_jis'));

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

In BC Online there is an encoding codeunit avalible in the system app.T

The codeunit 1406 called Encoding. Takes a text and a Destination codepage as parameter. Maybe you can use that function?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,598 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I think what Inge mentioned should be codeunit 1486 "Encoding". You can have a try.

And, some info in MS Docs:

File Handling and Text Encoding
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-file-handling-and-text-encoding

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Dharmender 88 on at

Like (0)

Report
Copy link

Link copied!

Thanks ZHU for your suggestion.

My basic requirement is to export data from BC SaaS with Shift-JIS encoding text file.

Tried with the following code but Japanese characters showing ????? format.

//65001:codepage for utf-8, 932: codepage for shift_jis.

Encoding.Convert(65001, 932, HeaderLineJPText);

-----------------------------------------------------------------------------

12100077777777?)?????????? 02180005?????????????

-----------------------------------------------------------------------------

Was this reply helpful? Yes No
Dharmender 88 on at

Like (0)

Report
Copy link

Link copied!

Thank Bruvik for your suggestion.

Tried encoding codeunit but still it not working. exported file showing ???

//65001:codepage for utf-8, 932: codepage for shift_jis.

Encoding.Convert(65001, 932, HeaderLineJPText);

Was this reply helpful? Yes No
Suggested answer

Dharmender 88 on at

Like (1)

Report
Copy link

Link copied!

Thanks all for your time and suggestions. Achieved final result with following code.

//DotNetEncoding: Codeunit DotNet_Encoding;

//DotNetStreamWriter: Codeunit DotNet_StreamWriter;

//932 : codepage for shift-jis encode

//Fine Code

TempBlob.CreateOutStream(OutStr);

DotNetEncoding.Encoding(932);

DotNetStreamWriter.StreamWriter(OutStr, DotNetEncoding);

DotNetStreamWriter.WriteLine(HeaderLineJPText);

DotNetStreamWriter.Flush();

//Bad code

TempBlob.CreateOutStream(OutStr);

DotNetEncoding.Encoding(932);

DotNetStreamWriter.StreamWriter(OutStr, DotNetEncoding);

OutStr.Write(HeaderLineJPText);

OutStr.WriteText();

Was this reply helpful? Yes No