Is there a way to force a column to be SQL type of Unicode?
Moderators: chulett, rschirm, roy
Is there a way to force a column to be SQL type of Unicode?
If so, how? It is not one of the options in Under "SQL type".
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
Assuming that you are licensed for it, see swg21396850 technote. Also see swg21506622.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: