Adding Unicode to Print Release tables

  1. From your computer, update the Print Release tables. For example, %ProgramFiles%\Lexmark\Solutions\lpm\ms-sql-script\migrate-ascii-column-data-to-unicode.sql.
    Notes:
    • Errors for the MP_PRINTERS table may occur when the table does not exist. If you are not using Email Watcher with Printer Nicknames, then comment out its lines in the script.
    • When you use Print Release version 2.3.15 or later, errors for the dbo.SCHEMA_ELEMENTS table may occur when running the script on Print Release version 2.3.14. If you are using Print Release version 2.3.14, then comment out its lines in the script.
  2. From Management Studio, connect to the database server as a database owner.
  3. Right‑click the Print Release database, and then click New Query.
  4. In the new query window, paste the contents of the migrate-ascii-column-data-to-unicode.sql file.
  5. Make sure that the Print Release database is selected, and then click Execute.

The varchar datatype is now updated to nvarchar in all Print Release tables, such as PR_JOBS.