Skip to Content
DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
book

DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide

by Whei-Jen Chen, Peter Z He, Kang Yong Ying, Andreas Paulsen, Sunminder S Saini
March 2004
Intermediate to advanced
440 pages
11h 46m
English
IBM Redbooks
Content preview from DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
68 DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
tuning of DB2 UDB V8” on page 237, we give some advice on how to choose the
correct data types.
String data
This section describes the three string data types CHAR, VARCHAR and LONG
VARCHAR. Each character string is further defined as one of:
򐂰
Bit data: Data that is not associated with a code page
򐂰
Single-byte character set (SBCS) data: Data in which every character is
represented by a single byte
򐂰
Mixed data: Data that may contain a mixture of characters from a single-byte
character set and a multi-byte character set (MBCS)
When defining the length of a string data type, it is important to keep in mind that
the length represents the number of bytes and not the number of character ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

DB2 for z/OS and WebSphere Integration for Enterprise Java Applications

DB2 for z/OS and WebSphere Integration for Enterprise Java Applications

Paolo Bruni, Zhen Hua Dong, Josef Klitsch, Maggie Lin, Rajesh Ramachandran, Bart Steegmans, Andreas Thiele
DB2 for z/OS and WebSphere: The Perfect Couple

DB2 for z/OS and WebSphere: The Perfect Couple

Bart Steegmans, Carsten Block, John De Dominicis, Sean Lee, Chao-Lin Liu, Egide Van Aerschot
DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition

Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, Paul Yip

Publisher Resources

ISBN: 0738498211Purchase book