MX7 with Oracle and US ASCII fields

[coderWil]

We are currently running 5.0 and tried upgrading to 6.1 about 18 months ago.
We have multi-lingual text stored in an Oracle database using US ASCII data
fields (generic varchar2)

We were not able to do the upgrade because 6.1 did not have the backward
compatible language support that it advertised. I am looking to see if anyone
has a similar situation and has been able to upgrade to MX7 successfully. We
are really wanting to upgrade without the hassle of rebuilding a new Oracle
database and migrating the date from ascii to unicode.

Any and all help is greatly appreciated.

William

[Neculai Macarie]

coderWil wrote:

> We are currently running 5.0 and tried upgrading to 6.1 about 18
> months ago. We have multi-lingual text stored in an Oracle database
> using US ASCII data fields (generic varchar2)

If you're keeping what is essentially binary data in US ASCII type fields
then I would say that your db is broken.

> We were not able to do the upgrade because 6.1 did not have the
> backward compatible language support that it advertised. I am
> looking to see if anyone has a similar situation and has been able to
> upgrade to MX7 successfully. We are really wanting to upgrade
> without the hassle of rebuilding a new Oracle database and migrating
> the date from ascii to unicode.

You could try setting the JVM charset to US ASCII (there are some docs about
this that I found with google) and see if it helps.

--
<mack />