CODEWITHSUNDEEP
sql-serverdatabaseencoding
Alon Gubkin
Alon Gubkin

Reputation: 57149

How do I set database default Encoding?

How do I set the the default encoding of my local file SQL-Server database?

Thanks.

EDIT: Removed the UTF-8

Upvotes: 5

Views: 9065

Answers (3)

Fedearne
Fedearne

Reputation: 7368

SQL Server does not support UTF-8.

Use nvarchar (UTF-16) if you don't mind using double space or varbinary if you don't need sort/indexing/comparison.

It may be supported in next release of SQL Server according to this post

Upvotes: 0

Andomar
Andomar

Reputation: 238296

Assuming by encoding you mean collation, you can change the default for new databases like:

alter database model collate SQL_Latin1_General_CP1_CI_AS

The change the collation of an existing database:

alter database YourDbName collate SQL_Latin1_General_CP1_CI_AS

The list of available collations is returned by a system function:

select * from fn_helpcollations()

Upvotes: 6

wishi
wishi

Reputation: 7387

/*!40101 SET NAMES utf8 */

Something like that

Upvotes: -3

Related Questions