I successfully installed and used ibm ODBC driver for Linux and Windows.
I'm reading a DB2 database through ODBC, but I got a problem with the ODBC Linux version:
if I try to do:
select anyField from anyTable
all things work fine; but the fields in my tables have the character "§" in it, such as the field N§COAR.
In these cases I can't read the specific field, example:
select N§COAR from atable
returns a "ISQLERROR: Could not SQLPrepare" from iSQL client.
This problem is not present in the Win32 version of the ODBC driver, all works fine.
How can I solve this?
Thanks for the attention.
Pinned topic ODBC Unix driver: I can't select fields with § character
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2008-02-24T08:19:34Z at 2008-02-24T08:19:34Z by SystemAdmin
Re: ODBC Unix driver: I can't select fields with § character2008-02-24T01:45:50ZThis is the accepted answer. This is the accepted answer.Hello Cyguard,
It is likely that you are hitting a known bug and that is now fixed and about to be shipped in the next month.
Some work-arounds to try:
1. iSQL is known to not handle locales well. Try using something else.
2. If you are using a .utf8 locale try changing to a non-utf8 one. By utf8 locale I mean en_US.utf8 or fr_FR.utf8, those should be changed to en_US and 3. fr_FR, the next version of the driver will address this issue.
4. If the problem is present in php scripts or other programs, try using prepared statements instead of direct SQL execution.
If you need more help, let me know.
Re: ODBC Unix driver: I can't select fields with § character2008-02-24T08:19:34ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
thank you for your reply.
I will try to use prepared statements in my code (both php and C library); I will stay tuned for next releases.