Re: Traditional Chinese in ACS Run SQL Scripts?

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]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/