Re: How to change characterset in SQL Enterprise Manager?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 14:07:57 -0700

By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column. 

-- 
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@phx.gbl...
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
>
> Thanks,
>
>
> >-----Original Message-----
> >If you want to change all you character data to unicode,
> you will need to
> >alter all your char, varchar, and text fields to nchar,
> nvarchar, and ntext
> >fields.
> >-- 
> >
> >---------------------------------------------------------
> -------------------
> >---------------------------------------------------------
> -------------------
> >----
> >
> >Need SQL Server Examples check out my website at
> >http://www.geocities.com/sqlserverexamples
> >"ms_sql_characterset"
> <anonymous@discussions.microsoft.com> wrote in message
> >news:1c37301c4523a$8f26ec10$a101280a@phx.gbl...
> >> Hi,
> >>
> >> I want to change characterset to Unicode in server
> 2000.
> >> How I can do it?
> >>
> >> Thanks,
> >>
> >> ms_sql_characterset
> >>
> >>
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: What all could be the security issues in Unicode Database
    ... Conversion or not, storage is another matter. ... Don't forget, all NT based OS's use UNICODE internally, so the data gets converted to UNICODE and is used in the OS as UNICODE. ... Mike Epprecht, Microsoft SQL Server MVP ... You do not need to use> it unless you know for fact that you will be using extended code pages and> character sets, like Kana Fonts, and such. ...
    (microsoft.public.sqlserver.server)
  • Re: unicode conversion
    ... So it may be better to build a new database from scripts and copy data ... As for the character conversion, ... that you cannot store data as UTF-8 in SQL Server. ... uses UCS-2 to store Unicode. ...
    (microsoft.public.sqlserver.server)
  • Re: Checklist for SQL Server
    ... views as well as stored procedure and function parameters. ... It's probably best to perform unicode testing as part of your overall ... --list character columns not unicode types ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Unicode datatypes and the N
    ... In addition to the others the N indicates that you are providing a Unicode ... string which is 2 bytes per character.. ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: VB - Ascii to Unicode and then Unicode to UTF-8 conversion (Very desperate!!)
    ... Latin together) then you have to use a Unicode column type. ... AscW returns the real Unicode character ... for Chinese characters, ... then the next thing to worry about is your CSV file. ...
    (microsoft.public.vb.general.discussion)