Re: How to change characterset in SQL Enterprise Manager?

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

anonymous_at_discussions.microsoft.com
Date: 06/14/04 

Date: Mon, 14 Jun 2004 12:13:01 -0700

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: sendStringParameterAsUnicode: How to insert unicode data corre
    ... After checking with Microsoft it turns out that transmitting Unicode ... requires a change in the data format sent to the JDBC Receiver channel. ... We have contacted SAP and Microsoft. ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.sqlserver.server)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Music notes in Outlook Express
    ... this software doesn't have a way to key the pointy b symbol into ... BTW the way I found that was: Character set: Unicode ... Group by: Unicode Subrange Unicode Subrange: Symbols & Dingbats ... Charmap shows that that characterset ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)