SYMPTOM:
Strategy Web 10.x cannot import data which has Unicode 6.0 characters from GreenPlum 4.3.
This error message can be seen on both Windows and Linux environments.
In this situation, the GreenPlum Database uses the character code set as UTF-8 and it is not clear whether GreenPlum 4.3 can use Unicode 6.0 or not in itself.
It means we can predict the characters of Unicode 6.0 would be garbled even if we can import the data including Unicode 6.0 characters.
Sample Code/Error
QueryEngine encountered error: MBase::UnicodeValueToWideChar: Invalid UNICODE value...
Unicode 6.0 characters:
The specific characters mainly used by Japanese Mobile phone are described on the Web via the link as below:
http://ja.wikipedia.org/wiki/Unicode6.0%E3%81%AE%E6%90%BA%E5%B8%AF%E9%9B%BB%E8%A9%B1%E3%81%AE%E7%B5%B5%E6%96%87%E5%AD%97%E3%81%AE%E4%B8%80%E8%A6%A7
CAUSE:
This is a known issue in Strategy Web 9.4.1.
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
Third Party Software Installation WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
