| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| PASSTHRU MS SQL - charset conversion? |
« View previous topic :: View next topic » |
| Author |
Message
|
| catshout |
 Posted: Mon Feb 13, 2017 9:28 am Post subject: PASSTHRU MS SQL - charset conversion? |
 |
|
Acolyte
Joined: 15 May 2012
Posts: 57
|
Dear community,
we're trying to fire a PASSTHRU statement to MS SQL Server 2008 with "Latin1_General_CI_AS" collation.
See below the statement
| Code: |
| SELECT DISTINCT company.id,company.city,company.federalState,company.lat,company.lon,company.name,company.postalcode,company.street,company.DELETED FROM company WHERE company.DELETED = 'N' AND company.name = 'Hüsenbüsen2' |
In this case nothing has been returned.
An other PASSTHRU on the same table works properly, as long as there no special chars in there.
Find below also my ODBC.INI
| Code: |
[CASMDM_BVSLEADAPP]
Driver=/opt/ibm/iib-10.0.0.6/server/ODBC/drivers/lib/UKsqls95.so
Description=DataDirect 7.1 SQL Server Wire Protocol
Database=CASMDM_BVSLEADAPP_DEVE
HostName=zrd-sw-cl-sql3.zeppelin.corp
PortNumber=1433
AnsiNPW=1
LoginTimeout=0
QueryTimeout=0
;# AuthenticationMethod=4
;# GSSClient=libgssapi_krb5.so.2
...
[ODBC]
InstallDir=/opt/ibm/iib-10.0.0.6/server/ODBC
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8 |
I've done some research, CCSID conversion as well, did nothing found and nothing helps.
Could anyone give me a hint, where I can set the correct charset before executing the PASSTHRU statement?
Many thanks in advance.
- Gerald |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
