Monday, January 10, 2005

Free EMS PostgreSQL Manager working with Unicode

Finally got the EMS PostgreSQL Manager working with Unicode after several interactions with support, which is quite knowledgeable and helpful. One nuance with the product is it doesn't support Unicode fonts directly. You have to tell the client to use a non-Unicode encoding (in my case Big5) and the corresponding non-Unicode font (in my case a Big5 Chinese font from Arphic Technology) for the manager to display Unicode text correctly. See the following screenshots of how to make it work.
  1. Database Registration Info dialog
  2. Environment Options dialog
  3. Table view
For other languages, you can just use your own encoding and a corresponding font. Again, pgAdmin III doesn't have this problem. Unicode data in the database works out of box with Unicode fonts on the client.