473,326 Members | 2,010 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Preserving some characters on db insert

Hi,

I'm looking to find out how to properly handle the input of certain
characters into a textbox that will be inserted into a database. In this
app, text is copied and pasted into a textbox from various sources, and
sometimes contains the funky curly quotes and apostrophes which end up being
dropped on the database insert. I'm not sure if the issue resides in my
asp.net code or in the database itself (SQL 2000). Thanks for any help.
Nov 18 '05 #1
4 1247
On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:
Hi,

I'm looking to find out how to properly handle the input of certain
characters into a textbox that will be inserted into a database. In this
app, text is copied and pasted into a textbox from various sources, and
sometimes contains the funky curly quotes and apostrophes which end up being
dropped on the database insert. I'm not sure if the issue resides in my
asp.net code or in the database itself (SQL 2000). Thanks for any help.

When doing an insert into the db - use a paramaterized query.

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net
Nov 18 '05 #2
I am using a paramaterized query on the insert... any other suggestions?

Thanks.

"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:cb********************************@4ax.com...
On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:
Hi,

I'm looking to find out how to properly handle the input of certain
characters into a textbox that will be inserted into a database. In this
app, text is copied and pasted into a textbox from various sources, and
sometimes contains the funky curly quotes and apostrophes which end up beingdropped on the database insert. I'm not sure if the issue resides in my
asp.net code or in the database itself (SQL 2000). Thanks for any help.

When doing an insert into the db - use a paramaterized query.

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net

Nov 18 '05 #3
On Thu, 05 Aug 2004 14:03:45 GMT, "anony" <no**@m.com> wrote:
I am using a paramaterized query on the insert... any other suggestions?

Thanks.

"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:cb********************************@4ax.com.. .
On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:
>Hi,
>
>I'm looking to find out how to properly handle the input of certain
>characters into a textbox that will be inserted into a database. In this
>app, text is copied and pasted into a textbox from various sources, and
>sometimes contains the funky curly quotes and apostrophes which end upbeing >dropped on the database insert. I'm not sure if the issue resides in my
>asp.net code or in the database itself (SQL 2000). Thanks for any help.
>

When doing an insert into the db - use a paramaterized query.

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net

if you are using a parameterized query to insert - it will maintain all integrity of the charachters.
Bobby Ryzhy
bobby @ domain below
http://weekendtech.net
Nov 18 '05 #4
It must be on the database end then. I'm using SQL Server 2000, and the
textbox.txt is going into a text field. Things like curly quotes and the
"sharp" apostrophe are getting dropped on insert.
"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:tj********************************@4ax.com...
On Thu, 05 Aug 2004 14:03:45 GMT, "anony" <no**@m.com> wrote:
I am using a paramaterized query on the insert... any other suggestions?

Thanks.

"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:cb********************************@4ax.com.. .
On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:

>Hi,
>
>I'm looking to find out how to properly handle the input of certain
>characters into a textbox that will be inserted into a database. In this >app, text is copied and pasted into a textbox from various sources, and >sometimes contains the funky curly quotes and apostrophes which end upbeing
>dropped on the database insert. I'm not sure if the issue resides in my >asp.net code or in the database itself (SQL 2000). Thanks for any help. >
When doing an insert into the db - use a paramaterized query.

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net

if you are using a parameterized query to insert - it will maintain all

integrity of the charachters.

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net

Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Albretch | last post by:
I am trying to insert some textual data belonging to an HTML page into a table column with 'TEXT' as data type mysql's maual _/manual.html#String_types tell you, you may insert up to (2^16 - 1),...
0
by: User | last post by:
I am trying to use JDOM's SAXBuilder to parse an XML document that contains encoded latin-1 characters. After I parse the document, the special character Strings seem to be replaced with their...
16
by: TTroy | last post by:
Hello, I'm relatively new to C and have gone through more than 4 books on it. None mentioned anything about integral promotion, arithmetic conversion, value preserving and unsigned preserving. ...
11
by: anony | last post by:
Hello, I can't figure out why my parameterized query from an ASP.NET page is dropping "special" characters such as accented quotes & apostrophes, the registered trademark symbol, etc. These...
0
by: rlueneberg | last post by:
I am having difficulty with preserving field values in a DetailsView control after clicking the insert button event. protected void DetailsView1_ItemInserted(object sender,...
5
by: Naveen | last post by:
I am trying to write a conatiner which has std::map like methods but preserves the order of insertion. TO achieve this I thought of providing my own function for comparing the keys of the map....
2
by: Clive Green | last post by:
Hello peeps, I am using PHP 5.2.2 together with MP3_Id (a PEAR module for reading and writing MP3 tags). I have been using PHP on the command line (Mac OS X Unix shell, to be precise), and am...
6
by: TheRealDan | last post by:
Hi all. I'm having a problem with a special characters. I have php script that reads from an xml file and writes to a mysql db. It's a script called phptunest that I found on the net, although the...
3
by: sophia.agnes | last post by:
Dear all, I was going through the book "C a software engineering approach by darnell & Margolis" there was a section named sign preserving vs value preserving it is as follows sign...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.