Unicode characters from DB2 using JDBC in ColdFusion MX7

[lapikov]

JDBC driver from ColdFusion MX 7 does not return Unicode characters to me. I
create data sources for one Unicode DB2 7.2 database -- one for direct DB2
driver, second for ODBC socket driver. Using simple SQL I try to return data in
Unicode. First datasource returns correct data (in Unicode). Second returns
just substitution symbol for current locale. What is the problem with JDBC
driver for DB2 concerned with Unicode?

[PaulH]

not sure which dsn is which BUT you shouldn't be using ODBC drivers to return unicode data.

[lapikov]

Why ODBC socket data sources should not be used to work with Unicode data?

[PaulH]

the JDBC-ODBC bridge didn't handle them very well in the past. why do you want to use the JDBC-ODBC bridge?

[sdupre]

You *could* probably get this to work with ODBC Server using the Sequelink
Unicode server.

The installations of CF6.1 and 7.0 contain the NON-unicode server.
(swsoc.exe). The unicode server is swsocw.exe and is included in the
/db/slserver54/bin directory but it's not hookup up.

Creating a separate Sequelink Unicode ODBC Server service as part of the
installer is a messy proposition and it's something we decided not to do.

Adding the server by hand is worse and you end up with a not very robust
solution compared to JDBC.

You're much better off with the JDBC driver.

Stephen Dupre
Macromedia QA

[lapikov]

There are two reasons:
1) we have fully functional application for CF5.0 with number of CFX-s, that
use ODBC from CPP (ColdFusion part of application also uses ODBC data sources
of CF5.0)
2) some queries do not work under DB2 Native Data Source -- we have error
"[Macromedia][DB2 JDBC Driver][DB2]UNACCEPTABLE SQL STATEMENT".
So the problem is these strange errors while executing queries from CFML.