Oracle Character Set.

[datamart]

Need to get some information related to Character set UTF-8 and ISO-8859-1
Version 9i

Currently when we implemented UTF-8, every special character occupied an additional byte. This means that we need to possibly double the field length in the oracle table.

To avoid this, can we implement ISO-8859. I heard that this does not occupy additional bytes for such characters.

Can someone please advise. Or is there any other solution.. I do not want to change the length of the oracle table.

thanks.

 

[hoinz]

It depends;
ISO-8859-1 is for characters from Western European languages.
If you know for sure that you will not (neither now nor in the future) need characters from Eastern Europe or Asia, you may stick to it.

Otherwise there is no other choice but Unicode (preferably UTF-8).
By the way, afaik, characters from Asia may need more than two bytes (up to four) even with UTF8.

regards

 

[datamart]

yes.. this system only deals with European countries and their data.
So can I be positive and use 8859-1

many thanks.