In SQL2000 you can actually change the collation of individual columns within individual tables. I am not sure exactly which collation you would need but if you can open SQL enterprise manager, find the table that you are storing this data into, right-click on the table and select 'Design table'. Once the table is open in design mode, select the column that you wish to change the collation for and at the bottom of the design view the 'collation' box should become active. Click inside the collation box and a button should appear next it. Click this button to access a list of available collations. You will have to look in BOL to check which collation type is suitable for which character sets but that is how easy in SQL2000 it is to change collation. Hope this helps!
P.S different collation types on table columns can cause errors when using those columns in a table join. -----Original Message----- From: Duncan [mailto:[EMAIL PROTECTED] Sent: 04 October 2005 10:03 To: CF-Talk Subject: i18n problem - utf-8 chars not displaying correctly We are converting our site to 16 different languages and are having problems with a few odd characters. The only way we can get the chars to display correctly is by entering them in to SQL Server 2000 using th N'string in here' notation. But that means you cant do a select * from x where lang like '%dodgy char here%' on the field. An example with this would be Hungarian megfelelő megfelelő is inserted as megfelelo, however on doing select hungarian from languages where hungarian like '%megfelelő%' we can match the word. If we enter it as( using the N' notation ) N'A megadott kritériumok alapján nem találtunk megfelelő' we cant match on it however it displays correctly on web pages. We would like to not use the N' notation - how can this be acheived? the db collation is SQL_Latin_General at the moment - I have a bad feeling this is the problem and its not easy to change? the page encoding is set in cf with utf-8 - but I am at a loss to other ideas. Any help greatly appreciated -- Duncan I Loxton www.sixfive.co.uk <http://www.sixfive.co.uk> [EMAIL PROTECTED] "I can only please one person per day. Today is not looking good. Tomorrow isn't looking much better." Dilbert ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219994 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
