|
|
| Line 1: |
Line 1: |
| ==New Unicode Upgrade Steps (applicable to SQL Accounting version 739 and above)==
| |
| Before start upgrade, please make sure all the database must <big>'''BACKUP'''</big>.
| |
| :1. '''Uninstall''' the previous Firebird and SQL Financial Accounting version 4.
| |
| :2. '''Install''' the SQL Financial Accounting version 5 (version 739 and above).
| |
| :3. Execute the SQL Financial Accounting version 5.
| |
| :4. At the logon screen, click on (...) button.
| |
| ::[[File:Core-Unicode_41.jpg]]
| |
| <br />
| |
| :5. Click on '''Back to Database Group'''.
| |
| ::[[File:Core-Unicode_42.jpg]]
| |
| <br />
| |
| :6. Right click on the DCF Group and select '''Properties...'''.
| |
| ::[[File:Core-Unicode_43.jpg]]
| |
| <br />
| |
| :7. For upgrade database purpose, it is compulsory to change from '''Firebird Server''' to '''Firebird Standalone Database'''.
| |
| ::[[File:Core-Unicode_44.jpg]]
| |
| <br />
| |
|
| |
|
| '''Tips: '''
| |
| Upgrade database using Firebird Standalone Database setting. You are allow to upgrade the database directly.
| |
|
| |
| :8. Login the database.
| |
| ::[[File:Core-Unicode_45.jpg]]
| |
| <br />
| |
|
| |
| :9. Click on '''Yes''' to confirm proceed the database upgrade.
| |
| ::[[File:Core-Unicode_46.jpg]]
| |
| <br />
| |
| :10. Choose an appropriate encoding. Select '''Default - Windows 1252 ANSI''' if your server current language for non-Unicode programs is "English (United States)".
| |
| ::[[File:Core-Unicode_02.jpg]]
| |
| <br />
| |
| :11. For more info about choosing a correct encoding, see the check list table below.
| |
| ::{| class="wikitable"
| |
| |-
| |
| ! 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 to use). For '''Firebird programmer''' use.
| |
| |-
| |
| | 5. || Database Encoding Diagnosis (For Chinese only || To analyse the encoding (for Chinese character) able to read by your eyes.
| |
| |}
| |
| <br />
| |
| :12. Transliterate to Unicode sample list out.
| |
| ::[[File:Core-Unicode_04.jpg]]
| |
| <br />
| |
| :13. Click on '''Yes''' to proceed upgrade if you are confirm the characters are meaningful to read.
| |
| ::[[File:Core-Unicode_05.jpg]]
| |
| <br />
| |
|
| |
| '''Note:'''
| |
| If you have click on '''No''', you will get prompt an '''operation aborted'''. Press '''Ok''' to exit the message.
| |
| [[File:Core-Unicode_06.jpg]]
| |
|
| |
| :14. Upgrade database continue... (estimate upgrade duration : 15 -30 mins per database)
| |
| ::[[File:Core-Unicode_47.jpg]]
| |
| <br />
| |
| :15. Database upgrade successfully, '''Old Database''' link will be '''DROP''' and '''New Database''' link will be '''ADD''' (new database file created automatically).
| |
| ::[[File:Core-Unicode_48.jpg]]
| |
| <br />
| |
|
| |
| '''Example:'''
| |
| OLD database filename: ACC-0001.FDB (DROP)
| |
| NEW database filename: ACC-0002.FDB (ADD)
| |
| <br />
| |
| At the new database file (ACC-0002), you will see a remark displayed as '''Unicode from ACC-0001'''.
| |
| <br />
| |
|
| |
| :16. For '''Standalone''' users, you can login the database and use it.
| |
| ::[[File:Core-Unicode_45.jpg]]
| |
| <br />
| |
|
| |
| :17. For '''Network''' users only, you are required to '''install''' the Firebird 3.0.1. Click [[Firebird_3.0.1_Installation|here]] to get Firebird 3.0.1 installation guide.
| |
|
| |
| :18. Go back to DCF Group properties. Change the database engine to '''Firebird Server''' and click on '''Test Connection''' (Server Version: WI-V3.0.1.32609 Firebird 3.0).
| |
| ::[[File:Core-Unicode_50.jpg]]
| |
| <br />
| |
