UDTs as DBCS

[Jim Wilcox]

I've got a problem with database modeling in Visio EA for 2005 (ß). I've
created several UDTs which are nvarchar(x) types. The problem is that when
I generate the DDL from the Visio model, it generates them as single byte
(varchar not nvarchar) strings. If I reverse engineer a correctly defined
database, the nvarchar UDTs come back as IMAGEs. Yuk!! How can I get this
thing to generate DDL correctly? Any pointers or perhaps a work-around?

Thanks,
-Jim

get rid of the interleaved ("nospam") to reply directly.

 

[Jim Wilcox]

Ok... I figured it out... don't know how it got this way, but there's a
checkbox in the ODBC setup on a "Preferred settings" tab that says "Map DBCS
to Unicode"... somehow that got unchecked on my system. My colleague's
system never had this problem, and I only recently developed it, without
noticing, initially. Yuk.

 

[JeremyTheBear]

that hasn't worked for for reverse engineering. Did that work for you
for reverse engineering as well as forward engineering?