Have you looked at your data using another db management tool? My own limited experience of dealing with UTF8 with LC 7 and sqlite is that if I don't textEncode(data,"utf8") into SQLite and textDecode(data,"utf8") out of the db, then although all the data goes and comes back OK, if I look at the db with another program the data isn't the same - most likely any characters that are suppose to have an umlat or similar are instead displayed with a blank space next to them. Conversley if I take some other db that already contains UTF8 data with the characters appearing correctly in another program and just read them straight into LC, then I get scrambled characters.
So if I want the charcters to appear correctly in everything, I need to textEncode() and textDecode(). This is purely for UTF8. Not sure how Mac Roman effects the issue. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
