Software Localization Using Firebird
Character Sets
String fields should have the correct Character Set and Collation. The following shows a list of commonly used settings for some languages:
| Language | Character Set | Collation |
|---|---|---|
| Western European | WIN1252 | WIN1252 |
| Korean | KSC_5601 | KSC_5601 |
| Russian | WIN1251 | WIN1251 |
| Turkish | WIN1254 | WIN1254 |
To change the Character Set and Collation, use IBExpert to edit fields:
- Open database
- Open table to modify.
- View field list.
- Edit required field (usually a string field, such as VARCHAR). Right-click, Edit Field, then Edit Domain.
- Change the Character Set and Collate fields to what is required.
- Save and commit changes.
For Firebird to find the appropriate character set and collation, make sure the subfolder intl contains files fbintl.conf and fbintl.dll. This subfolder must exist under the application's folder.