Re: Traditional Chinese in ACS Run SQL Scripts?

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