Subject | RE: [IBO] Problem with codepage 28591 and TIB_Memo |
---|---|
Author | IBO Support List |
Post date | 2013-04-09T19:42:13Z |
Would it help if I made it so that you had a hook to customize this at the TIB_Connection level?
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Thomas Lenders
Sent: Tuesday, April 9, 2013 9:20 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Problem with codepage 28591 and TIB_Memo
Hello group,
I have run into a problem with saving/loading some special characters like € etc. from BLOB fields.
Some more infos:
- The database / table have been defined with charset ISO8859_1
- That charset has also been defined in the (only) connection of the application
- When entering € 99 into a TIB_Memo connected to a BLOB (subtype 1) database field and posting, it will display as ? 99
- Entering the same € 99 into a TIB_Edit connected to the same database field works fine
I seem to have tracked down the problem to the function GetCodePageFromCharID() in IB_Utils which maps the charset ISO8859_1 to the codepage 28591.
For some reason this function is being called when posting from a TIB_Memo but not when posting from TIB_Edit. Changing the assignment to CP 1252 fixes the immediate problem.
Can someone shed some light on what’s going on there? Also, is there a way to change the codepage without hacking into IB_Utils.pas ?
Did anyone run into a similar situation? Looking forward to any ideas you guys have. ☺
Regards,
Thomas
[Non-text portions of this message have been removed]
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Thomas Lenders
Sent: Tuesday, April 9, 2013 9:20 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Problem with codepage 28591 and TIB_Memo
Hello group,
I have run into a problem with saving/loading some special characters like € etc. from BLOB fields.
Some more infos:
- The database / table have been defined with charset ISO8859_1
- That charset has also been defined in the (only) connection of the application
- When entering € 99 into a TIB_Memo connected to a BLOB (subtype 1) database field and posting, it will display as ? 99
- Entering the same € 99 into a TIB_Edit connected to the same database field works fine
I seem to have tracked down the problem to the function GetCodePageFromCharID() in IB_Utils which maps the charset ISO8859_1 to the codepage 28591.
For some reason this function is being called when posting from a TIB_Memo but not when posting from TIB_Edit. Changing the assignment to CP 1252 fixes the immediate problem.
Can someone shed some light on what’s going on there? Also, is there a way to change the codepage without hacking into IB_Utils.pas ?
Did anyone run into a similar situation? Looking forward to any ideas you guys have. ☺
Regards,
Thomas
[Non-text portions of this message have been removed]
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links