|
|
Article: Microsoft SQL Server 6.5 and high ASCII values. (Product Information)
- Article from:
- e-Business Advisor
- Article date:
- June 1, 1998
- Author:
CopyrightCOPYRIGHT 1998 Advisor Publications, Inc. This material is published under license from the publisher through the Gale Group, Farmington Hills, Michigan. All inquiries regarding rights should be directed to the Gale Group. (Hide copyright information)
|
Storing data containing characters with high ASCII values in Microsoft SQL Server doesn't always result in the right values.
Using a web browser, a Java applet, and JDBC with a type 3 JDBC driver, we found that characters with high ASCII (over 175 in our case), weren't stored correctly in our SQL Server 6.5 database. We had to go to the setup and change the selected character set for MS SQL from default ISO 8859-1 to Code Page 437 (U.S.English). We then had to rebuild our database.
Using Microsoft Internet Explorer 4.0 in the same scenario, again with high ASCII value characters, the data wasn't sent correctly from the browser. It worked with previous ...