this sounds a little bit like a wrong charset. I don't know which one your database or your php is running on, but, for a start, play with this: - charset of the file: If you open your file in an editor that allows storing it as different kinds of charsets, try saving it as something else. It's probably ANSI, try UTF-8 or Unicode. - charset of delivery: If your request ends in one or the other form of html, remember to put in a content type, like this: <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset; ?>"> again, play around with the variable $charset, or, instead, hardcode it in the way you need it. I'm not sure about this, but maybe you can change the same thing by changing the character encoding in your browser manually and not putting in any content-type. Once you've found what you need, put it in as meta tag. Cheers, Matthias -----Original Message----- From: Rodrigo Haces [mailto:rodrigo@xxxxxxxxxxxx] Sent: 10 October 2005 23:13 To: php-db@xxxxxxxxxxxxx Subject: ODBC Problem Hi all: Im currently using php to connect to a database in another server, this is a intersystems cache database. if i do a query to my database and the result has special spanish characters like "´" (á,é,í,ó,ú) it returns me another character, this one changes from time to time, i just tried to make a test with the isql shell program, i connect and ask for the same query and in shell it returns the correct characters. If someone can help me please i'll apretiate. Thanks rodrigo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
