Unicode Database Upgrade (SQL Financial Accounting 5): Difference between revisions

From eStream Software
No edit summary
Line 11: Line 11:
::5.3 Click on '''Administrative''' tab. Check the Language for non-Unicode programs, eg. English (United States) or Chinese (Simplified, China).
::5.3 Click on '''Administrative''' tab. Check the Language for non-Unicode programs, eg. English (United States) or Chinese (Simplified, China).
::[[File:Core-Unicode_15.jpg]]
::[[File:Core-Unicode_15.jpg]]
<br />
Note:
Please ask the user the following questions:
1.'''"Do you key-in any Chinese characters in the database?"'''.
2. What type of language input using?
<br />
<br />
:6. Check Local C drive free spaces. Recommended '''25GB free space or more'''.
:6. Check Local C drive free spaces. Recommended '''25GB free space or more'''.

Revision as of 01:40, 5 November 2016

To Do List

1. Backup all the databases.
2. Remove/Uninstall the previous Firebird version installed, ie. 1.5, 2.0, 2.5.
3. Install Firebird 3.0.
4. SQL Financial Accounting 5 (Version: 5.2016.790.737).
5. Check the System Locale in Regional setting.
5.1 Go to Control Panel.
5.2 Look for Regional setting. See screenshot below.
Core-Unicode 14.jpg


5.3 Click on Administrative tab. Check the Language for non-Unicode programs, eg. English (United States) or Chinese (Simplified, China).
Core-Unicode 15.jpg


Note:
Please ask the user the following questions:
1."Do you key-in any Chinese characters in the database?". 
2. What type of language input using? 


6. Check Local C drive free spaces. Recommended 25GB free space or more.


Unicode Database Upgrade

1. Execute the SQL Financial Accounting 5 (Version: 5.2016.790.737).
2. Restore the database from the backup file.
3. Login the database restored.
4. Click on Yes to confirm proceed the database upgrade.
Core-Unicode 01.jpg


5. Choose an appropriate encoding. Select Default - Windows 1252 ANSI if your server current language for non-Unicode programs is "English (United States)".
Core-Unicode 02.jpg


6. For more info about choosing a correct encoding, see the check list table below.
No. SQL encoding Regional setting (non-Unicode language)
1. Defaul-Windows 1252 ANSI All English, ie. English (United Kingdom), English (Malaysia), English (Singapore), etc.
2. Simplified Chinese 简体中文 Chinese Simplified ONLY, ie. Chinese (Simplified, China), Chinese (Simplified, Singapore)
3. Traditional Chinese 繁体中文 Chinese Traditional ONLY, ie. Chinese (Traditional, Hong Kong SAR), Chinese (Traditional, Taiwan)
4. Firebird NONE character set NONE encoding (Not recommended)
5. Database Encoding Diagnosis (For Chinese only To analyse the encoding (for Chinese character) able to read by your eyes.



Unicode Database Features

See also