OK i have confirmed that this is not a jstl issue or a driver issue. As when i connect with odbc i still get the '?'. And when i use the usual non-jstl method for connecting with both drivers i still get '?'.
Has anyone else ever had this issue. The special characters are correct in the database but not through jsp? If i use the iso entities e.g. ‘ ’ they show up correctly (using escapeXml="false") but the user enters information in and they don't know how to convert these characters. Are there any functions I could use to convert user entered data to iso entities? -Jeff Travis McCauley <[EMAIL PROTECTED]> 01/29/2003 03:51 PM Please respond to "Tag Libraries Users List" To: Tag Libraries Users List <[EMAIL PROTECTED]> cc: Subject: Re: JSTL SQL Never mind, I was thinking MySql not MS SQL Server. That certainly will not help you. Sorry, Travis >What? > >-----Mensagem original----- >De: Travis McCauley [mailto:[EMAIL PROTECTED]] >Enviada em: quarta-feira, 29 de janeiro de 2003 16:51 >Para: Tag Libraries Users List >Assunto: Re: JSTL SQL > > >Is it possible that the data already in the database is encoded as >unicode? That might explain what you are seeing in your output. It's >possible you just need to configure your browser for unicode or you >might need to add the following parameters to the connection string >you give the JDBC driver. > >useUnicode=true&characterEncoding=UTF-8 > >Travis McCauley >UVA > >>Using the JSTL's sql implementation when I query information from a >>microsoft sql server for some characters i get '?' in place of quotes or >>other characters. When i edit this information with my application the >>correct values are displayed. The '?' only appears from data already in >>the database. >> >>Is this a jdbc driver isssue? >> >>Thanks, >>-Jeff Wilder > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]