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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219992 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
