?
Solved

Degrees symbol not translating correctly ( ý ??? ) when inserting into database!!

Posted on 2005-03-21
7
Medium Priority
?
397 Views
Last Modified: 2013-12-24
I've built a custom app for a client that has product import/export features.  The client can export a tab-delimited text file, .. import the file into excel, ... make changes, .. re-save, ... and then re-import the file into the database.

I am first retrieving the data from the uploaded tab-delimited text file using CFHTTP:

<CFHTTP URL="http://ww.mywebsiteurl.com/uploads/#FORM.the_filename#" METHOD="GET" NAME="MyQuery" DELIMITER="      " TEXTQUALIFIER=""></CFHTTP>

I then either insert a new record, or update an existing one, .. depending on whether or not the specfic product code already exists in the database.  

The problem that I'm having is that whenever the client includes the degrees symbol ( ie: ° ) in the file to be re-imported, .. the symbol is for whatever reason being converted to some other character ( ie: ý ) .  

Why is this happening, and how can it be corrected?  I suspect that the problem is with CFHTTP's inability to properly decipher the degrees symbol using the GET method, since I have a simple "modify products" section in the app's  adminsitration website which retains the degrees symbol without any problems when I modify a product description.  But I'm not sure how to confirm this just yet.  Anyone know what might be going on?

Thanks in advance,
 - yvan

0
Comment
Question by:IDEASDesign
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 7

Expert Comment

by:black0ps
ID: 13592758
Do you have the ability to make modify the text file before cfhttp gets it? If you can, try and parse the file and do a replace for that degree symbol. Replace it with either &deg; or %C2%B0. I have problems with characters when the charset isn't encoded properly. You might want to try UTF-8 or ISO. (switch it up)

-- Ian
0
 

Author Comment

by:IDEASDesign
ID: 13593852
Actually, I was able to resolve the problem by adding  charset="iso-8859-1" to the CFHTTP tag.  I'd already tried the approach you suggested (thank you) - but as it turned out, it was an issue relating to the character encoding.

- yvan



0
 

Author Comment

by:IDEASDesign
ID: 13601070
How do I delete this question, considering that I've already found a solution on my own?

- yvan

0
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 
LVL 7

Expert Comment

by:black0ps
ID: 13602061
Make a post in the help forum with a link to this topic.
0
 

Author Comment

by:IDEASDesign
ID: 13602264
Okay.  And where exactly is the "help" forum?

- yvan
0
 
LVL 7

Expert Comment

by:black0ps
ID: 13603314
0
 
LVL 2

Accepted Solution

by:
Lunchy earned 0 total points
ID: 13607043
Closed, 125 points refunded.
Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month10 days, 18 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question