Jim Lawrence
accessd at shaw.ca
Wed May 16 22:40:16 CDT 2007
Hi Marty and anyone else interested: The solution to the AJAX invalidly encoded return data has been solved. It appears that any data returned from a source must have a header supplied. The caller reads this first and sets the configuration appropriately. But that the first returning data (first line) must set the encoding. In the event of an ASP server page the first line might be something like: Response.AddHeader "Content-type", "text/html; charset=iso-8859-1" ...or PHP like: header("Content-type: text/html; charset=iso-8859-1"); ...or when any type of transaction takes place between a server and client an appropriate header must be supplied. When an ASP.Net server script is serving a PDF file: Response.AddHeader("Content-Disposition", "inline; filename=mydocument.pdf") ..or initiate data Report: response.addheader("Content-Disposition", inline; filename=Report"); ... or set up for receiving XML data: <?xml version="1.0" encoding="UTF-8"?> It all seems very obvious now. Hope this helps someone who is thinking of working with AJAX or extensively with Server/Client applications. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Thursday, May 10, 2007 1:18 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OT AJAX question I would have to see the Javascript that is doing this Generally this would be set in the encoding parameter of the XML PI Processing instruction, there are about 30 of these some dependant on the Windows codepage. SQL Server or Access punts it out in UTF-8 even without including a PI. There are ways to transliterate between encodings using ADO streams. It can also be determined by the BOM marker at the start of the file. In your case for Unicode encoding, you would want something like this XML PI <?xml version="1.0" encoding="UTF-8"?> http://www.geocities.com/pmpg98_pt/CharacterEncoding.html http://support.microsoft.com/kb/q275883/ XML Encodings MSXML supports all encodings that are supported by Microsoft Internet Explorer. Internet Explorer's support depends on which language packs are installed on the computer; this information is stored under the following registry key: HKEY_CLASSES_ROOT\MIME\Database\Charset xml example <?xml version="1.0" encoding="ISO-8859-1"?> <character> <chr>í</chr> </character> <!-- ISO-8859-1 encoded (Windows Code Page 1252?) --> <!-- It must have the correct encoding declaration --> <!-- The special char will display correctly on system that suport that codepage --> Jim Lawrence wrote: >OT AJAX > >Hi all: > >This question is totally off-topic but the list members here have an >incredible berth and depth of knowledge and I am sure someone will know or >know where to look. > >For anyone here that has worked with AJAX/XML by default the information >coming back from the server only supports 128 bit ASCII. That is great for >straight English but any other single byte language, 256 bits is a minimum. > >Has anyone ran across a solution or knows where to find a solution? If so >many thanks is advance. (...have researched a number of potential solutions >but have been unable to either get them to work or have them fall-over with >one client or another.) > >Jim > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com