 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / April 2004JDBC/MYSQL Driver ...
hi there... i'm building an app that uses a MYSQL database. I'm looking for a driver to connect to the database that supports special caracter such as "?", "?", "?", etc ... the one i'm using doesn?t support them and messes up the words ... anyone knows where i can find it ... thks in advance ... cheers  Signaturenuno belo * http://gooofy.blogspot.com/ [my blog] > hi there... > [quoted text clipped - 10 lines] > nuno belo > * http://gooofy.blogspot.com/ [my blog] It might help if you told us which driver you're using... i?m using "mysql-connector-java-3.0.11" ... thks ... Signaturenuno belo * http://gooofy.blogspot.com/ [my blog] > > hi there... > > [quoted text clipped - 14 lines] > > > It might help if you told us which driver you're using... > hi there... > [quoted text clipped - 6 lines] > > cheers What makes you think it is the driver that is screwing it up ? I'd be inclined to suggest that your application code may have a problem at the very least (there are more possibilities that are more probable that the driver being the cause). Can you verify that it is the driver ? SignatureTony Morris (BInfTech, Cert 3 I.T.) Software Engineer (2003 VTR1000F) Sun Certified Programmer for the Java 2 Platform (1.4) Sun Certified Developer for the Java 2 Platform hi there once again ... i can verify that is the driver because java prints the information well, if i insert it into the database from the command prompt it recognizes the characters well, so the only thing in the middle here is the driver ... so i concluded that the driver is screwing up the text when the special chars appear ... thks ... Signaturenuno belo * http://gooofy.blogspot.com/ [my blog] > > hi there... > > [quoted text clipped - 14 lines] > driver being the cause). > Can you verify that it is the driver ? first??confirm the MySql Driver is valid for the MySql server from www.mysql.com then you can try connector-url like jdbc:mysql://hostname:3306/test?useUnicode=true&characterEncoding=yourEncodi ng(?) > i'm building an app that uses a MYSQL database. I'm looking for a driver > to connect to the database that supports special caracter such as "?, "?, [quoted text clipped - 8 lines] > nuno belo > * http://gooofy.blogspot.com/ [my blog] first??confirm the MySql Driver is valid for the MySql server from www.mysql.com then you can try connector-url like jdbc:mysql://hostname:3306/test?useUnicode=true&characterEncoding=yourEncodi ng(?) > i'm building an app that uses a MYSQL database. I'm looking for a driver > to connect to the database that supports special caracter such as "?, "?, [quoted text clipped - 8 lines] > nuno belo > * http://gooofy.blogspot.com/ [my blog] > hi there... > [quoted text clipped - 6 lines] > > cheers I solved that problem by using the MySQL connector drivers and setting content type to iso-8859-1 using the JSP page directive. I had problems with the mm.mysql.. driver. /S Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.