Localizing database causes data redundancy - Usage - Three simple steps to localize - Technical Support (You need to be registered at the forum to write) - Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ...

Support forum of the software localization tool Sisulizer

Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ... Home

Get in contact with the makers of Sisulizer.
Our forum is open for all questions around Sisulizer from customers and prospects.
Don't hesitate to register and ask. The Sisulizer team will answer ASAP.

Not logged in - Login | Register

Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ... > Technical Support (You need to be registered at the forum to write) > Usage - Three simple steps to localize > Localizing database causes data redundancy

Moderated by: Renate.Reinartz, Markus.Kreisel, Jaakko.Salmenius, Ilkka.Salmenius

New Topic

Printer Friendly

Localizing database causes data redundancy - Usage - Three simple steps to localize - Technical Support (You need to be registered at the forum to write) - Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ...

Author

Post

Posted: Sat Sep 15th, 2007 07:38 am

Quote

MagicFX
Member

Joined:	Sat Dec 23rd, 2006
Location:	Taipei, Taiwan
Posts:	150
Status:	Offline

Adding language field as a primary key yeilds MySQLdatabase partial dependency, violating Second Nrormal Form.

How could I prevent this problem?I don't wanna redesign the structure of my database.

Quote

Posted: Mon Sep 17th, 2007 05:16 am

Quote

Jaakko.Salmenius
Administrator

Joined:	Sat Apr 8th, 2006
Location:	Tokyo, Japan
Posts:	1641
Status:	Offline

If you combine the language field into your current primary key it should work. What is your current primary key?

You can also use Field localization. See Database localization from online help and see <sldir>DatabaseField sample. Hwever this also requires modifying the database structure. There is no way you can localize single language database without changing the database structure.

Jaakko

____________________
http://www.sisulizer.com - Three simple steps to localize

Quote

Current time is 01:42 am
Localization Tool for VB, Delphi, .NET, C#, VB.NET, XML, Online Help, HTML ... > Technical Support (You need to be registered at the forum to write) > Usage - Three simple steps to localize > Localizing database causes data redundancy

Sisulizer software localization tool - Three simple steps to localize