Question for you. [message #61883] |
Tue, 08 June 2004 14:05 |
Ashish Choudhary
Messages: 2 Registered: June 2004
|
Junior Member |
|
|
Dear Sir,
I am working on a project where in oracle, we use ascii character set and now we are planning to convert it to utf8 for multiple language support. Now lets say the space occupied by the database is 10 GB so now we need to calculate the size of the database after UTF8 character set is implemented.
It is urgent ................
Thanks AShish
|
|
|
Re: Question for you. [message #61889 is a reply to message #61883] |
Tue, 08 June 2004 20:43 |
Anatol Ciolac
Messages: 113 Registered: December 2003
|
Senior Member |
|
|
At first you must to see if you can to convert whithout errors with csscan utility. Generally size of database must not to grow much. Exception is if csscan will show that some values will not convert correct, then you will resize width of that columns. And it will be a good idea to read about converting in metalink.
|
|
|
Re: Question for you. [message #61909 is a reply to message #61889] |
Wed, 09 June 2004 08:14 |
Ashish Choudhary
Messages: 2 Registered: June 2004
|
Junior Member |
|
|
Thanks for the update Anatol.
csscan is ok. but actually what are we looking for is how can I estimate the space requirement when we switch to UTF8 because the byte representation will change. Earlier it was 8 or 7 bit character representation but now it is 16 or 32 bit representation.
Do you have a better way to calculate the required size?
I appreciate your reply...
|
|
|
Re: Question for you. [message #61914 is a reply to message #61909] |
Wed, 09 June 2004 21:08 |
Anatol Ciolac
Messages: 113 Registered: December 2003
|
Senior Member |
|
|
If csscan will write that you will change a characterset(or national characterset) without problem, then size of your database will not grow(at last will remain approximately as was). A particularity of UTF8 is: if you are put a ASCII symbol to database, then for keeping them database will spend a 8 bit for him, if you will put a other symbol(for example national symbol), then for keeping them will be needed 32 bit.
P.S.csscan have a one bug and can show some errors when they are not exists.
|
|
|