Page 1 of 1
Is there a way to force a column to be SQL type of Unicode?
Posted: Thu Aug 20, 2015 3:02 pm
by abc123
If so, how? It is not one of the options in Under "SQL type".
Posted: Thu Aug 20, 2015 5:12 pm
by ray.wurlod
It's in the Extended properties.
If your data type is Char or VarChar (or one of the Long variants), then "Unicode" becomes available as an Extended property.
If you can't see an Extended column in your Columns grid, right click in the title area or the background area of the grid, and edit the columns that are to be displayed.
Posted: Thu Aug 20, 2015 5:34 pm
by abc123
I was able to display the Extended column. I tried selecting both Char and Varchar but Unicode does not show in the Extended column. The drop down is empty.
Posted: Thu Aug 20, 2015 6:10 pm
by rkashyap
Is the DataStage project configured for NLS? Also see
this technote.
Posted: Thu Aug 20, 2015 6:28 pm
by ray.wurlod
Even if NLS is configured (which it sounds like it isn't), check also that the map selected for the job is not NONE.
Posted: Thu Aug 20, 2015 7:01 pm
by abc123
rkashyap, I did that step. Still Unicode is not visible.
Ray, in the Administrator, NLS is disabled for the project. The button is grayed out.
Posted: Thu Aug 20, 2015 7:30 pm
by ray.wurlod
Then you can't do Unicode. With NLS disabled, all you have available is extended ASCII.
Posted: Thu Aug 20, 2015 7:57 pm
by abc123
How do I enable NLS? I looked at this post:
viewtopic.php?t=104828&highlight=enabling+nls
and few others. I don't have a NLSMODE setting in my uvconfig. Do I need to uninstall and reinstall Datastage to enable NLS? Or can I check something else?
Posted: Thu Aug 20, 2015 8:20 pm
by rkashyap
Assuming that you are licensed for it, see
swg21396850 technote. Also see
swg21506622.
Posted: Thu Aug 20, 2015 8:37 pm
by ray.wurlod
You need to re-install the Engine tier, this time choosing to install NLS.