Nice one Andy thats certainly an option. I suppose it would fit well to because we will be doing everything from French to Traditional Chinese, so I guess we would want chinese to use Big5 and an encoding relevant to that.
Having said that I thought UTF-8 would cover all possible characters due to its triple byte storage method? Would it be necessary to use individual encodings for each language? On 10/4/05, Andy McShane <[EMAIL PROTECTED]> wrote: > > 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> <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:219995 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
