I thought char and varchar columns would only allow the 255 ASCII values and would not allow Unicode. SQL Server 2000 seems to let me insert Unicode into these columns without any problems.
For example, when I insert the two sets of MS Word smart quotes, separated by a space, into a varchar(5) column, the smart quotes get inserted just fine. I am performing the inserts and retrievals using CFMX 6.1. Smart quotes: "" '' Unicode values: (8220)(8221)(32)(8216)(8217) Where am I wrong in my understanding of char and varchar columns? Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197302 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
