ASCII bug?

[tim_993]

mysql
field.test="St. Patrick’s Day "
------------------------
form.cfm:

<cfquery name="getfield" datasource="database">
select field from test limit 1
</cfquery>
<cfoutput query="getfield">
<cfset value=field>
</cfoutput>

<form method="post" action="save.cfm">
<cfoutput><input type="text" name="field" value="#value#"></cfoutput>
<input type="submit" value="Save">
</form>

-------------------------------

save.cfm:
<cfoutput>
#field#
</cfoutput>

------------

outputs:
St. Patrick?s Day

with quote being ASCII 8217 . If I insert that into mysql, mysql converts it
to a space.


:confused;

[vkunirs]

Hi

use PreserveSingleQuotes when inserting the data into the table

[tim_993]

&#146 is the html code for right single quote (hex 92). the html equivelent of microsofts smart right single quote

[tim_993]

err, not sure where my last post went...


PreserveSingleQuotes does not fix the problem

[paross1]

This is probably related to the fact that the character that you are attempting
to use is not an ASCII character, but extended ASCII. I'm sure that the driver
that you are using between CF and MySQL doesn't "understand" what this
character is, as its value is beyond ASCII, so it is making a substitution. I
found a bug note on the MySQL site that you may want to take look at.

[url]http://bugs.mysql.com/bug.php?id=7756[/url]

Phil

[tim_993]

Adding:
useUnicode=true&characterEncoding=Cp1250

to the connection string seemed to fix the problem.