By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Euro Symbol and ASCII-Tablespace

P: n/a
We are using ASCII-Tablespaces with the Codepage 819 on z/OS. We're now
having a problem with the EURO symbol. The data is inserted from a
Windows-Client, running Codepage 1252. The Euro symbol is not part of
the Codepage 819 which leads to a converting of the Euro Symbol to
hex(1A) in the Database. On the Client, hex(1A) is returned which is
different from the send hex(80).
Is there any other codepage which is similar to Codepage 819, but
includes the Euro Symbol which can be used for the tablespaces?

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
tilmann wrote:
We are using ASCII-Tablespaces with the Codepage 819 on z/OS. We're now
having a problem with the EURO symbol. The data is inserted from a
Windows-Client, running Codepage 1252. The Euro symbol is not part of
the Codepage 819 which leads to a converting of the Euro Symbol to
hex(1A) in the Database. On the Client, hex(1A) is returned which is
different from the send hex(80).
Is there any other codepage which is similar to Codepage 819, but
includes the Euro Symbol which can be used for the tablespaces?


Not really sure here, but perhaps 2byte unicode?
Codepages among OSes and DB2 suck :/ (if your using 2 clients with
different codepages)
Isn't it possible on z/OS to define the tablespace as latin? thus using
the same codepage as windows does?

-R-
Nov 12 '05 #2

P: n/a
tilmann wrote:
We are using ASCII-Tablespaces with the Codepage 819 on z/OS. We're now
having a problem with the EURO symbol. The data is inserted from a
Windows-Client, running Codepage 1252. The Euro symbol is not part of
the Codepage 819 which leads to a converting of the Euro Symbol to
hex(1A) in the Database. On the Client, hex(1A) is returned which is
different from the send hex(80).
Is there any other codepage which is similar to Codepage 819, but
includes the Euro Symbol which can be used for the tablespaces?

I would go for UTF-8 (unicode).
Plain ASCII (below X'80') takes just 1 byte in UTF-8

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.