[V4MD] Case insensitive search // Valentina SQL compare to who?

[Ruslan Zasukhin]

On 10/4/08 3:23 PM, "william humphrey" <shoreagent at gmail.com> wrote:

Hi William,

> I have also read this list with similar questions and answers but I noticed
> that no one mentioned that you can use LIKE '%nametosearch%' and it is case
> insensitive is SQLlite databases but that is not true in Valentina which
> might be why this question keeps coming up. Perhaps there is a reason for
> this?

Reason is that on default it is case-sensitive in Valentina,
And sometimes people cannot find info how to make it case-insensitive

Once again, this is page about all issues related to String fields:

<http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:docume
ntation:vkernel:vfield:string_fields>


------------
> On another note. When you are studying SQL in various books they compare the
> differences between MySQL, SQLite, and a couple of other older more
> expensive SQL databases. I realize that Valentina uses a SQL standard (I
> forgot the number) but what I really want to know is which common SQL
> database is Valentina most similar to if you were to want to buy a book on
> it and study?

* Valentina follow to SQL Standard.

* We support practically completely SQL 92

* We support some things from SQL99, e.g. Triggers

* We support even less things from SQL 2003.
    One of them operator->

* And we have own Valentina extensions.
    Some of them was catch watching on mySQL,
    Some are our unique.

-----
We self know that the most following to SQL Standard is MS SQL.
Who could to think? :-)

So if compare to others, you can read any GENERAL SQL book.

You can find in mySQL docs some Valentina Ext commands, but we not follow
them strictly. E.g. Idea of Backups and Events we have implement in more
nice way. We do not have for SHOW commands suffix LIKE to filter records,
instead we support much more intuitive form as
  SELECT ... FROM ( SHOW ... )



As for me I very like book

-----------------------------------
    SQL 
    Complete Reference

    James R. Groff, Paul N Weinberg

    Third Edition
----------------


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]