Topic
2 replies Latest Post - ‏2008-02-24T08:19:34Z by SystemAdmin
SystemAdmin
SystemAdmin
262 Posts
ACCEPTED ANSWER

Pinned topic ODBC Unix driver: I can't select fields with § character

‏2008-02-12T15:05:10Z |
Hi,
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.
Updated on 2008-02-24T08:19:34Z at 2008-02-24T08:19:34Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    262 Posts
    ACCEPTED ANSWER

    Re: ODBC Unix driver: I can't select fields with § character

    ‏2008-02-24T01:45:50Z  in response to SystemAdmin
    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.

    Moisés Silva
    • SystemAdmin
      SystemAdmin
      262 Posts
      ACCEPTED ANSWER

      Re: ODBC Unix driver: I can't select fields with § character

      ‏2008-02-24T08:19:34Z  in response to SystemAdmin
      Hi Moisès,
      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.

      Bye