Hi,
How to handle NVarchar datatype in Datastage Server job.
If we use varchar datatype for Nvarchar in Odbc stage...Will it makes a difference?
Thanx
Nvarchar datatype
Moderators: chulett, rschirm, roy
Yes, you can use VarChar for this datatype. The NVarChar is for instances where the database has no NLS and is used to contain string data in an alternate character mapping (i.e. to hold Multibyte data).
You can use VarChar without a problem in DataStage for NVarChar fields provided you don't need to have a character set conversion be performed. Even if the data contains multibyte or other non-local character set data as long as you don't need to perform substring-type operations on that column you will have no problem.
You can use VarChar without a problem in DataStage for NVarChar fields provided you don't need to have a character set conversion be performed. Even if the data contains multibyte or other non-local character set data as long as you don't need to perform substring-type operations on that column you will have no problem.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Sure you can do a load to a temporary table and use that data further. There is no magic surrounding the NVarChar datatype, it is just like a VarChar which can hold a different character set from varchar [at least that is the way I look at it].
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>