When setting up your database, your tables must be able to store the data as unicode. For MSSQL 2000 you'll need to use nchar, nvarchar and ntext instead of char, varchar and text for datatypes of your columns.
When you submit a support ticket for setting up a Coldfusion DSN, please tell us that your DSN needs to support Unicode (UTF-8) so we now we have to set specific settings for that connection
When inserting data into the database, you'll need to specify which part of the data needs to be inserted as unicode values. Here is an example of how it is done with the cfquery tag:
This example shows an N in front of all the values that needs to be inserted into unicode columns. The columns in this example are setup like this: name = nvarchar, continent = nchar and usernotes = ntext.
To make sure that all the information that is sent is received as unicode, you need to add this code to the top of your Application.cfm
Also in the of your page, you need to set the charset to utf-8. Find this line in the head of your page: and change it to: If it doesn't exist, be sure to add it to the tag of your page.
That's about all you need to do to get Coldfusion work with unicode. If you're still having problems getting it to work properly, please submit a support ticket and we can check your DSN to make sure it's enabled for unicode.
- 5 Users Found This Useful
ColdFusion DSN's can now be created through Helm. To create a ColdFusion DSN log into...
Yes, we have several Image Resize components that are free for your use with all hosting...
If ColdFusion does not work on your site, ensure that it is enabled in Helm. To enable...
To use a custom mapping, in your application.cfm file, add some code like this: <cfset...
Yes, Flash Remoting is supported with ColdFusion. We do not currently support plugins for...