I have a Cold Fusion application that is in English and Croation. When the server displays some of the special Croatian characters such as š, it displays a š instead.
My development server displays the characters properly. Here are the specs on both my dev box and my production box:
Development Server (Works properly):
Win2K w/ IIS 5
Cold Fusion 4.5
SQL Server 7
Production Server (has issue):
Win2K w/ IIS 5
Cold Fusion MX
SQL Server 2000
I know it's not Cold Fusion because I can paste the same text that I have in the database into a .cfm file and it displays properly.
I believe the problem is with SQL server 2000. The values in the tables are fine and display properly. I can't seem to find anywhere on the server where I can modify the character set behavior.
My development server displays the characters properly. Here are the specs on both my dev box and my production box:
Development Server (Works properly):
Win2K w/ IIS 5
Cold Fusion 4.5
SQL Server 7
Production Server (has issue):
Win2K w/ IIS 5
Cold Fusion MX
SQL Server 2000
I know it's not Cold Fusion because I can paste the same text that I have in the database into a .cfm file and it displays properly.
I believe the problem is with SQL server 2000. The values in the tables are fine and display properly. I can't seem to find anywhere on the server where I can modify the character set behavior.