Actualment a les nostres bases de dades no tenim activats els sets de caracters corresponents al nostre idioma (
charset=NONE collation=NONE) , aixo fa que hi hagin problemes a l'hora de buscar paraules amb accents i buscar textes amb majuscules i minuscules barrejades.
Per solucionar aquest problema s'hauria de crear nous dominis i asociar-los al camps que es fan servir per fer busquedes, modificant les propietats
charset a ISO8859_1 collation a ES_ES_CI_AI. El set de caracters ISO8859_1 correspon a les llengues llatines d'europa oest i la regla d'ordenacio ES_ES_CI_AI es la corresponent a l'idioma espanyol, s'ignora les majuscules i minuscules i els accents. Tambe es pot fer servir el set de caracters
WIN1252 i el collate
PXW_SPAN , pero es aconsellable fer servir la ISO8859_1 ja que es l'estandard i l'altre es una variant especial per windows.
Un cop canviats els dominis dels camps, s'ha de fer un backup i restore de la base de dades.
Amb aquesta modificació del domini, ja no cal fer les busquedes amb les dades previament convertides a majuscula, tal i com fa actualment la classe
_buscarcs.
Sets de caracters i regles d'ordenació
Set de caracters
|
Llenguatge |
Ordenació (Collations)
|
Comentaris |
Set de caracters generics
|
| NONE |
All |
NONE |
No character set applied. With this character set setting, Firebird is unable to perform conversion operations like UPPER() correctly on anything other than the standard 26 latin letters. |
| OCTETS | BINARY |
All |
OCTETS |
Same as NONE. Cannot be used as client connection character set. Space character is #x00. Will be displayed as hex in ISQL 2.0. |
| ASCII |
English |
ASCII |
English |
Sets de caracters Unicode
|
| UNICODE_FSS |
All |
UNICODE_FSS |
Unicode UTF-8. An old implementation that accepts malformed strings and does not enforce correct max. string length. All characters 3 bytes, no case mapping.
Superseded in Firebird 2.0 with the UTF8 character set. Deprecated.
|
| UTF8 |
All |
UCS_BASIC |
UCS_BASIC sorts in Unicode code-point order (Firebird 2.0) |
| UNICODE |
Sorts using the Unicode Collation Algorithm (UCA) (Firebird 2.0) |
| UTF-8 |
Case insensitive collation (Firebird 2.1) |
| UNICODE_CI_AI |
Case insentive, Accent insensitive collation for Unicode (Firebird 2.5) |
Sets de caracters Actuals
|
| ISO8859_1 |
Western Europe |
ISO8859_1 |
Latin-1 |
| DA_DA |
Danish/Danmark |
| DE_DE |
German/Germany |
| DU_NL |
Dutch/The Netherlands |
| EN_UK |
English/United Kingdom |
| EN_US |
English/USA |
| ES_ES |
Spanish/Spain |
| ES_ES_CI_AI |
Spanish/Spain, case insensitive, accent insensitive (Firebird 2.0) |
| FI_FI |
Finnish/Finnland |
| FR_CA |
French/Canada |
| FR_FR |
French/France |
| FR_FR_CI_AI |
French/France, case insensitive, accent insensitive (Firebird 2.1) |
| IS_IS |
Icelandic/Iceland |
| IT_IT |
Italian/Italy |
| NO_NO |
Norwegian/Norway |
| PT_PT |
Portuguese/Portugal |
| PT_BR |
Portuguese/Brasil (Firebird 2.0). Case+Accent insensitive |
| SV_SV |
Swedish/Sweden |
| ISO8859_2 |
Central Europe |
ISO8859_2 |
Central Europe |
| CS_CZ |
Czech |
| ISO_HUN |
Hungarian |
| ISO_PLK |
Polish (Firebird 2.0) |
| ISO8859_3 |
Southern Europe |
ISO8859_3 |
Maltese, Esperanto |
| ISO8859_4 |
North European |
ISO8859_4 |
Estonian, Latvian, Lithuanian, Greenlandic, Lappish |
| ISO8859_5 |
Cyrillic |
ISO8859_5 |
Russian, Ukrainian |
| ISO8859_6 |
Arabic |
ISO8859_6 |
|
| ISO8859_7 |
Modern Greek |
ISO8859_7 |
|
| ISO8859_8 |
Hebrew |
ISO8859_8 |
|
| ISO8859_9 |
Turkish |
ISO8859_9 |
|
| ISO8859_13 |
Baltic |
ISO8859_13 |
Baltic |
| LT_LT |
Lithuanian |
| WIN1250 |
Central Europe |
WIN1250 |
Central Europe |
| BS_BA |
Bosnian (Firebird 2.0) |
| WIN_CZ |
Czech, case-insensitive (Firebird 2.0) |
| WIN_CZ_CI_AI |
Czech, case-insensitive, accent-insensitive (Firebird 2.0) |
| PXW_CSY |
Czech |
| PXW_HUN |
Hungarian |
| PXW_HUNDC |
Hungarian, Dictionary sort |
| PXW_PLK |
Polish |
| PXW_SLOV |
Slovanian |
| WIN1251 |
Cyrillic |
WIN1251 |
Cyrillic |
| WIN1251_UA |
Ukrainian |
| PXW_CYRL |
Cyrillic, Paradox compatibility |
| WIN1252 |
Western Europe, America |
WIN1252 |
Latin-1 with Windows extensions |
| WIN_PTBR |
Brasilian Portuguese (Firebird 2.0). Case+Accent insensitive |
| PXW_INTL |
Paradox ANSI International |
| PXW_INTL850 |
Paradox Multi-Lingual Latin-1 |
| PXW_NORDAN4 |
Paradox Norwegian and Danish |
| PXW_SPAN |
Paradox Spanish |
| PXW_SWEDFIN |
Paradox Swedish, Finnish |
| WIN1253 |
Modern Greek |
WIN1253 |
|
| PXW_GREEK |
Paradox Greek |
| WIN1254 |
Turkish |
WIN1254 |
|
| PXW_TURK |
Paradox Turkish |
| WIN1255 |
Hebrew |
WIN1255 |
|
| WIN1256 |
Arabic |
WIN1256 |
|
| WIN1257 |
Baltic |
WIN1257 |
Baltic |
| WIN1257_LV |
Latvian dictionary collation (Firebird 2.0) |
| WIN1257_LT |
Lithuanian dictionary collation (Firebird 2.0) |
| WIN1257_EE |
Estonian dictionary collation (Firebird 2.0) |
| WIN1258 |
Vietnamese |
|
Vietnamese (Firebird 2.0) |
| Compatbilitat amb MS-DOS, dBASE i Paradox |
| DOS437 |
Western Europe, America |
DOS437 |
English/USA |
| DB_DEU437 |
dBASE German |
| DB_ESP437 |
dBASE Spanish |
| DB_FIN437 |
dBASE Finnish |
| DB_FRA437 |
dBASE French |
| DB_ITA437 |
dBASE Italian |
| DB_NLD437 |
dBASE Dutch |
| DB_SVE437 |
dBASE Swedisch |
| DB_UK437 |
dBASE English/UK |
| DB_US437 |
dBASE English/US |
| PDOX_ASCII |
Paradox ASCII code page |
| PDOX_INTL |
Paradox International English code page |
| PDOX_SWEDFIN |
Paradox Swedish/Finnish code page |
| DOS737 |
Greek |
DOS737 |
Greek |
| DOS775 |
Baltic |
DOS775 |
Baltic |
| DOS850 |
Western Europe, America |
DOS850 |
Latin-1 (without Euro € symbol) |
| DB_DEU850 |
dBASE German |
| DB_ESP850 |
dBASE Spanish |
| DB_FRA850 |
dBASE French/France |
| DB_FRC850 |
dBASE French/Canada |
| DB_ITA850 |
dBASE Italian |
| DB_NLD850 |
dBASE Dutch |
| DB_PTB850 |
dBASE Portuguese/Brasil |
| DB_SVE850 |
dBASE Swedish |
| DB_UK850 |
dBASE English/UK |
| DB_US850 |
dBASE English/USA |
| DOS852 |
Central Europe |
DOS852 |
Latin-2 (Central Europe) |
| DB_CSY |
dBASE Czech |
| DB_PLK |
dBASE Polish |
| DB_SLO |
dBASE Slovakian |
| PDOX_CSY |
Paradox Czech |
| PDOX_HUN |
Paradox Hungarian |
| PDOX_PLK |
Paradox Polish |
| PDOX_SLO |
Paradox Slovakian |
| DOS857 |
Turkish |
DOS857 |
Turkish |
| DB_TRK |
dBASE Turkish |
| DOS858 |
|
DOS858 |
Latin-1 plus Euro symbol € |
| DOS860 |
Portuguese |
DOS860 |
Portuguese |
| DB_PTG860 |
dBASE Portuguese |
| DOS861 |
Icelandic |
DOS861 |
Icelandic |
| PDOX_ISL |
Paradox Icelandic |
| DOS862 |
Hebrew |
DOS862 |
Hebrew |
| DOS863 |
Canadian French |
DOS863 |
French/Canada |
| DB_FRC863 |
dBASE French/Canada |
| DOS864 |
Arabic |
DOS864 |
Arabic |
| DOS865 |
Scandinavian |
DOS865 |
Nordic |
| DB_NOR865 |
dBASE Norwegian |
| DB_DAN865 |
dBASE Danish |
| PDOX_NORDAN4 |
Paradox Norwegian |
| DOS866 |
Russian |
DOS866 |
Russian |
| DOS869 |
Greek |
DOS869 |
Modern Greek |
Altres, Asiatics i Baltics
|
| BIG_5 |
Chinese |
BIG_5 |
Chinese |
| KOI8R |
Russian |
|
Russian character set and dictionary collation (Firebird 2.0) |
| KOI8U |
Ukrainian |
|
Ukrainian character set and dictionary collation (Firebird 2.0) |
| CYRL |
Russian/Ukrainian |
CYRL |
Cyrillic |
| DB_RUS |
dBASE Russian |
| PDOX_CYRL |
Paradox Cyrillic |
| KSC_5601 |
Korean |
KSC_5601 |
Unified Korean Hangeul, also known as windows-949 |
| KSC_DICTIONARY |
Korean dictionary ordering |
| NEXT |
NeXT Computers |
NEXT |
NeXTSTEP encoding |
| NXT_DEU |
German |
| NXT_ESP |
Spanish |
| NXT_FRA |
French |
| NXT_ITA |
Italian |
| NXT_US |
US-English |
| SJIS_0208 |
Japanese |
SJIS_0208 |
Shift-JIS |
| EUCJ_0208 |
Japanese |
EUCJ_0208 |
EUC Japanese |
| GB_2312 |
Chinese |
GB_2312 |
Simplified Chinese (HongKong, PRC), a subset of GBK/windows-936 |
| CP943C |
Japanese |
CP943C_UNICODE |
Japanese character set (Firebird 2.1) |
| TIS620 |
Thai |
TIS620_UNICODE |
Thai character set, single byte (Firebird 2.1) |
