>properly in cf-5?
>
>it never will properly. i could get text into/out of a db (sql server) as
>utf-8 ok but no cf string functions will work with it--cf5 pretty much
>ignored char encodings & just used iso-8859-1. as far as i know production
>mysql doesn't work with unicode, so sorting, searching, etc. will be an
>issue.
>
>> I can display text in kanji and all the other languages fine, and can
>store them properly in the mysql database. When I display the data from the
>database in cf, they are displayed as squares.
>
>does "can store them properly " include sorting, searching, etc. working? if
>the text is displayed as squares, thats a matter of the browser not being
>able to render the char (vs "?" which means corrupted). are you using a font
>that understands utf-8?
>
>> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
>
>this helps in cf5.
>
>> I thought cf5 worked with unicode. Is it an ODBC issue? Any ideas?
>
>no, it never worked with unicode.
Thanks for the replies.
The utf-8 characters store properly in the database because I can retreive and display them properly using php. When I retreive them from cf5 they show the squares. Before I insert them, on the same page, cf5 *does* display utf-8 properly. It is only the retreived data (via cf5) that seems to mess up the encoding setting or something.
ps- my application does not require searching or sorting of utf-8 data, just inserting, displaying in the correct encoding.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
