Convert Oracle data with Unicode to ASCII

[Lourry]

Referring to this Post

I am using Access 97 and it is connecting to an Oracle database but the data that is stored in the tables are unicode and of course, Access 97 does not support unicode. Is there a way that I can convert the data in Oracle to ASCII so that it can show up properly when a user view the data in an Access 97 form?

Thanks a lot!
-Lory

 

[SantaMufasa]

Lory,

It would depend upon how "Unicode-ie" your data are. By definition, ASCII is 8-bit maximum. If your data include Arabic, Hebrew, Japanese, Chinese, Thai, or someother 2-byte character, what ASCII character (beside the infamous "?" character) should apply?

If your data fall below ASCII 255, then you can represent it satisfactorily. But at that point, why bother with Unicode, right?

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:40 (10Jun04) UTC (aka "GMT" and "Zulu"), 10:40 (10Jun04) Mountain Time)

 

[Lourry]

Hmmm.....this is the case, in Access 97 I have created a form that points to that field in a linked Oracle table through ODBC. And this is what the data looks like:

t|e|s|t|t|e|s|t| |t|e|s|t| |t|e|s|t|||t|e|s|t|

What it is suppose to look like:
testtest test test
test

So, it turns out that in A97, it shows bars in between letters and doesn't perform the carriage return when it is suppose to. Oh...the table only contains english, no foreign languages.

Any ideas on how I can convert the text from what it looks like now (with bars between letters) to what it is suppose to look like?

Thanks again!
-Lory

 

[sem]

What is your NLS_LANG client parameter?

Regards, Dima

http://seminihin.narod.ru

 

[Lourry]

Hello,

where can I find that out?

Thanks!

 

[sem]

In registry under Oracle key.

Regards, Dima

http://seminihin.narod.ru

 

[Lourry]

Hello sem,

The value is NA

this access form will turn in a .mde file at the end for distribution. If by changing this can solve the issue, then would all users need to do so?

Thanks for your help!