MQSeries.net :: View topic - How to store XML msg into SQLServer 'ntext' datatype column?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to store XML msg into SQLServer 'ntext' datatype column?

How to store XML msg into SQLServer 'ntext' datatype column?

« View previous topic :: View next topic »

Author

Message

dev

Posted: Thu Apr 29, 2004 8:20 am Post subject: How to store XML msg into SQLServer 'ntext' datatype column?

Apprentice

Joined: 11 Oct 2001
Posts: 30

I have a DATABASE NODE, wanting to store complete XML message into SQL servers column names MSG (data type is ntext) under table TEST_MSG.

INSERT INTO Database.dbo.TEST_MSG (MSGType, MSG)
VALUES
(
'TEST',
Body
);
it sends NULL value of 'Body', I want to store it as 'UNICODE TEXT' into ntext type column.

Am I missing anything here? Do I refer complete XML msg as Body, is it correct?

klabran

Posted: Thu Apr 29, 2004 8:31 am Post subject:

Master

Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ

http://www.mqseries.net/phpBB2/viewtopic.php?t=15075

Although I am storing it as ASCII Text not unicode.... that's what the CCSID 437 is. unicode is 1200.

dev

Posted: Thu Apr 29, 2004 1:27 pm Post subject:

Apprentice

Joined: 11 Oct 2001
Posts: 30

Thanks! It worked!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to store XML msg into SQLServer 'ntext' datatype column?

Jump to:

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

Protected by Anti-Spam ACP