Unwanted Unicode text after form input
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?
[287 byte] By [
KTULKevin] at [2007-11-18 3:03:22]

# 1 Re: Unwanted Unicode text after form input
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?
# 2 Re: Unwanted Unicode text after form input
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.