mike pop wrote: > using cf8 and either mysql server or microsoft sql server 2008 express (both > give me the same result), i am attempting to insert/update records containing > japanese text.
and how are the columns holding the text defined? what db driver are you using? > the japanese text doesn't insert into the database, only ?? (questions marks > get inserted) question marks mean the data is garbaged by a fatal encoding flaw. boxes mean a less tragic encoding error where the whatever can't render that char using the current font. > I've checked the collation levels for microsoft sql server 2008 express. > There's 2 ways to assign collation on a column; either SQL collation or > Windows collation. irrelevant for this issue. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
