Re: Traditional Chinese in ACS Run SQL Scripts? -- MIDRANGE-L

I'm not really sure. I assume it just uses APIs provided by Java to query
the fonts installed on your system (plus the fonts shipped with it).

----- 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 12:55 PM

Hi Kevin

Where does the list of fonts in the emulator come from? Does ACS have
its own set of fonts somewhere?

I have the emulator session set to use Unicode on the setup page where
you specify the host code page.

IBM3270 seems to work but you only get plain - no bold
Monospaced gives the option of bold
Consolas, Courier New, Lucida Console, PComm Session (where are they
coming from) handles Cyrillic and German, not Chinese

MS Gothic, NSimSun, SimSun show Cyrillic, Chinese, German - but Cyrillic
is double-spaced

Enable Unicode Data Stream, Enable DBCS in Unicode Fields, and Protect
Unicode Field Length are all "Yes".
Host code page is 37.

Fixed font is Yes

TMI? It must be, right?

Cheers
Vern

On 2/11/2019 12:08 PM, Kevin Adler wrote:
> 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][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][2]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][3]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][4]https://amazon.midrange.com
>
>
>
>
> References
>
> Visible links
> 1. [5]https://www.google.com/get/noto/
> 2.
[6]https://www.quora.com/What-is-the-largest-most-robust-Unicode-font
> 3. [7]https://lists.midrange.com/mailman/listinfo/midrange-l
> 4. [8]https://archive.midrange.com/midrange-l
> 5. [9]https://amazon.midrange.com/

--
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: [10]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 [11]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: [12]https://amazon.midrange.com

References

Visible links
1. https://www.google.com/get/noto/
2. https://lists.midrange.com/mailman/listinfo/midrange-l
3. https://archive.midrange.com/midrange-l
4. https://amazon.midrange.com/
5. https://www.google.com/get/noto/
6. https://www.quora.com/What-is-the-largest-most-robust-Unicode-font
7. https://lists.midrange.com/mailman/listinfo/midrange-l
8. https://archive.midrange.com/midrange-l
9. https://amazon.midrange.com/
10. https://lists.midrange.com/mailman/listinfo/midrange-l
11. https://archive.midrange.com/midrange-l
12. https://amazon.midrange.com/