Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Extended ASCII incompatibility between Mac and PC

Author  Topic  torusty Starting Member 2 Posts Posted - 2001-05-29 : 23:42:13 Hi. I'm new to this forum and pretty new to SQL. I've been going crazy trying to figure this out, I hope some can help: My problem is with extended ASCII characters when they are entered into my website which is hosted by Cold Fusion Server, with a Microsoft SQL 7 database. When a user on a Mac (I tested on OS 8.6 & 9) submits a string, such as "Lancôme" (o with a “hat”), into an HTML text field and saves it, it can later be seen on the Mac but not from a PC. If looking at the data from a PC the character is changed to various extended ASCII characters. The problem also exists if a user submits a string from a PC platform, again the user can view the data perfectly on the PC using his browser but then the Mac user will see it incorrectly. (The problem only exists with extended ASCII characters such as ó ÿ É ...) I am using the following: Windows NT 4.0 Server Service Pack 6a Microsoft SQL 7 Server with service pack 2 Coldfusion Server 4.5.1. with service pack 2 SQL ODBC Driver 3.70.08.21 Any help is appreciated. Thanks in advance. Rusty