How do control characters get entered in textbox

I support an online credit card payment system.  Every once in a while the data the customer enters into a textbox (different ones) has control characters at the end of the text data.  Specifically newline carriage return (Hex 0D0A or Hex 0D0A0D0A).  I have not been able to input these characters using IE 6.0 on XP Pro or using IE 6.0 on Win 2000 server.  Since I can't input them I can't test to see if I have successfully stripped them before using the data.

Does anyone know how the customer is entering these control characters?  Thanks.  

BettyB.
bettyb1656Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
trevorhartmanConnect With a Mentor Commented:
you can sometimes copy the value of a control character from another program, like notepad.  when you paste them into a field, they show up as a little box
0
 
fritz_the_blankCommented:
Building on what trevorhartman  said, the most likely cause is pasting from Word or Excel.

Fritz the Blank
0
 
Anthony PerkinsCommented:
>>Does anyone know how the customer is entering these control characters?<<
Sure:
Hex 0D0A = Alt+13 Alt+10.  As in &#9834;&#9689;
Hex 0D0A0D0A = Alt+13 Alt+10 Alt+13 Alt+10, as in &#9834;&#9689;&#9834;&#9689;
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
bettyb1656Author Commented:
I couldn't get anything from notepad, word, or excel to enter the control characters that are giving me trouble.

Alt+13 Alt+10 show on the input screen and in the database and do not cause the same problems.

Also, my users are quite unsophisticated and I doubt they ever use the alt key.  One user entered his address with hex 0D0A at the end three times in a row. I believe that the problem is using a MAC or a Unix variant, but I don't know and don't have either to test with.

Another problem that I have run into is that production is SQL Server 7 which shows the hex characters as a square box but my test systems are SQL Server 2000 and the hex characters show as spaces.  Is there any configuration to set to have the SQL Server 2000 show the square boxes?
0
 
trevorhartmanCommented:
not sure on display, but is it possible that the control character could be added to the value elsewhere in your script?
0
 
bettyb1656Author Commented:
I don't think it is possible.  The system has been running since 2001 and there have only been 6 times that newline carriage return characters have appeared in the database.
0
All Courses

From novice to tech pro — start learning today.