Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: March 15, 2017 - 8:21 am UTC

Last updated: March 15, 2017 - 8:48 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,

I would like to know about the Character sets Purpose,need of them In Data Base?

and Connor said...

Well...we got a whole book for that !

http://docs.oracle.com/database/122/NLSPG/toc.htm

and from the doc:

"Consider the following questions when you choose an Oracle Database character set for the database:

- What languages does the database need to support now?
- What languages does the database need to support in the future?
- Is the character set available on the operating system?
- What character sets are used on clients?
- How well does the application handle the character set?
- What are the performance implications of the character set?
- What are the restrictions associated with the character set?"


But in short, for any *new* database I create, I would probably choose AL32UTF8 to keep my options open for any and all requirements that might come up in future.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.