> >>The utf-8 characters store properly in the database
>
> UTF-8 or Unicode?

The data is UTF-8 (sorry for the misnamed subject).

The cf code and the php code do the same thing:

set var1=utf8 thai string
set var2=utf8 ukraine string

display var1, var2 to screen (cf5, php both work)

insert into mysql db
select from mysql db

display selection to screen (cf5 doesnt work,php does)

display var1,var2 to screen (cf5, php both work)

The database is declared as innodb charset=utf8 and the column is blob. When I tried column type varchar, both php and cf displayed squares. With it set to blob, php works properly and cf displays as hex values (eg. 556B72... which are the correct hex values, just should be displayed as UTF-8, not hex).

It seems like the cf should work, somehow it is getting confused about the type.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to