tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bwasko" <bwa...@o2.pl>
Subject Re: lame,encoding problem
Date Mon, 24 Nov 2003 10:22:45 GMT
I ve also tried connection strings manipulations ?use Unicode and
?characterEncoding . Doesn't work.... :(
Bartek Wasko
----- Original Message ----- 
From: "Galbayar" <galbayar@mobinet.mn>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Monday, November 24, 2003 10:47 AM
Subject: RE: lame,encoding problem


> jdbc:mysql://127.0.0.1:3306/test/?useUnicode=true
>
> -----Original Message-----
> From: bwasko [mailto:bwasko@o2.pl]
> Sent: Monday, November 24, 2003 4:50 PM
> To: Tomcat Users List
> Subject: Re: lame,encoding problem
>
>
> Hi
> I 've tried to execute insert statement that contains my national
characters
> with the mysql command-line client tool and all looks ok. The strings are
> properly written into database. But writing into it with use of jdbc
driver
> ends with chars like  '??????'. I use mysql-connector and i think it
causes
> these problems.
>
> Cheers Bartek
> ----- Original Message -----
> From: "Christopher Schultz" <christopher.d.schultz@comcast.net>
> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> Sent: Monday, November 24, 2003 4:41 AM
> Subject: Re: lame,encoding problem
>
>
> > Bartek,
> >
> > > But then when I do something with these
> > > parameters and my mysql database I get then them wrong encoded and
> > > all data read from mysql are wrong encoded .
> >
> > Hmmm... if you use your Java code to insert some text into the DB, does
> > it look okay when you read it back out using the mysql command-line
> > tool? I'm wondering if the characters are being mangled on the way into
> > of out of the database.
> >
> > See... the UTF-8 encoding only comes into play when converting bytes
> > from the request into Strings on which your Java code operates. Once
> > you're in the Java world, everything should be okay. Again, when you
> > write the data back out to the response, the UTF-8 comes into play as
> well.
> >
> > However, when writing to the db, the strings also need to be converted
> > to bytes by some character encoding. It's very possible that either the
> > VM and/or MySQL are using incompatible character sets. Check to see what
> > the value of the system property "file.encoding" is at runtime.
> >
> > Then again... unless you really are using multibyte characters, you
> > should be okay no matter what. The MySQL JDBC driver should be using the
> > same encoding going both to and from the db. But, if it's an encoding
> > that doesn't understand multibyte characters (like ISO-8859-1), then you
> > might be permanently damaging those characters. Though I use MySQL/Java
> > all the time, I'm not sure how to set the character encoding for the
> > JDBC driver. Check the MySQL documentation, and let us know what you
find.
> >
> > Hope that helps,
> > -chris
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message