Verification of Field Limits

[Ritesh]

Hello

SQLyog does not check for these errors. It will only give error if MySQL returns an error. By default MySQL truncates data whereever necessary.

It is the job of the end-user ( in this case the user of SQLyog to see that they dont give data more then what is required ) 😀

We do plan some simple verification in future releases of SQLyog but as of now you have to make sure that you dont give any unwanted data

HTH

[CalEvans]

Sunjomar,

I would suggest that if this is important to you, you design an interface to your database in a program that will allow you to do this. I do this in PHP however, I have used Visual FoxPro to interface with MySQL on rare occasions and I've been told that Access can do this. If your database is primarily accessed over the Internet then I would suggest building your user management interface in the same language/script that you developed your web pages in. It is, however, up to you, the developer, to enforce data validation. MySQL or any database engine will simply allow you to build the constraints and then fail gracefully if your users submit data that does not meet those constraints.

As Ritesh said, it is not the place of SQLyog to do this. Programs like Lotus Approach and M$ Access do this by mixing a database front-end with the back-end engine. While this makes for simple programming it makes it very difficult (as you are finding) to migrate these programs and your skills to a true database engine.

SQLyog is a development tool and not a end-user tool for the most part. It and programs like it are designed to allow developers to manipulate data and DDL easily without having to code their programs in a language. However, once you move outside of the realm of developers it quickly becomes useless or worse, dangerous.

HTH,

=C=

[Author]

Posts