Storing single quote in a MSSQL database using JDBC 
Author Message
 Storing single quote in a MSSQL database using JDBC

Hi,

How do I store the character ' (single quote) in a SQL DB using JDBC ?

Thanks,
Eyal.



Sun, 16 Nov 2003 08:01:17 GMT  
 Storing single quote in a MSSQL database using JDBC

Quote:

>Hi,

>How do I store the character ' (single quote) in a SQL DB using JDBC ?

Don't know about JDBC, but you normally have to double it within
single quotes, i.e. ''''.

HTH

Paul.
-------------------------------------------
Expressed opinions are usually my own.
Especially if they're any good (of course).
-------------------------------------------



Sun, 16 Nov 2003 23:38:37 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. handling single quotes in database statements

2. CRecordset problem using single quote in field

3. Using a single database connection to access multiple snapshot recordsets

4. Using a single database connection to access multiple snapshot recordsets

5. using multiple tables in a single access database

6. Single Quote in SQL Expression

7. Stringize with single quotes

8. Single vs. Double Quotes

9. testing for a single of double quote

10. characters enclosed in single-quotes

11. aliasing single quotes in macros

12. Single quotes around an evaluated #define?

 

 
Powered by phpBB® Forum Software