|
 |
asp_databases thread: Hope you guys can help me with this ampersand problem
Message #1 by imran.saleem@b... on Tue, 29 Oct 2002 17:50:14
|
|
Hi Guys,
i just have a quick question about what to replace an ampersand
with when an update/insert is executed in to an SQL Server DB.
For example when we encounter an ' (apostrophe) in a string we replace it
with ''(2 apostrophes) what do we replace an &(ampersand) with.
Thanks in advance.
Message #2 by Greg Griffiths <greg2@s...> on Tue, 29 Oct 2002 21:13:14 +0000
|
|
why do you need to replace it at all ?
At 17:50 29/10/02 +0000, you wrote:
>Hi Guys,
> i just have a quick question about what to replace an ampersand
>with when an update/insert is executed in to an SQL Server DB.
>For example when we encounter an ' (apostrophe) in a string we replace it
>with ''(2 apostrophes) what do we replace an &(ampersand) with.
>
>Thanks in advance.
Message #3 by "Pat Wong" <vinyl-junkie@n...> on Tue, 29 Oct 2002 18:15:01 -0800
|
|
Try replacing special characters with the ISO character set. For
example, the ISO character set for an ampersand is "&" (sans quotes)
or "&" (sans quotes). You can also replace that apostrophe with the
character set "'" (sans quotes). I have an HTML book with a whole
table of ISO character sets, but I'm sure you could find an online
source if you wanted to find other special characters like this.
Hope this helps.
| Hi Guys,
| i just have a quick question about what to replace an ampersand
| with when an update/insert is executed in to an SQL Server DB.
| For example when we encounter an ' (apostrophe) in a string we replace
it
| with ''(2 apostrophes) what do we replace an &(ampersand) with.
|
| Thanks in advance.
|
|
|
|
View Cart
