Special Characters for Receiver JDBC Adapter

[Former Member]

Hi,

Our Scenario is Proxy -PI-JDBC (SQLServer ). We have special characters in the payload and we are abel to see the special characters in PI.According to JDBC Faq we used haquot attribute and concatenated with Prefix N'<Value>'. But still when the data is posted in the database we cannot see the special characters.

Please let me know your inputs.

Thanks,

Sainath

[prateek]

I hope you are following it exactly as per my blog.

/people/prateek.srivastava3/blog/2009/04/02/unicode-handling-for-ms-sql-server

Regards,

Prateek

[Former Member]

Hi

Have you checked if your Database, Table and Field code pages are correctly defined as to support the special charactes and if it is the same code page as the source message?

-Sam.

[Former Member]

What are the special characters you are using... Usually DB queries the escape sequence for special chars is '(apostrophe)...Try to use this escape sequence before ur special chars...

regards,

Arvind R

[Former Member]

yes, we used apostrophe..but still its not inserting special characters into database...

[Former Member]

Reference following thread, add a attribute of "hasQuot", map constant "No" to it, to see solve your problem or not:

Regards.

Liang