[ic] UTF-8 in table_editor

Bill Carr bill at bottlenose-wine.com
Tue Jun 26 14:51:31 EDT 2007


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?


Bill Carr
Bottlenose - Wine & Spirits eBusiness Specialists
(877) 857-6700
http://www.bottlenose-wine.com


More information about the interchange-users mailing list