Re: Traditional Chinese in ACS Run SQL Scripts?

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