Stas, Seems to me your local mechine doesn't have the East Asian Languages' package installed, so the mechine only displays blocks for japanese characters .
If you are using MSSQL 2000/2005 and setup the propery collation, the data (japanese characters) in the table should be fine. You can test it by pulling the data out and displaying in html, please make sure to use <cfprocessingdirective pageencoding="utf-8"> In the coldfusion display page. Hua -----Original Message----- From: Stas Newdel [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 1:30 PM To: CF-Talk Subject: Japanese text I am managing an ecommerce app and we are attempting to add Japanese text descriptions for the products. Currently, I am just doing a test of concept type of thing. I added another table that has an FK to products as well as the alternative description column. Our Japanese partner has supplied us with an Excel file containing descriptions in katakana which view fine in Excel. I set the description column's type to nvarchar and set its collation to be Japanese_BIN, however, when I try to paste the Japanese text into it, only some of the Roman characters are visible (as the the descriptions have things like "100% cotton"), but the Japanese characters are displayed as blocks. Could someone point me in the right directions? Thanks, Stas ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238539 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
