|
|
||||||
|
#1
09-15-09, 08:38 PM
|
|
|
|
|
Hi,
I have a field that contains special characters (', % etc) the ' causes problems because it messes up the SQL insert/update command, what is the best way to deal with this, I tried encode but then the entry in the DB is not correct? Thanks for any advice. |
|
|
|
#2
09-15-09, 09:13 PM
|
|
|
|
|
Excel User wrote:
> Hi, > > I have a field that contains special characters (', % etc) the ' > causes problems because it messes up the SQL insert/update command, > what is the best way to deal with this, I tried encode but then the > entry in the DB is not correct? > > Thanks for any advice. Use parameters. See: http://groups-beta.google.com/group/...e36562fee7804e Personally, I prefer using stored procedures, or saved parameter queries as they are known in Access: Access: http://www.google.com/groups?hl=en&l...TNGP12.phx.gbl http://groups.google.com/groups?hl=e...gp13.ph x.gbl SQL Server: http://groups.google.com/group/micro...09dc1701?hl=en |
|
#3
09-22-09, 06:23 AM
|
|
|
|
|
You double them.
|
|
|
| Similar Threads | |
| Special Characters A very simple question about the difference in behaviour between 2000 and 2005 fti: the following search in a parts catalog works in SQLServer 2000 select count(1) from... |
|
| Counting utf-8 characters -special characters I have character counter for textarea wich counting the characters. Special character needs same place as two normal characters because of 16-bit encoding. Counter is... |
|
| How to convert HTML special characters to the real characters with a Java script I read data (e.g. äöüÄÖÜçéàè"') from my MySQL database which I'd like to show in an input box. <?php $mysql_data = "äöüÄÖÜçéàè\"'"; $html_data =... |
|
| Replace special characters by non-special characters i'm looking for a way to replace special characters with characters without accents, cedilles, etc. |
|
| windows 2003 web edition. Websites with special characters, danish characters Hello I am moving all our sites from windows 2000 server to windows 20003 web edition server. I have a few .nu sites with danish characters, but the iis6 does not seem to... |
|
|
All times are GMT. The time now is 11:16 AM. | Privacy Policy
|
Special characters