Is there a way to force a column to be SQL type of Unicode?

abc123 · Post by **abc123** » Thu Aug 20, 2015 3:02 pm

If so, how? It is not one of the options in Under "SQL type".

ray.wurlod · Post by **ray.wurlod** » Thu Aug 20, 2015 5:12 pm

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.

abc123 · Post by **abc123** » Thu Aug 20, 2015 5:34 pm

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.

rkashyap · Post by **rkashyap** » Thu Aug 20, 2015 6:10 pm

Is the DataStage project configured for NLS? Also see this technote.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 20, 2015 6:28 pm

Even if NLS is configured (which it sounds like it isn't), check also that the map selected for the job is not NONE.

abc123 · Post by **abc123** » Thu Aug 20, 2015 7:01 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 20, 2015 7:30 pm

Then you can't do Unicode. With NLS disabled, all you have available is extended ASCII.

abc123 · Post by **abc123** » Thu Aug 20, 2015 7:57 pm

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?

rkashyap · Post by **rkashyap** » Thu Aug 20, 2015 8:20 pm

Assuming that you are licensed for it, see swg21396850 technote. Also see swg21506622.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 20, 2015 8:37 pm

You need to re-install the Engine tier, this time choosing to install NLS.