Re: [p-c] farsi-EBCDIC cp1097

[Mehdi H.]

Salaam,

IBM's cp1097 is old farsi and kinda obsolete, we've defined a cp for our customers usage that is fully compatible with MS Windows-1256. For the Oracle we set AR8MSWIN1256 on clients and our patched .nlb on z/OS

Bests,
--Mehdi

On Sun, Nov 15, 2009 at 10:42 AM, Reza Fathi <fath...@yahoo.com> wrote:

Hello Mehdi, Thanks for replying. The problem is that I am loosing these characters on windows side before it gets to Z/OS. What can I do on windows side for this problem. The windows side is set utf-16 and on regional Language I have selected the ebcdic arabic20420. Now I am loose the extra farsi characters when data is submitted to z/os. Thanks... R.Fathi --- On Sun, 11/15/09, Mehdi H. <h.m...@gmail.com> wrote: From: Mehdi H. <h.m...@gmail.com> Subject: Re: [p-c] farsi-EBCDIC cp1097 To: "Reza Fathi" <fath...@yahoo.com> Date: Sunday, November 15, 2009, 6:32 AM Reza, Oracle has a utility called lbuilder that can be used to customize existing or create a new language file from scratch, then it builds a .nlb file that oracle can use! But unfortunately lbuilder is buggy on z/OS and can't build what you need... We had to hex edit those files to implement MS 1256 code page for oracle on z/OS... Bests, --Mehdi On Fri, Nov 6, 2009 at 10:45 AM, Reza Fathi <fath...@yahoo.com> wrote: Dear Friends, I have a windows oracle client which is connected to  Z-OS(os390) which is IBM-mainframe with EBCDIC character set. The .nls files under windows (National Language Support) files are responsible for translation back and forth. The problem is that in windows there is   C_20420.nls which is arabic EBCDIC and it does not have the farsi letters(jeh,gaf,....). The code page for farsi-ebcdic is 1097 which is defined by IBM. I just can not find the c_1097.nls file. Does anyone know where this nls file can be found or is there a utility that we can create our own nls files under windows. Thanks Everyone R.Fathi -- |_|0|_|   Yours Sincerely, Mehdi Hassanpour |_|_|0|  |0|0|0|   http://Hezardastan..org , http://www.ubuntu.ir

--
|_|0|_|   Yours Sincerely, Mehdi Hassanpour
|_|_|0|
|0|0|0|   http://Hezardastan.org , http://www.ubuntu.ir

[Mohammad Reza Nouri]

Dear Mr. Hassanpour
We alreay installed Oracle 10G on Z/OS with characterset
AR8EBCDIC420s,set the client CS to AR8MSWIN156,could you please help
us for 4 farsi characters difinition.
thanks
reza

On Nov 16, 10:23 am, "Mehdi H." <h.me...@gmail.com> wrote:
> Salaam,
>
> IBM's cp1097 is old farsi and kinda obsolete, we've defined a cp for our
> customers usage that is fully compatible with MS Windows-1256. For the
> Oracle we set AR8MSWIN1256 on clients and our patched .nlb on z/OS
>
> Bests,
> --Mehdi
>
>
>
>
>
> On Sun, Nov 15, 2009 at 10:42 AM, Reza Fathi <fathir...@yahoo.com> wrote:
> > Hello Mehdi,
>
> > Thanks for replying. The problem is that I am loosing these characters on
> > windows side before it gets to Z/OS. What can I do on windows side for this
> > problem.
> > The windows side is set utf-16 and on regional Language I have selected the
> > ebcdic arabic20420.
> > Now I am loose the extra farsi characters when data is submitted to z/os.
>
> > Thanks...
> > R.Fathi
>

> > --- On *Sun, 11/15/09, Mehdi H. <h.me...@gmail.com>* wrote:

>
> > From: Mehdi H. <h.me...@gmail.com>
> > Subject: Re: [p-c] farsi-EBCDIC cp1097
> > To: "Reza Fathi" <fathir...@yahoo.com>
> > Date: Sunday, November 15, 2009, 6:32 AM
>
> > Reza,
>
> > Oracle has a utility called lbuilder that can be used to customize existing
> > or create a new language file from scratch, then it builds a .nlb file that
> > oracle can use! But unfortunately lbuilder is buggy on z/OS and can't build
> > what you need... We had to hex edit those files to implement MS 1256 code
> > page for oracle on z/OS...
>
> > Bests,
> > --Mehdi
>

> > On Fri, Nov 6, 2009 at 10:45 AM, Reza Fathi <fathir...@yahoo.com<http://mc/compose?to=fathir...@yahoo.com>

> > > wrote:
>
> >>  Dear Friends,
>
> >> I have a windows oracle client which is connected to  Z-OS(os390) which
> >> is IBM-mainframe
> >> with EBCDIC character set.
> >> The .nls files under windows (National Language Support) files are
> >> responsible for
> >> translation back and forth. The problem is that in windows there is
> >> C_20420.nls which is
> >> arabic EBCDIC and it does not have the farsi letters(jeh,gaf,....).
> >> The code page for farsi-ebcdic is 1097 which is defined by IBM. I just
> >> can not find the
> >> c_1097.nls file.
> >> Does anyone know where this nls file can be found or is there a utility
> >> that we can create our own nls files under windows.
>
> >> Thanks Everyone
> >> R.Fathi
>
> > --
> > |_|0|_|   Yours Sincerely, Mehdi Hassanpour
> > |_|_|0|

> > |0|0|0|  http://Hezardastan..org<http://Hezardastan.org> ,
> >http://www.ubuntu.ir
>

> --
> |_|0|_|   Yours Sincerely, Mehdi Hassanpour
> |_|_|0|

> |0|0|0|  http://Hezardastan.org,http://www.ubuntu.ir- Hide quoted text -
>
> - Show quoted text -

[Mehdi H.]

Mohammad Reza,

As I mentioned earlier since oracle's lbuilder is buggy/useless under z/OS we've patched (hex edited) nlb files to implement MS 1256 code page. So you need to hex edit nlb files and include characters as you wish...

Bests,
--Mehdi

--

http://groups.google.com/group/persian-computing

--
|_|0|_|   Yours Sincerely, Mehdi Hassanpour
|_|_|0|

|0|0|0|   http://Hezardastan.org , http://www.ubuntu.ir

Ogden Nash  - "The trouble with a kitten is that when it grows up, it's always a cat."