IBM DB2 for z/OS, V8 - UNICODE

Amit Agarwal

IBM DB2 for z/OS, V8 - UNICODE
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
support
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.

Thanks
Amit





"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 =
sequential
numbers for applications" before you could determine that V8 would be =
the
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 =
V8.

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

ibm.com/software/db2zos Then click to the V8 page.

or paste in http://www.ibm.com/software/data/db2/os390/db2zosv8.html

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

Roger Miller, DB2 for z/OS ibm.com/software/db2zos

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=
the
DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can =
be


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

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list =
can








Roger Miller

Re: IBM DB2 for z/OS, V8 - UNICODE
(in response to Amit Agarwal)
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
http://www.ibm.com/software/data/db2/os390/presentations.html

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,
http://www.ibm.com/software/data/db2/os390/db2zosv8.html

Roger Miller