How do I feed Turkish, Greek and English in the same DB2?

Pantazis Pantazi

How do I feed Turkish, Greek and English in the same DB2?

Hi guys,

I need your help AGAIN with an issue that has just appeared regarding
CCSIDs and the Turkish language... :) My knowledge
about how the whole codepage conversion issue works, is very limited so I
would really appreciate your help.

How can I make it work so that I am able to store English, Turkish and
Greek Characters in mainframe DB2???

We are working with DB2 for OS/390 and z/OS v7 and DB2 Connect v7 on the
windows clients and we are storing English
and Greek Characters in the DB2 on the mainframe. The codepages of the
various components are listed below:

PC Codepage 737 ASCII (result of CHCP)
DB2CODEPAGE 1253 (on the DB2 Connect)
PCOMM Codepage 875 (Greece) EBCDIC
Host Codepage 37 (US) EBCDIC

In to be able to store the Greek Characters, a conversion table was build
by IBM to convert the characters
between codepage 37 and 1253 and vice versa.

Now we are considering the addition of Turkish Language and do not how to
proceed.

Thanks in advance,
Pantazis

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: How do I feed Turkish, Greek and English in the same DB2?
(in response to Pantazis Pantazi)
Unicode is the only way to store multiple character sets in the same DB2
table

It also gets you away (I think) from all the codepage issues as well


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



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of zakis
Sent: 24 November 2005 06:55
To: [login to unmask email]
Subject: [DB2-L] How do I feed Turkish, Greek and English in the same
DB2?



Hi guys,

I need your help AGAIN with an issue that has just appeared regarding
CCSIDs and the Turkish language... :) My knowledge
about how the whole codepage conversion issue works, is very limited so
I would really appreciate your help.

How can I make it work so that I am able to store English, Turkish and
Greek Characters in mainframe DB2???

We are working with DB2 for OS/390 and z/OS v7 and DB2 Connect v7 on the
windows clients and we are storing English
and Greek Characters in the DB2 on the mainframe. The codepages of the
various components are listed below:

PC Codepage 737 ASCII (result of CHCP)
DB2CODEPAGE 1253 (on the DB2 Connect)
PCOMM Codepage 875 (Greece) EBCDIC
Host Codepage 37 (US) EBCDIC

In to be able to store the Greek Characters, a conversion table was
build by IBM to convert the characters
between codepage 37 and 1253 and vice versa.

Now we are considering the addition of Turkish Language and do not how
to proceed.

Thanks in advance,
Pantazis
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Pantazis Pantazi

Re: How do I feed Turkish, Greek and English in the same DB2?
(in response to Phil Grainger)
I already had Unicode in mind and I was basically hoping for a less time
and resource consuming procedure.

Now unfortunately you are bringing me down to earth. :)

Thank you for your reply Phil.



|---------+----------------------------->
| | "Grainger, Phil"|
| | <[login to unmask email]>|
| | Sent by: DB2 Data Base|
| | Discussion List|
| | <[login to unmask email]>|
| | |
| | 24/11/2005 11:15 ðì|
| | Please respond to DB2|
| | Database Discussion list at|
| | IDUG|
| | |
|---------+----------------------------->
>-------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| bcc: |
| Subject: Re: [DB2-L] How do I feed Turkish, Greek and English in the same DB2? |
| |
>-------------------------------------------------------------------------------------------------------------|




Unicode is the only way to store multiple character sets in the same DB2
table

It also gets you away (I think) from all the codepage issues as well



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




From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of zakis
Sent: 24 November 2005 06:55
To: [login to unmask email]
Subject: [DB2-L] How do I feed Turkish, Greek and English in the same DB2?



Hi guys,

I need your help AGAIN with an issue that has just appeared regarding
CCSIDs and the Turkish language... :) My knowledge
about how the whole codepage conversion issue works, is very limited so I
would really appreciate your help.

How can I make it work so that I am able to store English, Turkish and
Greek Characters in mainframe DB2???

We are working with DB2 for OS/390 and z/OS v7 and DB2 Connect v7 on the
windows clients and we are storing English
and Greek Characters in the DB2 on the mainframe. The codepages of the
various components are listed below:

PC Codepage 737 ASCII (result of CHCP)
DB2CODEPAGE 1253 (on the DB2 Connect)
PCOMM Codepage 875 (Greece) EBCDIC
Host Codepage 37 (US) EBCDIC

In to be able to store the Greek Characters, a conversion table was build
by IBM to convert the characters
between codepage 37 and 1253 and vice versa.

Now we are considering the addition of Turkish Language and do not how to
proceed.

Thanks in advance,
Pantazis
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm




Philip Sevetson

Re: How do I feed Turkish, Greek and English in the same DB2?
(in response to Pantazis Pantazi)
zakis,

Phil's right, that's what Unicode was made for. For things like the
"Product Name" column where the product name on the jar could be in Arabic,
Chinese, English, Farsi, French, Greek, Hebrew, Spanish, or Turkish, just to
pick one example not at random from the grocery business. Do the Lebanese
speak Arabic, or a language of their own? (Fortunately no one's asked _me_
to solve this kind of problem, _yet_.)

--Phil S.


On 11/24/05, zakis <[login to unmask email]> wrote:
>
> I already had Unicode in mind and I was basically hoping for a less time
> and resource consuming procedure.
>
> Now unfortunately you are bringing me down to earth. :)
>
> Thank you for your reply Phil.
>
> [image: Inactive hide details for "Grainger, Phil" <[login to unmask email]>]"Grainger,
> Phil" <[login to unmask email]>
>
>
>
>
> *"Grainger, Phil" <[login to unmask email]>*
> Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
> 24/11/2005 11:15 ðì
> Please respond to DB2 Database Discussion list at IDUG
>
>
> To: [login to unmask email]
> cc:
> bcc:
> Subject: Re: [DB2-L] How do I feed Turkish, Greek and English in the same
> DB2?
>
> Unicode is the only way to store multiple character sets in the same DB2
> table
>
> It also gets you away (I think) from all the codepage issues as well
>
> Phil Grainger
> CA
> Product Manager, DB2
> Tel: +44 (0)161 928 9334
> Fax: +44 (0)161 941 3775
> Mobile: +44 (0)7970 125 752
> [login to unmask email]
>
>
>
> ------------------------------
> *From:* DB2 Data Base Discussion List [mailto:[login to unmask email]<[login to unmask email]>]
> *On Behalf Of *zakis*
> Sent:* 24 November 2005 06:55*
> To:* [login to unmask email]*
> Subject:* [DB2-L] How do I feed Turkish, Greek and English in the same
> DB2?
>
> Hi guys,
>
> I need your help AGAIN with an issue that has just appeared regarding
> CCSIDs and the Turkish language... :) My knowledge
> about how the whole codepage conversion issue works, is very limited so I
> would really appreciate your help.
>
> How can I make it work so that I am able to store English, Turkish and
> Greek Characters in mainframe DB2???
>
> We are working with DB2 for OS/390 and z/OS v7 and DB2 Connect v7 on the
> windows clients and we are storing English
> and Greek Characters in the DB2 on the mainframe. The codepages of the
> various components are listed below:
>
> PC Codepage 737 ASCII (result of CHCP)
> DB2CODEPAGE 1253 (on the DB2 Connect)
> PCOMM Codepage 875 (Greece) EBCDIC
> Host Codepage 37 (US) EBCDIC
>
> In to be able to store the Greek Characters, a conversion table was build
> by IBM to convert the characters
> between codepage 37 and 1253 and vice versa.
>
> Now we are considering the addition of Turkish Language and do not how to
> proceed.
>
> Thanks in advance,
> Pantazis
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>
>


--
--Phil Sevetson
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
OS/390
IBM Certified Database Administrator -- DB2 Universal Database V8.1 for zOS
Wakefern Food Corporation
Edison, NJ, USA
ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS EMAIL
ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.

Pantazis Pantazi

Re: How do I feed Turkish, Greek and English in the same DB2?
(in response to Philip Sevetson)
I think I have the confirmation that I needed about unicode.

Thanks to everybody who replied, for your answers.
Pantazis



|---------+----------------------------->
| | Philip Sevetson|
| | <[login to unmask email]>|
| | Sent by: DB2 Data Base|
| | Discussion List|
| | <[login to unmask email]>|
| | |
| | 30/11/2005 11:23 ìì|
| | Please respond to DB2|
| | Database Discussion list at|
| | IDUG|
| | |
|---------+----------------------------->
>-------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| bcc: |
| Subject: Re: [DB2-L] How do I feed Turkish, Greek and English in the same DB2? |
| |
>-------------------------------------------------------------------------------------------------------------|




zakis,

Phil's right, that's what Unicode was made for. For things like the
"Product Name" column where the product name on the jar could be in Arabic,
Chinese, English, Farsi, French, Greek, Hebrew, Spanish, or Turkish, just
to pick one example not at random from the grocery business. Do the
Lebanese speak Arabic, or a language of their own? (Fortunately no one's
asked _me_ to solve this kind of problem, _yet_.)

--Phil S.






Pantazis Pantazi

Re: How do I feed Turkish, Greek and English in the same DB2?
(in response to Pantazis Pantazi)

I think I have the confirmation that I needed about unicode.

Thanks to everybody who replied, for your answers.
Pantazis

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm