I have a Cold Fusion application that is in both English and Croation. When the server displays some of the special Croatian characters such as š, it displays a square symbol instead.
My development server displays the characters properly, but my production server does not. 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. It's just when they are pulled through a query that they stop displaying properly.
Please give me some direction on how to stop this from happening.
My development server displays the characters properly, but my production server does not. 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. It's just when they are pulled through a query that they stop displaying properly.
Please give me some direction on how to stop this from happening.
