ODBC issue

Question

Question

sansa stark · Nov 10, 2016

Hi All,

We are accessing the InterSystems`s cache database via UNIX ODBC and displaying the data in PHP website . Recently we have upgraded the PHP version to 5.6. We are getting the nondisplayable characters (�) for only strings. But the numbers and date fields are displaying correctly.

While querying the database via ISQL everything working fine (No Special characters).

I have looked around the internet and found the PHP 5.6 changed the default character to UTF-8.

For this issue anything, we can do from cache side.

cache version :

Cache for Windows (x86-32) 2016.1 (Build 656) Fri Mar 11 2016 17:59:39 EST

but we try both 8-bit and unicode cache.

Thanks,

Sansa.

Discussion (3)1

Log in or sign up to continue

Sean Klingensmith · Nov 10, 2016

Hwllo Sansa,

Which version of the ODBC driver are you using? Caché ships with Unicode and 8-bit versions of the ODBC Drivers:

8-Bit:

libcacheodbcu.so

libcacheodbcu35.so

Unicode:

libcacheodbcuw.so

libcacheodbcuw35.so

The 35 files are for the drivers that support ODBC 3.5. Can you make sure that you are using a Unicode build of the driver?

1 0

score 0 · Answer 1 · 2016-11-10T10:00:34-05:00

Caché ODBC driver should recognize the client charset (if correctly sent by client) and use corresponding translation table.

To investigate your issue it would need more details, e.g. produce the ODBC log to see what data is sent by client and server. I would recommend to log it to WRC.

score 0 · Answer 2 · 2016-11-10T10:21:07-05:00

sansa stark · Nov 10, 2016

@Sean Klingensmith Thanks, It helped a lot

0 0