You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by Jeff Wilder <Je...@puma.com> on 2003/02/03 21:51:16 UTC
Re: JSTL SQL
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 <tw...@virginia.edu>
01/29/2003 03:51 PM
Please respond to "Tag Libraries Users List"
To: Tag Libraries Users List <ta...@jakarta.apache.org>
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:twm4g@virginia.edu]
>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: taglibs-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org