[ic] UTF-8 in table_editor

Bill Carr bill at worldwideimpact.com
Tue Jun 26 18:02:00 EDT 2007

On Jun 26, 2007, at 3:55 PM, docelic wrote:

> On Tue, Jun 26, 2007 at 02:51:31PM -0400, Bill Carr wrote:
>> I am having difficulties with UTF-8 data in the table_editor. I am
>> using MySQL for my data store. I am able to insert UTF-8 data using
>> the table_editor and it appears correct in MySQL command line. If I
>> output the data in a text input box as below it appears correct.
>> 	<input value="[data mytable mycol mykey]">
>> but using table_editor:
>> 	[table_editor
>> 		table=mytable
>> 		item_id=mykey
>> 	]
>> the value in mycol field looks funky.
>> In Vend::Form.pm there's a line like so:
>> 	$opt->{encoded} = encode($opt->{value}, $ESCAPE_CHARS::std);
>> if I comment that line and replace with:
>> 	$opt->{encoded} = $opt->{value};
>> table_editor outputs good looking data for mycol.
>> Any ideas of how to make table_editor work better with my UTF-8 data?
> Hi Bill,
> you were on the right track. Just add "\X" to $ESCAPE_CHARS::std
> and that will solve the problem.
> This is already done in Interchange CVS head.
Hi doc,

Thanks for the help but I still can't get it to work. I am I supposed  
to be adding "\X" to $ESCAPE_CHARS::std in Util.pm? Do you know  
exactly what $ESCAPE_CHARS::std should be set to?

Thanks again,

More information about the interchange-users mailing list