Duncan wrote: >> Sorry, all our multilingual stuff runs exclusively on MX6. > > yes but what encoding are you actually using? >> how do you tell? SQLServer is not in UTF-8 - I am working on
if you're using "N" datatypes it internally uses ucs2, when it talks to sql server it's utf-8 unless you tell it otherwise. >> getting a fresh install so we can change this over. we are using >> nvarchar at the moment. The email is coming out ok, so I guess that >> its to do with the client. yes, nvarchar is the right datatype if you're going to be using unicode. >> version of what? Hotmail?? Where can I find a list of encodings and >> what they relate to? the hotmail that you connect to (connecting from thailand it swaps encoding per the email). http://www.cs.tut.fi/~jkorpela/chars/ http://www.w3.org/International/O-charset.html > to [EMAIL PROTECTED] >> on its way. got it. thanks. not that i read norwegian but it "looks ok" in utf-8. turns to what looks like mojibake using any other encoding. could just be a client issue....interesting, when i went to forward that, hotmail swapped to iso-8859-1 even though i have my browser (ff 1.5) manually set to utf-8. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
