Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to store French language in to Oracle?

 
Ja vardhan
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Frendz,

According to my applcation needs, i need to store French, German etc (apart from english) in to database (Oracle). I am pretty new to this concept.

Pls. tell me in detail how can i store those language contents in to Database...

Thnx.

[edited to remove e-mail]

[ May 16, 2005: Message edited by: Jeanne Boyarsky ]
[ May 22, 2005: Message edited by: Bear Bibeault ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You don't need to change much to store French or German in Oracle, I think it supports Unicode by default. If it doesn't, you could specify the character set when you create your DB with the a simple command:

Alternatively, you can use NCHAR, NVARCHAR etc. datatypes, which allows you to store Unicode data regardless of the DB's defined character set.

The documentation has a whole chapter about supporting multilingual Databases. You probably should read that.
[ May 16, 2005: Message edited by: Paul Sturrock ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ja,
Welcome to JavaRanch!

Please use the forum instead of e-mail. That way everyone can benefit from the response.
 
Ja vardhan
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Paul,

Thank U so much for ur nice reply. Since I am new to this concept, I was not able to find out the solution for my problem. Really ur reply is helpful to me.

Thnx once again.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul,
You said:

The documentation has a whole chapter about supporting multilingual Databases

Pardon my ignorance, but I am curious to know, which chapter would that be?

Thanks (in advance),
Avi.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was too quick to say chapter - I should have said guide, which is the "Database Globalization Support Guide".
 
Ja vardhan
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Paul,

I gone through that 1st chapter and got some useful information.

I have those Japanse/French language required files with my system and i am able to type such languages from the keyboard in some editor or eord pad (I mea to say: I am watching those language characters on that editor or word pad). To store those German/French characters, first we need to type those language characters na !! On SQL*Plus those german characters are appearing like ???, not able to view like インセrtイントヴァゥエ.

What i need to do for that???

Any suggestions folks... pls.

[edited out e-mail again]
[ May 18, 2005: Message edited by: Jeanne Boyarsky ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Javardhan,
Please don't post your e-mail address in the message. It is in your profile if someone wants it. However, we ask people to use the forum as a primary means of answering questions. That way everyone can benefit from the answer.
 
Ja vardhan
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey Guyzz,

Can u plz reply with any solution r suggestion for my above specified problem.

Thnx.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65340
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ja vardahn,

JavaRanch is a community of people from all over the world, many of who are not native English speakers. While using abbreviations like "u" instead of spelling out "you" is convenient when text messaging your friends on a cell phone or in a chat room, it presents an extra challenge to those that are already struggling with English. Additionally, such shortcuts may confound automated translation tools that patrons of the Ranch may be making use of.

I would like to ask for your help in making the content of JavaRanch a little easier to read for everybody that visits here by not using such abbreviations.

thanks,
bear
Forum Bartender
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Ja vardhan:
Hi Paul,

I gone through that 1st chapter and got some useful information.

I have those Japanse/French language required files with my system and i am able to type such languages from the keyboard in some editor or eord pad (I mea to say: I am watching those language characters on that editor or word pad). To store those German/French characters, first we need to type those language characters na !! On SQL*Plus those german characters are appearing like ???, not able to view like インセrtイントヴァゥエ.

What i need to do for that???

Any suggestions folks... pls.

[edited out e-mail again]

[ May 18, 2005: Message edited by: Jeanne Boyarsky ]


Remember that SQL*Plus is just a "view" of the database, so changes to characters set settings in Oracle will not have any effect on a client application attaching to this database. You need to configure SQL*Plus to support the character sets you are going to store in the database - have a look at the NLS_LANG parameter and its implications (I think there is a chapter about this in the SQL*Plus User Guide).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic