Disk space is cheap. If there is ever a chance that you'll need other characters embedded in text sometime in the future, then it pays to sacrifice the extra space and use the N data types now.
--- Ben -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 4:22 PM To: CF-Talk Subject: RE: SQL Question? I believe so... -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 4:03 PM To: CF-Talk Subject: RE: SQL Question? Ok, so if my data will only be supporting the English language I should just use varhcar or char since n uses 2 bytes for one character. Correct? Doug -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 1:58 PM To: CF-Talk Subject: RE: SQL Question? I've always read that you use nvarchar for multilingual data. Keep in mind, nvarchar takes up twice as much space in the db since it makes an alotment for languages that have extended characters. ~C -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 3:48 PM To: CF-Talk Subject: SQL Question? I understand several things about SQL when it comes to getting information out of it, but never really have understood which data types to use for what specific data. I know what ones suppose to hold what kind of data as far as integer data, character data, monetary data, data and time data, binary strings, and so on. I am mostly confused with n(varchar) or (n)char. I know that varchar is for using Non-Unicode data and nvarchar is for Unicode that is of varying length, but when would I use each? Hope I make a little sense. Doug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
