View Single Post

   
  #5 (permalink)  
Old 02-27-2008, 04:24 AM
deebeetwo@yahoo.com
 
Posts: n/a
Default Re: Graphic columns not allowed

Serge Rielau wrote:
> To the best of my knowlegde NVARCHAR in SQL Server is UCS-2 (double

byte
> Unicode). In DB2 that would match GRAPHIC in a Unicode database.
> If you have a lot of NVARCHAR flying around you may want to consider
> just using a unicode. Your VARCHAR columns will then be UTF-8 and
> GRAPHIC UCS-2.


That is interesting. So, if the database's default character set is
unicode or UTF-8, then the SQL Server NVARCHAR would just map to a
VARCHAR in DB2. (I take it the same is true for other Nxyz data types
too.) That makes sense and simplifies things a lot.

Thanks a lot!

Reply With Quote