Re: significance of character set

On Tue, 14 Dec 1999 03:00:05 GMT, eddycheung78_at_my-deja.com wrote:

To check what character set you are currently using within the db, select * from sys.props$;

look for the value of the nls_characterset parameter. If you decide to change it. Make sure you have a full export and cold backup, delete the database, recreate the database with the correct character set, then import the schemas that you need to restore. ~Jim
>
>
>How can I check the characeter set that I am
>using ? Is it possible to change it if I find
>that I have set it wrong ? if so, How can I do
>it ?
>
>Thanks
>
>Eddy
>
>In article
><82o95m$14dsu$1_at_oceanite.cybercable.fr>,
> "Michel Cadot" <micadot_at_netcourrier.com> wrote:
>> Character set is the way all the characters are
>coded
>> (translated into an internal binary code).
>>
>> If you are french you will use e with acute
>accent, if
>> you are german sharp s, icelandic tohrn or eth,
>> spanish n tilde, and all the chinese or arabic
>characters.
>>
>> All these characters are not present in all the
>character
>> sets so you have to choose one and let Oracle
>know what is
>> your set of characters and what translation
>function
>> it will use to store these characters.
>>
>> --
>> Have a nice day
>> Michel
>>
>> Anurag <anurag_at_synergy-infotech.com> a écrit
>dans le message :
>> 1d3767a6.aacec1e4_at_usw-ex0101-001.remarq.com...
>> > Hi,
>> > What is a character set and why do we need to
>initialize it when
>> > creating a databaase.
>> >
>> > Thanks
>> > Anurag
>> >
>> > also reply at
>> > anurag_at_synergy-infotech.com
>> >
>> >
>> > * Sent from RemarQ http://www.remarq.com The
>Internet's Discussion Network *
>> > The fastest and easiest way to search and
>participate in Usenet - Free!
>> >
>>
>>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Dec 29 1999 - 20:10:22 CST