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
" 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,