Submitted by Hristo on Fri, 07/08/2011 - 16:19
Forums
IceBreak

Hi,

Recently I installed the Icebreak CE on our iseries - v5.3.0

I am trying to display the contents of existing tables containing character data in cyrillic (CCSID - 1025). The SQL statemens in the .aspx file are OK and I get the result on my browser - numeric data are fine but the character data are not correct (illegible), though with cycrillic letters. I've checked the BLUEBOXUSR userprofile and it seems to be OK(CCSID = 1025, lang = BG etc.), the same is valid for the created ICEBREAK server and for the server jobs. The HTML part displays cyrillic letters correctly.

I'll appreciate your advice.

Regards,

Hristo

Full name
Henning Ørnsø

Henning Ørnsø

Fri, 07/08/2011 - 21:44

Permalink

Hi Hristo,

Could you please post a bit of your program? It is difficult to know what is wrong without seeing some IceBreak code.   smiley

Regards,

Henning

Robert Mack

Sat, 07/09/2011 - 10:33

Permalink

Hi Hristo,

Does your file by any chance contain CCSIDs on field level?
 
"If the CCSID keyword is not specified at the file level and not all character fields have the CCSID keyword specified, then the fields are assigned the job’s default CCSID when the file is created."

(DDS Reference "Physical and Logical Files, CCSID")

Regards,

Robert

Hi Henning,

Please find the attached .aspx file which I'm using for inrtial testing of Icebreak CE. The input file (webtest1) is created with sql, setting the CCSID for the character fields to 1025. All character data  are properly displayed on the gren screen, in MS excel (via ODBC) etc.

Regards,

Hristo

Hi Hristo,

I have looked at your program and found one thing that could be wrong. In your program you use the following command:

SetCharset('1251');

The right notation would be:

SetCharset(‘windows-1251’);

But instead of SetCharset you should try SetContentType. Se the following:

SetContentType(‘text/html; charset=windows-1251’);

 
If this doesn’t fix your problem then please check the CCSID of your source file. Se the following example:

Screenshot of Display Attributes
 

Best regards,

Henning Ørnsø

Hi Henning,

Thank you for the help, but unfortunately the problem still exists.
I've tried all the tricks proposed by you - no positive result.

I've checked once again the configuration of everithing that comes to my mind and it seems to be OK.

The only step, according to me, which I haven't done is to reinstall IceBreak CE with a different user profile. I checked that the user profile I used to install the product is defined with a CCSID = 65535, and language id's  - Bulgarian due to usage of some legacy programs.

After that attempt I'll try everithing again and inform you about the result.
 

Best Regards,

Hristo

Gents;

I will suggest to use the UTF-8 charset for any applications. In this manner Cyrillic and Danish characters are treated the same way.

Follow the steps:

  1. Save the IceBreak program source code as UTF-8 encoded with BOM-code. The BOM-Code is the hexadecimal sequence x'efbbbf' in the beginning of a stream file and is recognized by most text editor as well as IceBreak compiler. Most editors has the feature to do "Save with encoding" flag, which will place the BOM code.
  2. In the IceBreak program, setContentType('text/html; charset=UTF-8');
  3. Let the server be set to Cyrillic CCSID

Best regards,

Niels Liisberg

Hi Niels,

Thank you for the advice. Executing step two of your reply solved the problem. I have set the server to Cyrillic CCSID from the very beginning (Step three). I couldn't implement step 1, due to IceBreak compiler errors. Finally I have a working IceBreak server and can proceed my work.

Once again many thanks and I consider the problem as solved.

Best regards,

Hristo