Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OraOLEDB is still crazy

Wataru TanabeOct 28 2015 — edited Jun 10 2020

https://community.oracle.com/message/12990330#12990330

If there is no way to reply to archived discussions,

they don't seem to know that they tend to waste much time more than 120 days to solve the problems of their products.

(The reason why they archive discussions might be because they might know that the problems would be never solved.)

----

> In THIS APRIL(after March, 2015), we built the LATEST(*) 11.2.0.4 client environment.

> As a result, we found new behavior of OraOLEDB...

In the end of THIS SEPTEMBER, we build LATEST(*) 11.2.0.3 client environment.

*)You should ask Oracle Support how to update 11.2.0.3 client to latest revision.

As a result, we found new behavior of OraOLEDB...

---- our result ----

Name|Replace(Value," ","B")|DefinedSize|Type

EQ|ああ|2|202

LT|ああ|4|202

----

They seem to stop appending crazy blanks at last.

The value "202" of "Type" means "adVarWChar".

The number of characters of the value of CHAR(4 BYTE) is "less than or equal to" 4(VARIABLE-characters)

even though the number of bytes of the value is "just equal to" 4(FIXED-bytes)

when the encoding is JA16SJISTILDE(VARIABLE-width 2 byte character set).

Had they recovered their senses?

Not yet.

Why do they still believe that DefinedSize of "EQ" must be "2"?

Why do they cause inconsistencies to cause inconsistencies?

Comments

Processing

Post Details

Added on Oct 28 2015
36 comments
3,420 views