tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Wilder <Jeff.Wil...@puma.com>
Subject Re: JSTL SQL
Date Mon, 03 Feb 2003 20:51:16 GMT
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. &lsquo; &rsquo; 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 <twm4g@virginia.edu>
01/29/2003 03:51 PM
Please respond to "Tag Libraries Users List"
 
        To:     Tag Libraries Users List <taglibs-user@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



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message