Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.

    Jan 29

    IBM DB2 for z/OS, V8 - UNICODE

    Amit Agarwal
    I have two questions regarding unicode support.
    1. How many bytes does each character have? From what I understand, unicode
    can come in
    three forms, UTF-8, UTF-16, UTF -32. Which ones does Db2 support.
    2. How does this compatibility compare with Oracle9i ? Oracle9i does not
    any fixed width, multibyte character set as its database character set,
    since the database
    character set must be either 7bit ASCII or EBCIDIC. However, data can be
    in any format.


    "Grainger, Phil" <[login to unmask email]> on 01/28/2003 01:36:27 PM

    Please respond to DB2 Data Base Discussion List <[login to unmask email]>

    To: [login to unmask email]

    cc: (bcc: Amit Agarwal/FIS)

    Subject: Re: IBM DB2 Universal Database for z/OS, V8

    but who said Version numbers were SMALLINT?? Don't forget 1.2, 1.3, 2.3 =
    etc - looks like they are DECIMAL(2,1) at least to me.. So V8 must =
    really be V8.

    Phil Grainger=20
    Computer Associates=20
    Product Manager, DB2=20
    Tel: +44 (0)161 928 9334=20
    Fax: +44 (0)161 941 3775=20
    Mobile: +44 (0)7970 125 752=20
    [login to unmask email]=20

    -----Original Message-----
    From: Jardine, Lawrence J [mailto:[login to unmask email]
    Sent: 28 January 2003 18:12
    To: [login to unmask email]
    Subject: Re: [DB2-L] IBM DB2 Universal Database for z/OS, V8

    I guess you had to write the code to "support generating unique =
    numbers for applications" before you could determine that V8 would be =
    release after V7. :)

    -----Original Message-----
    From: Roger Miller [mailto:[login to unmask email]
    Sent: Tuesday, January 28, 2003 11:51 AM
    To: [login to unmask email]
    Subject: Re: IBM DB2 Universal Database for z/OS, V8

    Now we get to find all of those Vnexts and change them to Version 8 or =

    I checked the web this morning, and most of the changes are done, but =
    are still some updates to make and glitches to fix. The easy URL to =
    type is Then click to the V8 page.

    or paste in

    The What's New? book has the primary description. The overview =
    has about 100 foils and notes. We'll be getting others updated as we =
    get to them.

    Roger Miller, DB2 for z/OS

    DB2-L webpage at The owners of the list can =

    This e-mail may contain confidential or privileged information. If you
    think you have received this e-mail in error, please advise the sender =
    reply e-mail and then delete this e-mail immediately. Thank you. Aetna

    the DB2-L webpage at The owners of the list =

    Roger Miller
    [IBM Silicon Valley Lab]
    DB2 Unicode support is UTF-8 and UTF-16.
    Much of the DB2 Unicode support has been there for a while, so the
    information is out on the web. I'd suggest the redbook DB2 Version 7
    Presentation Guide, SG24-6121 or a presentation with Unicode in the title on

    You may also want to look at the oerating system Unicode support.

    The changes for DB2 V8 are outlined in the overview and What's New? book on
    the DB2 for z/OS V8 page,

    Roger Miller

    All Times America/Chicago

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact