Duncan wrote: >> 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. > So do we even need to change SQL server from its default encoding > (sql_latin_1_general_cp1_ci_as)?
that's a collation. does that sort norwegian properly? if so, then leave it alone. if not, there are a couple of norwegian collations in sql server 2k: "Danish_Norwegian_CS_AS Danish/Norwegian case-sensitive sort order for code page 1252" & "SQL_Danish_Pref_Cp1_CI_AS (Danish/Norwegian dictionary order, case-insensitive, uppercase preference, for use with 1252 character set)". > What are the implications of using N in our CF queries? What is it > that we must change to do it without the N thing? my use of "N" refers to the "N" datatypes: Nvarchar, Nchar & Ntext for use w/unicode data. if you want to use plain varchar, etc. datatypes i'd guess pick an encoding/code page that supports norwegian BUT that kind of dead-ends the app when you need to add other languages that might not be supported by that encoding. you'd also need to make all your cf pages use that encoding. if you're referring to unicode hinting in sql, INSERT someTable (someNDataTypeColumn) VALUES(N'this text is unicode') you can use cfqueryparam & turn on the unicode option for that DSN (via advanced menu). btw all the sql stuff is in sql server's books-on-line (BoL). great reference. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:227321 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