Cross-Connection Query Builder. All characters to the right of 'special characters' are getting cut off or truncated. (4295667)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Cross-Connection Query Builder. All characters to the right of 'special characters' are getting cut off or truncated.
Description

Queries created in a 'Cross-Connection Query Builder' window, all characters to the right of 'special characters' (including the special character itself) are getting deleted or removed. If the table with the special characters are queried via a regular Editor window, it works fine.
Cause

The hub uses UTF-8 to encode characters, but SQL Server is usually speaking UCS-2 instead of UTF-8 when it comes to UNICODE strings. There's no auto-conversion from UCS-2 to UTF-8 in the hub so the strings would be erroneously handled.
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad Data Point.
Defect ID

QAT-6196

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title