Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Localize It! (L...  Alphabetical sorting in database to support multi-lingual DNN sites
Previous Previous
 
Next Next
New Post 4/21/2008 6:33 AM
Unresolved
User is offline deepa
6 posts
10th Ranked


Alphabetical sorting in database to support multi-lingual DNN sites 

Hi,

I am using DNN v4.5.0 and Sql Server 2005 and need my site to support localization. SInce we are going to have many languages to support, i wanted to know as to how the sorting of the content in the database would be done? Should we use COLLATE functionality for the alphabetical sorting of data? Or is it something which can be done from DNN side?

Please do let me know your views on this.

Thanx in advance.
 
New Post 4/21/2008 10:09 AM
User is offline Sebastian Leupold
13747 posts
www.deutschnetnuke.de
1st Ranked












Re: Alphabetical sorting in database to support multi-lingual DNN sites 

do not touch collation, since sorting is usually performed by business logic instead of database and you will experience problems, if you use other than default collation.

Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 4/22/2008 7:40 AM
User is offline deepa
6 posts
10th Ranked


Re: Alphabetical sorting in database to support multi-lingual DNN sites 

I had forgotten to mention that we are using "nvarchar" in the language fields. So in that case are you saying that a simple order by of that column will return the necessary alphabetical sorted order?

Please elaborate on this point.

Thanx.
 
New Post 4/22/2008 9:40 AM
User is offline Sebastian Leupold
13747 posts
www.deutschnetnuke.de
1st Ranked












Re: Alphabetical sorting in database to support multi-lingual DNN sites 

the field to store the language key in, can be either nVarchar or varchar, since AFAIK it does not allow non-ASCII characters.

Sorting is usually done by the business logic,using sort specifications from UI locale, and not by database.

 

Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 4/24/2008 3:51 AM
User is offline deepa
6 posts
10th Ranked


Re: Alphabetical sorting in database to support multi-lingual DNN sites 

Can you give me some tips on how this can be achieved? Is it using the CultureInfo class of namespace "System.globalization"? and the "SortKey" class??

If possible, can you forward links where this is explained in detail.

Thanx in advance.

 
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Localize It! (L...  Alphabetical sorting in database to support multi-lingual DNN sites
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DotNetNuke Modules, Skins, Training and Consulting
If you want DotNetNuke done right then look no further. Developed Solutions provides module development, skin design, user and developer training and consulting. Based in Adelaide, Australia, we offer our services worldwide.
www.developedsolutions.com.au 		Venexus, Inc.
Need custom a custom DotNetNuke module? From module planning to deployment, including training and support, Venexus developers deliver end-to-end web solutions on time and on budget.
www.venexus.com 		Bring2mind
Document Centric DNN Module Solutions
www.bring2mind.net

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP