how to insert a string containing a single quote to the msql database? help
how can i insert a string which contains a single quote in to database... anyone help
Message was edited by:
sijo_james
[139 byte] By [sijo_jamesa] at [2007-11-27 11:33:16] 
«« Modifying code so that JCheckBox can be used instead of JComboBox
»» how to handle multiple key press in numeric keys
»» how to handle multiple key press in numeric keys
# 2
How I got this solved for myself is to write a sqlEscape() function. This function takes a string, and returns a SQL Safe string. The number of characters you want to escape would depend on your dataset and database. This page explains the escaping required for MySQL : http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html.
HTH.
mADHURtANWANIa at 2007-7-29 16:50:19 >
# 3
Absolutely, Positively use a PreparedStatement. Do not use sqlEscape() function unless you have some overriding need (and I don't know what that could possibly be).
There are 1000's of posts on the positive aspects of using a PreparedStatement rather than using a Statement. The two primary positive attributes of using a PreparedStatement are automatic escaping of Strings and a stronger security model for your application.
WorkForFooda at 2007-7-29 16:50:19 >
# 4
You have to escape single quotes with a single quote in SQL.
I'll be back
->
I''ll be back
isc049a at 2007-7-29 16:50:19 >
Database Connectivity Hot Topic
- Problem with populating ROWSET
- Hibernate binding problem
- Load Oracle JDBC Driver by reflection.
- how to return connection to Connection Pool &to overcome TooManyConnections
- Is that OK to store query Result in String 2 Dimension ?
- Problem with CREATE TABLE statement
- Exception at getConnection from pool
- JExcelAPI unable to output excel to servlet for user download
- need help JDBC masters
- help me with this error
- How to establish a trusted connection with JDBC for SQL SERVER 2000
- java.sql.SQLException: ORA-01006
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding