ProductCart Shopping Cart Software Forums : Data Base name and firstname ending #160 https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:09:53 +0000 Sun, 24 Jun 2007 19:32:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=899 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Data Base name and firstname ending #160 : No, this was when using our QuickBooks...]]> https://forum.productcart.com/data-base-name-and-firstname-ending-160_topic899_post2645.html#2645 Author: JackQB
Subject: 899
Posted: 24-June-2007 at 7:32pm

No, this was when using our QuickBooks Shopping Cart Integrator for a customer. I will mention that to the customer. We put in code to remove the chr(160) but why was it there? 

]]> Sun, 24 Jun 2007 19:32:11 +0000 https://forum.productcart.com/data-base-name-and-firstname-ending-160_topic899_post2645.html#2645 <![CDATA[Data Base name and firstname ending #160 : Did you try exporting the customer...]]> https://forum.productcart.com/data-base-name-and-firstname-ending-160_topic899_post2644.html#2644 Author: ProductCart
Subject: 899
Posted: 24-June-2007 at 7:26pm

Did you try exporting the customer list and then reimporting via the Customer Import Wizard?

- Export name, last name, email
- Review
- Reimport to update the current records: ProductCart uses the email field to match existing customer records

]]> Sun, 24 Jun 2007 19:26:11 +0000 https://forum.productcart.com/data-base-name-and-firstname-ending-160_topic899_post2644.html#2644 <![CDATA[Data Base name and firstname ending #160 : I notice that a lot (most) of...]]> https://forum.productcart.com/data-base-name-and-firstname-ending-160_topic899_post2606.html#2606 Author: JackQB
Subject: 899
Posted: 20-June-2007 at 6:39pm

I notice that a lot (most) of the customer fields  (name and firstname) end with an ascii 160. (535 out of 600) that I checked. I believe that ascii 160 is the extented character a with an accent on top of some sort. I could understand a few whose names with with the accented a but not 5 out of 6.

Does anyone know why this is there or how to remove them?

This may be a non-breaking space character and may have appeared after a move from 1 host provider to another.



Edited by JackQB - 21-June-2007 at 6:37am]]> Wed, 20 Jun 2007 18:39:55 +0000 https://forum.productcart.com/data-base-name-and-firstname-ending-160_topic899_post2606.html#2606