| Subject | Filter non ISO8859_1 characters |
|---|---|
| Author | nols_smit |
| Post date | 2011-04-18T13:36:32Z |
Hi,
I have a FireBird 2.5 database, created to use the ISO8859_1 character set. On a monthly interval, I re-create a new empty database (except for a few lookup tables) by restoring a backup, dump data from an Oracle database and load the mentioned empty database. I then do some indexing using Href Tools Corp. Rubicon indexing components (the same one used on http://www.codenewsfast.com). My web application is http://196.33.85.17/sageolit
It now seems that non ISO8859_1 characters are slipping thru and they are causing problems during the Rubicon indexing.
Does anyone know how can I filter out any non ISO8859_1 characters during the load process? I'm using Delphi7 and the UniDac database drivers.
Regards,
Nols Smit
I have a FireBird 2.5 database, created to use the ISO8859_1 character set. On a monthly interval, I re-create a new empty database (except for a few lookup tables) by restoring a backup, dump data from an Oracle database and load the mentioned empty database. I then do some indexing using Href Tools Corp. Rubicon indexing components (the same one used on http://www.codenewsfast.com). My web application is http://196.33.85.17/sageolit
It now seems that non ISO8859_1 characters are slipping thru and they are causing problems during the Rubicon indexing.
Does anyone know how can I filter out any non ISO8859_1 characters during the load process? I'm using Delphi7 and the UniDac database drivers.
Regards,
Nols Smit