Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Wchar datatype

61 views
Skip to first unread message

JimS

unread,
Oct 18, 2008, 6:25:01 AM10/18/08
to
Is the Wchar datatype used in SSAS a varying or fixed length type?

Deepak Puri

unread,
Oct 19, 2008, 1:45:25 PM10/19/08
to
According to this BOL entry, it represents a null-terminated string,
similar to the .NET String type:

http://technet.microsoft.com/en-us/library/ms129408(SQL.90).aspx
>>
SQL Server 2005 Books Online (September 2007)
DataType Element (ASSL)
..
WChar
A null-terminated stream of Unicode characters. This data type maps to
the String data type in the .NET Framework and the DBTYPE_WSTR data type
in OLE DB.
..
>>


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

JimS

unread,
Oct 20, 2008, 4:32:02 AM10/20/08
to
Sorry, but I'm none the wiser; not familiar with the term "null-terminated
string". If I have a dimension attribute with a Name Column declared as
Wchar(100), does every member of the dimension occupy 100 bytes (200 bytes
Unicode), i.e. fixed length, or is each member truncated to remove trailing
blanks, i.e. varying length?

"Deepak Puri" wrote:

> According to this BOL entry, it represents a null-terminated string,
> similar to the .NET String type:
>
> http://technet.microsoft.com/en-us/library/ms129408(SQL.90).aspx
> >>
> SQL Server 2005 Books Online (September 2007)
> DataType Element (ASSL)

> ...


> WChar
> A null-terminated stream of Unicode characters. This data type maps to
> the String data type in the .NET Framework and the DBTYPE_WSTR data type
> in OLE DB.

> ...

Ohjoo Kwon

unread,
Oct 20, 2008, 5:38:40 AM10/20/08
to
I guess WChar maps to nvarchar(max).

Ohjoo

"JimS" <Ji...@discussions.microsoft.com> wrote in message
news:A79CEBC2-1A9E-4C2C...@microsoft.com...

0 new messages