| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem with special characters with Broker 6.0 and SQL SRV |
« View previous topic :: View next topic » |
| Author |
Message
|
| brokerman111 |
 Posted: Mon May 18, 2009 11:08 pm Post subject: Problem with special characters with Broker 6.0 and SQL SRV |
 |
|
Newbie
Joined: 18 May 2009
Posts: 3
|
Hi,
I have one xml file which is read in a flow. The data in this xml file contains some special characters like äåö. I insert the data from xml into database table.
This works perfectly when my application DB is Oracle, DB2 or MySQL. When I try to insert the data into SQL Server 2005 Express the special characters are total carbage.
If I do the insert from SQL Server Management Studio, everything works fine.
The original xml test file is done with Notepad. I write the xml file with rfhutil into MQ queue. I have tried to change the MQMD.Codepage in Rfhutil into many different values but no success so far.
I have Linux OS (Broker runs on this), Broker v6.0.0.3 and DB2 v8.1 as Broker database. The application test DB (SQL Server 2005 Express) runs on Windows XP. SQL Express server collation is SQL_Latin1_General_CP1_CI_AS. The table columns are defined as varchar and I have also tried with nvarchar data type.
This is the section from the .odbc.ini
| Code: |
[TESTDSN]
Driver=/opt/ibm/mqsi/6.0/merant/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=xx.xx.xx.xx,1433
Database=TEST
AnsiNPW=Yes
QuotedId=No
|
Below is the esql code which is used to test this issue:
| Code: |
SET ss = 'INSERT INTO Table_1 (a1, a2) VALUES(';
SET ss = ss || '''' || InputRoot.XMLNSC.msg.a1 || ''',';
SET ss = ss || '''' || InputRoot.XMLNSC.msg.a1 || ''')';
PASSTHRU (ss);
|
The result of the code above is that special characters are not correct in the table (other characters are ok).
I have also tried with this syntax below which works ok with Oracle, DB2 and MySQL (questionmark parameter pattern).
| Code: |
SET ff = InputRoot.XMLNSC.msg.a1;
SET ss = 'INSERT INTO Table_1 (a1) VALUES(?)';
PASSTHRU (ss, ff);
|
The result of code above is that none of the characters are not correct in the table.
Has someone else encountered this kind of situation? Can this be a driver problem? If someone has good hints for this issue, I would be very happy to hear of them.
Thanks,
BR,
--
P.V. |
|
| Back to top |
|
 |
| vikas.bhu |
| Posted: Tue May 19, 2009 12:34 am Post subject: |
|
|
Disciple
Joined: 17 May 2009
Posts: 159
|
better u post the error u are getting..
it would help |
|
| Back to top |
|
|
| brokerman111 |
| Posted: Tue May 19, 2009 1:02 am Post subject: |
|
|
Newbie
Joined: 18 May 2009
Posts: 3
|
Hi,
I don't receive any errors. Flow works as it should, but special characters are not correct in DB.
BR,
--
P.V. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue May 19, 2009 4:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
What is the National Language values that are set in the shell environment of the broker service user on linux?
Have you considered updating to a newer FP level of MB v6? Maybe this is an issue with the SQL ODBC driver and is fixed in a later release. |
|
| 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
|
|
|
|
