charset

Character set in SQL Server 2005

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 utf8 Anyone can explain why it couldn't run successfully in SQL Server 2005. Thanks and sorry for my bad English! ...

cfsavecontent + cfinclude with utf-8 charset?

I have a line of coldfusion code that includes an cfm file encoded with the utf-8 charset and saves it to a variable. The problem I am having is that there is no way to specify a charset in cfinclude and the resulting variable does not seem to be reading utf-8 correctly so any non ascii characters are rendered incorrectly. <cfsaveconte...