CF is simply displaying whats in the database, which means the symbol
"conversion" occurred between the source file and sequel server 2K. Our DBA
pointed us to windows collation designators. Interesting. Still
investigating.
CC
BillyC
@BaylorHealth To: CF-Talk <[EMAIL PROTECTED]>
.edu cc:
Subject: RE: British Pound symbol in a
.txt upload file
04/30/02
03:07 PM
Please
respond to
cf-talk
Verify that ASCII character code of the symbol in question ( you can
load the file with a scripting language like cf or vbscript, and use a
function like asc() )
---
Billy Cravens
Web and Software Consulting
www.Architechx.com
-----Original Message-----
From: Casey C Cook [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 2:56 PM
To: CF-Talk
Subject: British Pound symbol in a .txt upload file
Hello -
We have a UK client uploading a .txt (comma separated) file to a varchar
100 field in our database. The piece of data their trying to upload
includes a British Pound symbol and when the user is viewing a report to
check their data, the symbol has been replaced by the letter "u" with a
"tick" over it. Has anyone heard of such a thing?
Casey Cook
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
