>>
>> 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
>
>> It seems like the cf should work
>
>No, it shouldn't. CF5 does not support unicode. MySQL does not
>support unicode. PHP barely supports unicode (it really doesn't
>unless you are already on 5, but since it is treating the strings
>as opaque it is hard to notice it is not working). Since some of
>them are broken in the same way you might mistake some
>combinations for a working system, but it really is not.
>
>If you want unicode (in whichever representation), you need CF MX
>and a database that supports it.
>
>Jochem
The mysql+php does work. It may not handle searches as someone else mentioned, but that is not a requirement (I just need to be able to store and retreive and display, no sorting/searching on the utf8 columns). I was hoping to get the cf5 to work since it appears to work correctly sometimes. But if not, then I will continue with the php variant of the code.
Can you explain/expand upon what you mean by "some of them are broken in the same way"?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
