No, it is not possible or supported. You must use Unicode columns to support
Unicode data; any other solution will be subject to MANY internal
translations and may cause data loss depending on the codepage involved.
michka
a new book on internationalization in VB at
http://www.i18nWithVB.com/
----- Original Message -----
From: "Tague Griffith" <[EMAIL PROTECTED]>
To: "Unicode List" <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 3:29 PM
Subject: using Unicode with MS Sqlserver 7.0
> All :-
>
> Is it possible to use Unicode (UCS-2) as a database encoding with
> Sqlserver 7.0 *without* using the N*/Unicode datatypes (e.g. nchar,
> nvarchar, ntext)?
>
> Also according to the documentation, it is possible to change the
> character set of the database at install and creation time; however, I
> haven't seen anything which allows me to do this. Does anyone have any
> pointers.
>
> thanks,
> /t
>
