October 16, 2006 at 2:44 pm
I’m looking for some direction. I have a project coming up that entails converting our peoplesoft env to Unicode for international support. I am the DBA on the project and there are a couple PS gurus working on the app side. I worked on English DBs. So, what do I need to know? I recall there was options during SQL install? Do I need to reinstall SQL? PS has a tool to actually convert the data. Should I plan plan on having the DB double in size? From a theoretical standpoint, Unicode takes up twice as much space, right? Two bits versus the standard one?
October 17, 2006 at 1:16 pm
Here's a few points off of the top of my head based on your questions:
So, what do I need to know? Do you have room on your present database server to support an additional database 3-4 times the size of the one to be converted ? Do you have a test server capable of handling the conversion ?
I recall there was options during SQL install? You are looking at 'collation'.
Do I need to reinstall SQL? This depends on the 'collation' of the original installation of SQL Server.
PS has a tool to actually convert the data. All I can say is test, test, test ...
Should I plan plan on having the DB double in size? That would seem to be an extremely safe estimation for production planning purposes. However the 'conversion' tool that PS has, depending on what it does, tables sizes and such may cause you to have to ballon your database data and transaction logs to 3-4 times thier initial size. Once the 'conversion is complete you can then shrink things down to the initial estimation of double the present size.
From a theoretical standpoint, Unicode takes up twice as much space, right? Unicode characters take 2 bytes of storage as opposed to one byte for regular character sets when dealing with char, varchar and text data. All of your numeric idata; intr, money, float, etc; will not need any additional storage.
Two bits versus the standard one? 2 bytes vs 1 byte for char, varchar and text data.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply