DB2 database with Greek/German characters

William Kloote

DB2 database with Greek/German characters
Hello Listers

Can we accomodate Greek characters (like sigma etc) in DB2 database. We are on DB2 version 8.

Any specific tasks are required on database end to accomodate Greek/German characters?.

Thanks in advance!

Thanks
William




______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Abe Kornelis

Re: DB2 database with Greek/German characters
(in response to William Kloote)
William,

using Unicode DB2 can handle it easily.

Whether or not your application(s) can handle
Unicode is a different question, though.

For one thing: Unicode has a different collating
sequence, therefore range predicates on CHAR
columns had better be replaced by LIKE predicates...

Success!

Abe Kornelis.
==========

----- Original Message -----
From: William Kloote
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Wednesday, January 14, 2009 8:43 PM
Subject: [DB2-L] DB2 database with Greek/German characters


Hello Listers

Can we accomodate Greek characters (like sigma etc) in DB2 database. We are on DB2 version 8.

Any specific tasks are required on database end to accomodate Greek/German characters?.

Thanks in advance!

Thanks
William



------------------------------------------------------------------------------

IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia

IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Peter Vanroose

Re: DB2 database with Greek/German characters
(in response to Abe Kornelis)
For the database part, it's easy: create a table(space) with a CCSID that
has greek characters, like e.g. UTF-8 (CCSID 1208; this is UNICODE) or 875
or 4971 (i.e., Greek EBCDIC; the latter with the euro sign).
For applications accessing that table, they'll also need some way to
represent Greek characters. Actually, when connecting to DB2, they must tell
DB2 which "language" (i.e., which CCSID) they speak, and DB2 will do the
necessary conversion (if possible) between table data and application (in
both directions). For a COBOL program, use the CODEPAGE or CP compile switch
to accomplish this.
To avoid conversions, take the same CCSID on both sides (if possible).
If characters cannot be represented (e.g., when the database has CCSID 875
and the application speaks CCSID 500 or 87), a "non-representable character"
substitute will be received.

-- Peter.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Jan tje

Re: DB2 database with Greek/German characters
(in response to Peter Vanroose)
On Wed, 14 Jan 2009 11:43:04 -0800, William Kloote
<[login to unmask email]> wrote:

>Hello Listers
>
>Can we accomodate Greek characters (like sigma etc)?in DB2 database. We
>are on DB2 version 8.

Yes, you can. Since waaaayyyyy back... Just use the corresponding code
page.
Or, if you really must: there is Unicode nowadays.


>Any specific tasks are required on database end to accomodate
>Greek/German characters?.

Apart from creating the tables to hold the data, not that I know off...

Cheers,

Jantje.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: DB2 database with Greek/German characters
(in response to Jan tje)
>Or, if you really must: there is Unicode nowadays.

It's DB2V8, so he really must!
-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Peter Vanroose

Re: DB2 database with Greek/German characters
(in response to Ted MacNEIL)
>> Or, if you really must: there is Unicode nowadays.
>
>It's DB2V8, so he really must!

Not necessarily!
- CCSID 1208 has been around from before DB2v8
- other CCSIDs exist (still in v8 or v9) which can represent Greek letters

Essentially, only two things changed between v7 and v8 in this respect:
(1) most of the catalog became unicode (CCSID 1208)
(2) DB2 automatically converts between codepages,
both of tables (e.g. in a join) and of applications.

-- Peter.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Sysdba_AHE/CORP/TPG

Re: DB2 database with Greek/German characters
(in response to Peter Vanroose)
William,

As you said you're on "DB2 version 8" that probably means on z/OS, doesn't
it? If you're talking about LUW then please ignore this.

On z/OS you cannot create tables with different EBCDIC codepages in the
same DB2 catalog (i.e. data sharing group or standalone subsystem). Unless
your whole system can be set up to use the desired codepage, Unicode is
your only possibility.

However if you define your character column(s) as FOR BIT DATA you can
store whatever you like, in which case the application is entirely
responsible for correctly interpreting and/or converting the data. You
could even store Unicode characters in an EBCDIC table that way (IBM's own
Message Broker does exactly that).

Regards

Neil Price
TNT Express ICS, UK

---------------------------------------------------------------------------------------------------------------
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.
If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system.
If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
Please consider the environmental impact before printing this document and its attachment(s). Print black and white and double-sided where possible.
------------------------------------------------------------------------------

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html