Hello,
I am building a web page using Windows 2000 Server, IIS 5.0, ASP (with vbscript) and MySQL database with MySQL Connector/ODBC. The content of this web page is in Spanish thus the database will contain letters with Spanish accents. My problem is that the Spanish characters are not displayed correctly on my web page. Querying the database with the mysql client I see that the character ó in the word Supervisión is ok but when my web app queries the database the web page displays Supervisi¢n. The ó character seems to be switched for the ¢ character. Does anyone know why this is happening and how I can fix it? mysql> select * from menu_data where service_id = 8; +---------------------+---------------------------------+------------------- --------------+ | service_id | service_identifier | service_order | +---------------------+---------------------------------+------------------- --------------+ | 8 | Supervisión | 8 | +---------------------+---------------------------------+------------------- --------------+ Thanks, Troy *************************************************************************** DISCLAIMER: Este mensaje contiene información propietaria de la cual parte o toda puede contener información confidencial o protegida legalmente. Esta exclusivamente destinado al usuario de destino. Si, por un error de envio o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente. Si no es el destinatario final de este mensaje no debe usar, informar, distribuir, imprimir, copiar o difundir este mensaje bajo ningún medio. --------- DISCLAIMER: This e-mail contains propietary information some or all of which may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. ***************************************************************************