Subject | Re: [IBO] Collate problems |
---|---|
Author | Helen Borrie |
Post date | 2003-07-10T11:22:04Z |
At 11:03 AM 10/07/2003 +0200, you wrote:
IB_SQL? (combobox on the Connection page). If not, then IB_SQL will be
storing your strings in charset NONE, so the Swedish characters won't give
you transliteration errors until you try to access them, or the system
tries to perform a collation on them.
Otherwise - I have no idea...
Helen
>This could explain our problems, but what puzzles me is that thisErrm - do you set the correct client character set when connecting via
>error message does not appear if inserting through IB_SQL (i.e. inserting
>Swedish characters on a field defined with Norwegian collation is allowed
>using IB_SQL, but not using a TIB_DSQL).
IB_SQL? (combobox on the Connection page). If not, then IB_SQL will be
storing your strings in charset NONE, so the Swedish characters won't give
you transliteration errors until you try to access them, or the system
tries to perform a collation on them.
Otherwise - I have no idea...
Helen