The installed fonts on your IBM i system have no bearing on what fonts ACS
   can use (unless you're running ACS on IBM i).
    
   Google Noto font contains glyphs for pretty much every Unicode code point:
   [1]
https://www.google.com/get/noto/
    
   The problem is that fonts have a [2]limit to the number of characters they
   can encode in the same font file. You'll have to find a font file which
   contains the languages you want to use. I'm not sure if Noto contains a
   font with both Cyrillic and CJK glyphs - or any font for that matter,
   since there are so many CJK glyphs.
    
     ----- Original message -----
     From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
     Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
     To: Midrange Systems Technical Discussion
     <midrange-l@xxxxxxxxxxxxxxxxxx>
     Cc:
     Subject: Re: Traditional Chinese in ACS Run SQL Scripts?
     Date: Mon, Feb 11, 2019 11:36 AM
      
     Joep
     I am at the same version of ACS. I did a couple things - I installed a
     new language, Traditional Chinese, and I think that put in a couple
     fonts.
     I was able to use Microsoft YaHei - I don't know if it had already been
     installed.
     A web page I googled for, about fonts for Chinese, said that Arial
     Unicode MS would work - and it does - now the YaHei also displayed
     Cyrillic at the same time. JhengHei did not have any Cyrillic, although
     both of these are Unicode. MingLiU-ExtB also is Unicode but no Cyrillic.
     So very interesting - we are installing SS1 opt 43, additional fonts,
     which is supposed to include Unicode fonts.
     Thanks for the help
     Vern
     On 2/11/2019 9:45 AM, Joep Beckeringh wrote:
     > Hi Vern,
     >
     > Yes I am in the Netherlands :-)
     >
     > I haven't done anything special to my (company supplied) laptop. I
     > just checked 'installed fonts' and I do see a few that look to me like
     > they could be Chinese (Microsoft JhengHei, Microsoft YaHei, MingLIU)
     > but I did not (consciously) install any of those.
     >
     > For completeness' sake: my ACS is up to date (November 2018; build
     > 8452), but I have done this on older versions as well.
     >
     > Joep Beckeringh
     >
     >
     > Op 11-2-2019 om 13:15 schreef Vernon Hamberg:
     >> Hi Joep
     >>
     >> This is encouraging. You are in Nederland, right? I wonder what might
     >> be different about your Windows setup? Do you have any special
     >> Chinese fonts installed?
     >>
     >> Again, it seems to be a presentation problem - the statement to
     >> insert the Chinese characters did work correctly.
     >>
     >> Thanks
     >> Vern
     >>
     >> On 2/11/2019 1:36 AM, Joep Beckeringh wrote:
     >>> Hi Vern,
     >>>
     >>> Read this in the weekend and I remembered I did this before without
     >>> any problem. So I tested it and indeed, no problem at all.
     >>>
     >>> With 'Good afternoon' translated to Chinese by Google Translate I
     did:
     >>>
     >>> update debf set admtx = 'Pantheon HRM 181 € 下午好' where envid =
     >>> 'EMSN8A181';
     >>>
     >>> What I pasted in the upper panel appeared correctly; when I did
     >>> 'select * from debf' the updated text appeared correctly in the
     >>> lower panel.
     >>>
     >>> Joep Beckeringh
     >>>
     >>>
     >>> Op 6-2-2019 om 20:09 schreef Vernon Hamberg:
     >>>> Once again y'all
     >>>>
     >>>> We are working with Chiness and in the ACS Run Sql Scripts panel I
     >>>> pasted 6 Unicode glyphs as the value for an update into a column
     >>>> defined with CCSID(1200).
     >>>>
     >>>> When pasting into the upper panel, it showed up in ACS as those
     >>>> open checkbox-like items. The actual data did get inserted into the
     >>>> column, however.
     >>>>
     >>>> So I've tried some changes in the JDBC connection for language, it
     >>>> made no difference. Tried different font, too, in the View menu,
     IIRC.
     >>>>
     >>>> Pasting that Chinese string into Notepad++ worked fine.
     >>>>
     >>>> ***** So what do we need to do to see our value in ACS Run Sql
     >>>> Scripts - either in the entry panel or in the results? *****
     >>>>
     >>>> BTW, Cyrillic worked nicely. - So maybe it's something to do with
     >>>> DBCS characters within Unicode - that's a setting in the ACS
     >>>> emulator configuration.
     >>>>
     >>>> Regards
     >>>> Vern
     >>
     --
     This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
     list
     To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
     To subscribe, unsubscribe, or change list options,
     visit: [3]
https://lists.midrange.com/mailman/listinfo/midrange-l
     or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
     Before posting, please take a moment to review the archives
     at [4]
https://archive.midrange.com/midrange-l.
     Please contact support@xxxxxxxxxxxx for any subscription related
     questions.
     Help support midrange.com by shopping at amazon.com with our affiliate
     link: [5]
https://amazon.midrange.com
      
    
References
   Visible links
   1. 
https://www.google.com/get/noto/
   2. 
https://www.quora.com/What-is-the-largest-most-robust-Unicode-font
   3. 
https://lists.midrange.com/mailman/listinfo/midrange-l
   4. 
https://archive.midrange.com/midrange-l
   5. 
https://amazon.midrange.com/
As an Amazon Associate we earn from qualifying purchases.