Home » SQL & PL/SQL » SQL & PL/SQL » Internationalization (10G)
Internationalization [message #411043] Wed, 01 July 2009 12:25 Go to next message
dolot
Messages: 11
Registered: July 2009
Junior Member
Hey,

I'm wondering how Oracle handles data in non-english languages. This is particularly in regards to sorting. How do I make sure my data will be sorted in the language of the user and not in the default language?

Maybe I'm not making any sense, or perhaps I'm not asking my question correctly. I know that certain languages do alphabetical sorting in different ways, and I want to know what I can expect when I ask Oracle to return a set of query results sorted. Will they sort by English rules, by the rules of the language of the OS, by the rules of the Oracle installation, or by something else?

Thanks for any assistance. Please let me know if I posted this in the wrong forum. Embarassed
Re: Internationalization [message #411044 is a reply to message #411043] Wed, 01 July 2009 12:26 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Look at NLS_LANG setting.
Re: Internationalization [message #411048 is a reply to message #411043] Wed, 01 July 2009 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Globalization Support Guide
Chapter 1 Overview of Globalization Support
Section Language Support
and then follow the first link.

Regards
Michel
Re: Internationalization [message #411054 is a reply to message #411048] Wed, 01 July 2009 14:04 Go to previous messageGo to next message
dolot
Messages: 11
Registered: July 2009
Junior Member
Now pardon my ignorance, but if I change the language to say, French, does that mean my SQL keywords have to be translated to French?
Re: Internationalization [message #411058 is a reply to message #411054] Wed, 01 July 2009 14:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL is SQL, it is a standard computer language, a computer language is not english nor any other language, it is ITS language.
So SELECT is always SELECT, FROM always FROM, WHERE always WHERE...

Regards
Michel
Re: Internationalization [message #411063 is a reply to message #411058] Wed, 01 July 2009 14:50 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Things that users will see, like error messages, formatted dates, etc. will typically be in French, the back-end stuff will be standard SQL or PL/SQL (with English reserve words).
Re: Internationalization [message #411066 is a reply to message #411043] Wed, 01 July 2009 15:11 Go to previous message
dolot
Messages: 11
Registered: July 2009
Junior Member
Thanks for the assistance - it sure beats having to pour over documentation. Smile
Previous Topic: partition tables
Next Topic: Creating oracle table from external files
Goto Forum:
  


Current Time: Sun Dec 04 02:50:17 CST 2016

Total time taken to generate the page: 0.09698 seconds