Number data format 1

[axmug]

We have a server running HP-UX and some clients running Windows. We want to run data in an Oracle database and everything is correct except decimal numbers.

In Windows the default separator for decimal numbers is , (we don't have english format) and in the server is . (english format). The problem is the running of data to the server. We want to change the server configuration and have , as default separator.

We have changed the .profile and local variables but it didn't work.

How can we change the default decimal format from . to ,?

Thanks.

 

[KenCunningham]

I think you probably can't if what you're trying to do is change the seperator in a text file. What you could do is use sed/awk/whatever, to replace all , with . in your text file before processing it or whatever. Post back if that sounds reasonable and you need a hand to do it.

 

[MikeLacey]

This is an Oracle problem and it's to do with the NLS_LANG variable (I think)

I'd ask in an Oracle forum I think.

Mike

"Deliver me from the bane of civilised life; teddy bear envy."

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[KenCunningham]

Mike, I think you're probably right - my misinterpretation.

 

[MikeLacey]

I'm always right Ken You know that...

(right by accident if I am, the techies don't let me login to production boxes anymore)

Mike

"Deliver me from the bane of civilised life; teddy bear envy."

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[axmug]

Ken,

The problem isn't the text file. We used vi to modify .profile data.

We think the problem is in the NLS_LANG variable as Mike just said but we don't know where can we find this variable. Anyone knows it?

Thanks.

 

[KenCunningham]

My bad. Take a look at:

http://www.dbaoncall.net/references/ref_nls_lang.html

 

[MikeLacey]

You can, as I remember, change a database from one character set to another. It's a non-trivial process involving down-time.

First step is make sure NLS_LANG is set to the same in the three places it is set.

1 - Database
2 - Application
3 - Terminal


Mike

"Deliver me from that bane of civilised life; teddy bear envy."

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[MikeLacey]

axmug - here's the 9i forum for you forum759

Mike

"Deliver me from that bane of civilised life; teddy bear envy."

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[axmug]

The problem has been solved. It was the NLS_LANG variable. Its format is LANGUAGE_TERRITORY.CHARACTERSET where TERRITORY is where decimal separator is controlled.

Thanks to Mike and Ken for replying.