“We are currently investigating including support for Unicode (UTF-8) language support, a worldwide standard, in the LANDesk Management Suite. The current consideration is whether or not to support, in addition to Unicode, the older code-page based language capability. Our current research has lead us to the design that would only support a Unicode implementation . The FAQ below is meant to answer questions that may surface about Unicode and Code-page support. After reading the FAQ, please feel free to respond in the Community. . . with your observations and any potential issues that would arise from a Unicode-only scenario.” If other concerns arise, please post and we’ll address them as well.
FAQ
· What if LDMS required a Unicode database and no longer supported a database that stored code-page data? Would I have to reinstall my database?
o We are not intending to do an in-place upgrade of the database. We will require a new database for the Unicode version of LDMS. For more information, see “How much work do I have to do to prepare for an LDMS Unicode release” below.
· Will the size of my database increase?
o In rare cases the size of the database will increase. We will standardize on UTF-8 encoded data. The UTF-8 encoding allows characters to be encoded as either one, two or three bytes. In the rare case that the Unicode character gets encoded as a three-byte character, your database will increase by one byte.
When LDMS supports a Unicode installation, all CHAR data types in the database will be converted to VARCHAR data types. CHAR data types are fixed length fields and if we used them, we would definitely increase the size of the database. However, we will not be using any CHAR data types when we switch to Unicode (for other reasons not pertaining to database size).
· Will the performance of my database degrade?
o We do not expect the performance of any queries to degrade. The degradation will come more from the amount of data in the table and the indexes being out-of-sync than it will from Unicode data existing in the table.
· How would I convert my existing data into Unicode?
o You won’t have to. This is something LDMS will do for you during the upgrade process. We will use the code-page of the DBMS server as the source and UTF-8 as the destination. Both Oracle and SQL Server support this type of conversion.
· What does “forcing Unicode” mean if I use SQL Server?
o This would mean LDMS would require the national character set data types (NCHAR, NVARCHAR, NTEXT). Every query that queries a string needs to add an N before the beginning quote, if the string being queried contains Unicode characters. For example
Select * from computer where devicename = ‘ABC’
Select * from computer where devicename = N'MultiByte Characters'
In the first example, A, B and C all have the same location in the Unicode plane as they do in every code-page. That means, an A in Latin has the same ASCII value as an A in Japanese which has the same value as a Unicode A. Therefore, no N is required in front of the string literal ‘ABC’.
In the second example, the simplified Chinese characters do not share the same ASCII value in the simplified Chinese code-page and the Unicode plane. Therefore, an N is required before the string literal so SQL Server knows that the string is a Unicode string and not a code-page string.
· What does “forcing Unicode” mean if I use Oracle?
o We are choosing not to support the national character set data types NCHAR and NVARCHAR. Instead, we will require a UTF-8 instance for Oracle users. None of your queries will have to change because everything will be UTF-8. If we were to use the national character set data types, Oracle users would have to modify all of their external queries (non-LDMS) as explained in the “What does “forcing Unicode” mean if I use SQL Server” above.
· Will I lose any data?
o No, if you are operating in a supported LDMS environment. If you have chosen to put Japanese and Chinese data in the same database, then whichever data isn’t consistent with the code-page of the DBMS server is already corrupted. Corrupted data in that sense will remain so until the new LDMS inventory scanner is distributed to that client and it reports UTF-8 data.
· How much work do I have to do to prepare for an LDMS Unicode release?
o We will require a new database container (database for SQL Server, instance for Oracle). We are not planning on doing an in-place upgrade of the database.
SQL Server users will need to create a new database on their DBMS server. We will copy all the data from the previous LDMS database into the new database while at the same time, converting the data to UTF-8.
Oracle users will need to create a new UTF-8 instance. If they are already running inside a UTF-8 instance, they will need to create a new schema. We will copy all the data from the old schema into the new schema and convert the data to UTF-8 during the copy process.
Once this conversion is finished, we will no longer need the old database, so you’re at liberty to remove it. What that really means is that at the time of installation/upgrade, you will need to twice the disk space available so we can “mirror” your database data.