Re: sendStringParameterAsUnicode: How to insert unicode data corre

SAP Solution:
After checking with Microsoft it turns out that transmitting Unicode
data to a Microsoft SQL Server database via the JDBC Adapter is not
possible out of the box. There is, however, a workaround, which
requires a change in the data format sent to the JDBC Receiver channel.

In the XML sent to the channel you will have to use a special quoting
for any Unicode strings, which the JDBC Adapter will not produce on its
own. Instead, you need to add an attribute 'hasQuot="no"' to those
elements (most likely in the mapping where you produce the XML) and
explicitly enclose the data in single quotes prefixed with the letter N.
For clarity, one example:

If your original "INSERT" operation looks like this:

<StatementName2>
<dbTableName action="INSERT">
<table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
</dbTableName>
</StatementName2>

and "col1" contains Unicode data, change the document as follows:

<StatementName2>
<dbTableName action="INSERT">
<table>realDbTableName</table>
<access>
<col1 hasQuot="no">N'val1'</col1>
<col2>val2</col2>
</access>
</dbTableName>
</StatementName2>
Regards
Kgs



"kgs" wrote:

Hi

yes we are also in the same process. If you get any response pls update me.

Thanks
kgs

"Sriram" wrote:

Hi,

Nothing so far. We have contacted SAP and Microsoft.

We undertook an exercise with another integration tool called "BODI" from
Business Objects and that worked fine. The reason as per our analysis is that
BODI allows a setting for UTF 16, whereas SAP PI does not.

We are writing a Java routine to force the code page to "UTF 16" in XI.

If that works or when I hear from the vendors, I will post the solution.

Regards,
Sriram.

"kgs" wrote:

hi sriram,

we are also facing the same problem, when we are trying to insert Korean
chararter into SQL 2005 data base. Did you get any solution for this. If yes
kindly share any thing u have.

thanks


"Joe Weinstein" wrote:



Sriram wrote:

Thanks for the explanation. I am having trouble with unicode data in SQL
Server 2005.

We are using SAP XI and connecting it to SQL Server 2005 using JDBC. Unicode
data is received into SQL server as “????”.

The destination columns are nvarchar and store unicode data correctly.
External updates from Excel/text files are being processed correctly.

Additionally. the information is stored and dispalyed in SAP XI correctly.

Can you let me know what other settings are to be checked and corrected.

Regards,
Sriram.


I would say that whatever you are using to display the data that is
showing "?????" is unable to display the characters you have. The
data itself may well be exactly correct as inserted and retrieved.
This may just be that the JVM you are using does not have it's
charset/locale defined to print your characters, so whatever the
character is, if it's not known, the JVM prints '?'.




"Joe Weinstein" wrote:



sm wrote:


When inserting unicode data, we would like to programmatically override the
setting and send the data encoded in unicode(UTF-16), instead of defaulting
the whole app to unicode=true and take a performance hit.


Configuration: MS SQL server 2005 SP2, and MS jdbc driver version: 1.1
The sendStringParameterAsUnicode has been set to false for performance
reasons.
Any suggestions? We have tried the cast(? as nvarchar) function, but that
did not help.

Sample code/output:
String text = "\u0143\u0144";
sendStringParametersAsUnicode=false
insert into unitable (_ntext) values (?)
Inserting into databse:
143 144 (printed hex values)
Read from database:
3f 3f (printed hex values)

Thanks,
sm.

Hi. Your choices are only two:

1 - the default (sendStringParameterAsUnicode=true). This
means the driver will send Java strings as 16-bit characters.
This is the default because Java characters are 16-bit, and
no driver would presume to automatically mutate your data.

2 - sendStringParameterAsUnicode=false. This means the driver
will send Java strings as 8-bit characters, *silently truncating
any high-byte content before sending*. That's why you saw what
you saw.

You want/need the first if your strings have chars with any
non-zero high-order bytes.

There is no performance issue to speak of in the *sending*
of data. The main issue is whether the DBMS will use the
table indexes when searching with the sent data as search
criteria. If data is sent as 16-bit, it will use any NVARCHAR
indexes, but not VARCHAR indexes. If it is sent as 8-bit, it
will use VARCHAR indexes, but not NVARCHAR.
So as long as you make sure you send the data as you need,
you're OK. If you send as 16-bit to compare to VARCHAR columns,
the DBMS will skip indexes and do table scans. That is where
the pain comes in.

Joe Weinstein at BEA Systems




.

Relevant Pages

  • RE: BUG: JDBC connection disconnected, cant reconnect
    ... we've replaced the MS JDBC driver with jTDS JDBC driver, ... There is really nothing the driver can do that will take down SQL Server. ... Our problem is that the JDBC connection running on the localhost ... and then we can't reconnect to the database ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: SQL Server SP3a via JDBC SP2
    ... | Subject: RE: SQL Server SP3a via JDBC SP2 ... | Content-Type: text/plain; ... | Carb Simien, thanks for your reply, but the query ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... under its SAP financial system: ... A tad out-of-date on that one, they migrated to the beta of SQL Server 2005 ... Microsoft began running its SAP R/3 environment on ...
    (comp.databases.oracle.server)
  • RE: Installing SS 2005 JDBC Driver 1.1
    ... SQL Server 2005 JDBC Driver\sqljdbc_1.1) ... I see the .jar file but I have no idea how/where I am to define the ... Panel that a SQL Server JDBC is installed. ... How do I install this? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.sqlserver.server)
Loading