> >>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]
- unicode with cf5 and mysql dan martin
- Re: unicode with cf5 and mysql Barney Boisvert
- Re: unicode with cf5 and mysql dan martin
- Re: unicode with cf5 and mysql Paul Hastings
- Re: unicode with cf5 and mysql Paul Hastings
- Re: unicode with cf5 and mysql dan martin
- Re: unicode with cf5 and mysql Paul Hastings
- Re: unicode with cf5 and mysql Claude Schneegans
- Re: unicode with cf5 and mysql Jochem van Dieten
- Re: unicode with cf5 and mysql dan martin
- Re: unicode with cf5 and mysql dan martin
- Re: unicode with cf5 and mysql Jochem van Dieten
- Re: unicode with cf5 and mysql dan martin
- Re: unicode with cf5 and mysql Jochem van Dieten