Click to See Complete Forum and Search --> : Unwanted Unicode text after form input


KTULKevin
March 1st, 2003, 09:11 PM
I'm inputting information into a database using a text input form and everything works except when I view the information in the database, I have "ᆲ■tᅱ" before the information I want to display. What is this and how do I go about keeping it out of my database?

antares686
March 3rd, 2003, 05:25 AM
What is the front end (Access, ASP, etc), what type of DB are we talkin about and what is the column definition that is an issue?

KTULKevin
March 3rd, 2003, 11:14 AM
I'm using ColdFusion scripting and MySQL databases. The column definition is varchar(255). My code looks like this:

<!--BEGIN COUNTY INPUT--!>
<cfform method="post" action="countyinput.cfm">
<cfinput type="text" name="county" size="60" required="yes">
<input type="submit" value="SUBMIT">
</cfform>
<!--END COUNTY INPUT--!>

Then, on the database insert:

<cfinsert datasource="news" tablename="counties">
<cflocation url="counties.cfm">

Thanks for any help you can give. This is driving me nuts. I've never had this type of problem before.