开发者

Character set in SQL Server 2005

开发者 https://www.devze.com 2023-01-22 21:56 出处:网络
I\'ve run this code in MySQL, and it\'s succeeded. But when I run it in SQL Server 2005, this error occurred:

I've run this code in MySQL, and it's succeeded. But when I run it in SQL Server 2005, this error occurred:

Incorrect syntax near the keyword 'DEFAULT'

This is the code:

CREATE DATABASE mydb DEFAULT CHARACTER SET 开发者_如何学JAVAutf8

Anyone can explain why it couldn't run successfully in SQL Server 2005. Thanks and sorry for my bad English!


SQL Server doesn't support the "default character set" on the "create database" statement: http://msdn.microsoft.com/en-us/library/ms176061(v=SQL.90).aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消