Mamta Satoor wrote:
> I realize that we are still discussing what should be the right
> collation for different character string type instances, but I want to
> put out cases which will hopefully aid in making a decision or expose
> different scenarios.
>
> Consider following case for parameter with CAST.
> select * from customer where CAST(? as char(10)) = name
> The CAST node will assign the DTD associated with char(10) to the ?. But
> what should be the collation type for char(10). Currently in the code,
> it is UCS_BASIC and hence ? ends up getting UCS_BASIC. As a result, the
> result of the CAST operand gets a collation type of UCS_BASIC amd the
> comparison against "name" fails with compilation time error. Now doing a
> CAST on "name" is not an option to fix this problem because CAST(name as
> char(10)) will result in a character string type with collation of
> territory based. So, the question is what should be the collation type
> of char(10) in the eg above?
Why would the two casts be different here? What makes one UCS_BASIC and
the other territory based?
Dan.
|