Search  
   
Browse by Category
Marketcircle KB .: Daylite 3.x .: Database .: How do I store Japanese characters in the database?

How do I store Japanese characters in the database?

The default database encoding is ISO Latin 1, you have to change it to ShiftJIS Japanese. You do it with the following steps:

Note: Backup your database before you make these changes. Thereby, you will have a copy that you can get back to if you don't like the changes.

  • Launch OpenBase Manager (in /Applications/OpenBase/)
  • Click on the 'Local' on the left side of the window
  • Select your database
  • Stop it using the 'Action' menu
  • Using the 'Action', select 'Configure Database'
  • Go to the 'Localization' tab
  • Change the database encoding to 'SHIFTJIS JAPANESE' (you can also try UNICODE UTF 8)
  • Close the window and save the changes
  • Restart the Database

WARNINGS
  • If you change the database encoding, each new entry will take double the space
  • Existing content will remain in the old encoding
  • If you use Unicode or ShiftJIS, then change back to ISO Latin 1, then any content stored in the Unicode or ShiftJIS will be garbled
  • We have not specifically tested SHIFTJIS (we don't know Japanese)
  • Some areas of the application are not double-byte safe. Specifically, the Envelopes, Labels, Summary Tab and Letters (you have to wrap the merge keys in the correct font)
We haven't targeted the Japanese (or any double-byte language) market because of these issues. We hope to overcome these issues in the future. While it is possible to use DayLite in those environments (and some customers are using it), we cannot guarantee the results at this time.

How helpful was this article to you?

Related Articles