LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rpcwong

Hi, after we upgraded Brain, many of our existing jdbc queries don't work anymore unless we set "DefaultToUnicode" to true.
I'm wondering if there is any easy way to convert all the Unicode fields back to String afterwards? (and leave the long, int, etc.. untouched?)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

You could use the Data Analyzer, which should convert unicode data to string. In the event it does not, you could use the Change Metadata node to change fields with unicode types to string type. (Note that I have disabled the conversion option in the Data Analyzer.
Attachments:
convertUnicode.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rpcwong

Works great.. I just need to add in an additional blong type :-)

Thanks

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: NettaB

Was faced with the same myself & this helped me save sooooooooooooooooooooooo much time! Hi5 for the forum