Skip to main content
T
Tim_McLenegan
Participant
April 3, 2008
Question

GB2312 in SQL Server

  • April 3, 2008
  • 1 reply
  • 897 views
We just recently upgraded from ColdFusion 5 to CF8. We have some Chinese text stored in our SQL Server database in a text column in GB2312 format. We have been unable to output the text in CF8. To output the text in CF5, we just needed to use a <META> tag to change the content-type (cfcontent also worked). In CF8, we just get any non-ASCII characters converted to a series of ??????. We have tried using the cfcontent tag, we have tried using cfprocessingdirective, we have even tried the CharsetEncode functions to convert to UTF. We don't want to convert the text fields to utf-8, since we have a lot of text to convert. Any ideas on outputting the text?

We are using CF8, SQL Server 2005, and IIS.

tim
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
April 4, 2008
Tim McLenegan wrote:
> convert to UTF. We don't want to convert the text fields to utf-8, since we
> have a lot of text to convert. Any ideas on outputting the text?

what data type did you use to store the text in sql server? what db driver are
you using now to talk to the sql server db?
T
Tim_McLeneganAuthor
Participant
April 4, 2008
We use ODBC to connect to the database, and the text is stored in a 'text' datatype column. This setup is identical to our working CF5 setup.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices