Re: database collate for site that has to support multiple languages

2006-08-30 Thread Paul Hastings
Victor Moore wrote: > probably I will go with SQL_Latin1_General_CP850_CI_AS which is not knowing your data, can't say if this good or bad. test before you leap. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

Re: database collate for site that has to support multiple languages

2006-08-30 Thread Victor Moore
Thanks Paul, I got 93 results. probably I will go with SQL_Latin1_General_CP850_CI_AS which is Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 42 on Code Page 850 for non-Unicode Data Regards Victor On 8/29/06, P

Re: database collate for site that has to support multiple languages

2006-08-29 Thread Paul Hastings
Victor Moore wrote: > Sorry, I should have mentioned that the db is MS-SQL Server 2005. > I thought about Unicode but there is no entry in the drop down with that > name. i'm not up to speed on sql 2005 quite yet but try this: SELECT * FROM ::fn_helpcollations() WHERE description LIKE '%unicode%'

Re: database collate for site that has to support multiple languages

2006-08-26 Thread Victor Moore
Hi Paul, Sorry, I should have mentioned that the db is MS-SQL Server 2005. I thought about Unicode but there is no entry in the drop down with that name. There are probably one hundred entries so I wasn't sure which one to select for my case where in the same db I can have multiple languages at t

Re: database collate for site that has to support multiple languages

2006-08-25 Thread Paul Hastings
Victor Moore wrote: > What is the best collate for a site database that has to support multiple > languages simultaneously, including double byte: Chinese, Korean, Japanese. i imagine that depends on the db, but if you're storing what you refer to as "double byte" data in the same table, then of

database collate for site that has to support multiple languages

2006-08-25 Thread Victor Moore
Hi, What is the best collate for a site database that has to support multiple languages simultaneously, including double byte: Chinese, Korean, Japanese. Thanks Victor ~| Introducing the Fusion Authority Quarterly Update. 80 pa