Unicode codepage in Oracle 10g2 and PH v8.4.3 (i18n)

[Peter Bateman]

Hi

   I suspect the problem comes when QDESIGN queries the database for the 
length of the
   column. This length then becomes the size of the field in the screen 
layout.

   What we need is the number of glyphs.

   I would try
   a) Make a copy of ORACLE schema.
      have an empty database but declare the code page to be WE8ISO8859P1.
      Compile against this database but run against the other.

   b) write a macro that would read the metadata and place the SIZE option  
with a calculated field
      size on the field if the associated column is character

It is my uderstanding that any code page ending in UTF8 is simply telling
ORACLE to determine the character value from the 8 bit passed value and
a declared symbol table. A DOS865 user can talk to the same database as
a ROMAN8 user. ORACLE knows what symbol table that  each is using so it 
knows what
glyph values  to send out when returning a result set, etc.

   I would also ask Cognos to enhance POWERHOUSE to support UNICODE if it is 
not
   already there.


>Hi all
>
>We are moving from Oracle v8.1.7 to v10g r2 and we have recently upgraded 
>to PH v8.4.3
>
>While running Oracle v8.1.7 we used codepage WE8ISO8859P1.
>When upgrading to Oracle 10g r2 we tried out changing to multi-language 
>codepage AL32UTF8 but it appears that PH does not handle Unicode as it 
>multiplied all char-fieldsizes by 4 and made quick-screens look pretty 
>peculiar. This is, in itself, not surprising as each character may take up 
>4 bytes in Unicode-translation but are there any ways of telling PH not to 
>multiply filedsizes?
>
>Has anybody got experiences with PH and Unicode?
>
>We are running an international shop accross the Nordic and Baltic 
>countries thus having to deal with several codepages.
>
>
>
>Best regards
>Kim Bjørn Jensen
>Principal Consultant
>Lindorff AS
>Phone: +47 35 06 15 73
>Mobile: +47 911 15 313
>E-mail: kim-bjorn.jensen at lindorff.com 
><blocked::mailto:kim-bjorn.jensen at lindorff.com>
>Mailing Address: Postboks 4, NO-3833 Bø i Telemark, Norway
>
>