| Subject | Firebird 2.1, Unicode and external table |
|---|---|
| Author | cariad_ilmara |
| Post date | 2009-04-22T12:46:04Z |
Hello,
I'm trying to import some data (only numeric fields) into Firebird through an external table (written outside the scope of the FB server).
I keep getting a -802 error, and after much trial and error it seems to be because the DB charset is set to UTF-8 and it insist on reading 2 bytes by character.
My questions are :
- Is there a way to specify a different encoding for external table/file ?
- If not, is it possible to import data from an unicode (but not UCS-2) file from a UTF-8 DB ?
I'm trying to import some data (only numeric fields) into Firebird through an external table (written outside the scope of the FB server).
I keep getting a -802 error, and after much trial and error it seems to be because the DB charset is set to UTF-8 and it insist on reading 2 bytes by character.
My questions are :
- Is there a way to specify a different encoding for external table/file ?
- If not, is it possible to import data from an unicode (but not UCS-2) file from a UTF-8 DB ?