Re: Inserting special character into MySQL 5 problem

2005-11-28 Thread Stanislav
> OK. > > I think I know what is going on here. For some reason, everytime we email > you the ampersand > entity, it get translated into a literal & again and it looks like nothing > has changed. > > I am going to use "@amp;" but you change @ to & in your code: > > jdbc:mysql://l

Re: Inserting special character into MySQL 5 problem

2005-11-24 Thread Paul Benedict
OK. I think I know what is going on here. For some reason, everytime we email you the ampersand entity, it get translated into a literal & again and it looks like nothing has changed. I am going to use "@amp;" but you change @ to & in your code: jdbc:mysql://localhost/[EMAIL PROT

RE: Inserting special character into MySQL 5 problem

2005-11-24 Thread hermod.opstvedt
ng special character into MySQL 5 problem > Either i did the mistake or my email client :-) > > the '&' character must become & (thats one of the five predefined > XML entities) so the URI (one more try now) must be > > jdbc:mysql://localhost/databaseName?useUn

Re: Inserting special character into MySQL 5 problem

2005-11-24 Thread Stanislav
> Either i did the mistake or my email client :-) > > the '&' character must become & (thats one of the five predefined > XML entities) so the URI (one more try now) must be > > jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 > I still got the same thing, but i sur

Re: Inserting special character into MySQL 5 problem

2005-11-24 Thread Emmanouil Batsis
Stanislav wrote: Because you're doing XML, you need to escape XML entities. Change your value to this: jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 I don't know where to put this :- If I put this line of code in data-source I get error

Re: Inserting special character into MySQL 5 problem

2005-11-24 Thread Stanislav
> >>Because you're doing XML, you need to escape XML entities. > >> > >>Change your value to this: > >> > >>jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 > >> > >> > >> > >I don't know where to put this :- > > > >If I put this line of code in data-source I get

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Emmanouil Batsis
Stanislav wrote: Because you're doing XML, you need to escape XML entities. Change your value to this: jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 I don't know where to put this :- If I put this line of code in data-source I get error Ah you

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Stanislav
> Because you're doing XML, you need to escape XML entities. > > Change your value to this: > > jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 > I don't know where to put this :- If I put this line of code in data-source I get error Can you send me some par

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Paul Benedict
Because you're doing XML, you need to escape XML entities. Change your value to this: jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Stanislav
>This isn't a Struts prolem, and it's not a MySQL problem either. As usual, >it's "user error" :-) >These are two things to do: >[1] If you're importing through Java, you need to make sure your file reader >is properly decoding >UTF-8 stings: >http://javaalmanac.com/egs/java.io/ReadFromUTF8.htm

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Paul Benedict
This isn't a Struts prolem, and it's not a MySQL problem either. As usual, it's "user error" :-) These are two things to do: [1] If you're importing through Java, you need to make sure your file reader is properly decoding UTF-8 stings: http://javaalmanac.com/egs/java.io/ReadFromUTF8.html [2]

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Stanislav
> >Where can i put this connestion URL in code? Only url connection I use is in > >struts-config.xml, > but >only this part: jdbc:mysql://localhost:3306/db-name. > > > > this should be it, change to > > jdbc:mysql://localhost:3306/db-name?useUnicode=true&characterEncoding=UTF-8 > OK. Tnx :-) I

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Emmanouil Batsis
Stanislav wrote: Where can i put this connestion URL in code? Only url connection I use is in struts-config.xml, but only this part: jdbc:mysql://localhost:3306/db-name. this should be it, change to jdbc:mysql://localhost:3306/db-name?useUnicode=true&characterEncoding=UTF-8 -

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Stanislav
> >I think that JSP encoding isn't relevant here, because I put these special > >letters into Java > Action, >not from Form, and (for now) i directly call taht action. I'm not > doing anything with JSP > > page... > > > > I'll try to be generic here and suppose you use a form. The JSP > gener

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Bednarz, id-on GmbH
unsubscribe *** REPLY SEPARATOR *** On 23.11.2005 at 11:42 Emmanouil Batsis wrote: >Stanislav wrote: > >>I think that JSP encoding isn't relevant here, because I put these >special letters into Java Action, >>not from Form, and (for now) i directly call taht action. I'm not doin

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Emmanouil Batsis
Stanislav wrote: I think that JSP encoding isn't relevant here, because I put these special letters into Java Action, not from Form, and (for now) i directly call taht action. I'm not doing anything with JSP page... I'll try to be generic here and suppose you use a form. The JSP generati

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Stanislav
I think that JSP encoding isn't relevant here, because I put these special letters into Java Action, not from Form, and (for now) i directly call taht action. I'm not doing anything with JSP page... - Original Message Follows - > The problem may lies in Jsp Page encoding, I thnk.2005/11

Re: Inserting special character into MySQL 5 problem

2005-11-23 Thread Comain Chen
The problem may lies in Jsp Page encoding, I thnk. 2005/11/23, Stanislav <[EMAIL PROTECTED]>: > Hello! > > I'm having very strange problem :-( I'm using CharacterEncodingFilter set to > work with utf-8 > encoding (response and request) and when testing aplication geting: > > 08:29:42,970 INFO [ST

Inserting special character into MySQL 5 problem

2005-11-22 Thread Stanislav
Hello! I'm having very strange problem :-( I'm using CharacterEncodingFilter set to work with utf-8 encoding (response and request) and when testing aplication geting: 08:29:42,970 INFO [STDOUT] RESPONSE character encoding= utf-8 08:29:42,970 INFO [STDOUT] REQUEST character encoding= UTF-8 08: