I currently run a site that uses English, French, German, Italian & Spanish. The collation setting that I use, for the applicable columns, is 'Modern_Spanish_CI_AI', everything else uses the database default. This has so far covered all of my problems that I encountered whilst performing searches, i.e. making sure that a search for '%sire' returns both 'Desire' and 'Desiré', treating the 'e' and 'é' the same. I do not think that you will have to use different encoding for every language, as I said the above encoding works for my 5 languages, but you may have to use different ones for Chinese characters, I am not sure as I have never explored storing that language in the database. I found this link gave me a clearer understanding,
http://www.itworld.com/AppDev/136/ITW3856/ Type 'SQL 2000 Collation' in Google. There is tons of info about SQL 2000 collation settings, including the pitfalls which you must be aware of to try and avoid issues later on!. I am sorry I can't be of more help but I think it should be a straight forward issue to resolve for you. :-) -----Original Message----- From: Duncan [mailto:[EMAIL PROTECTED] Sent: 04 October 2005 10:28 To: CF-Talk Subject: Re: i18n problem - utf-8 chars not displaying correctly 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:219996 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
