>I posted here so maybe it can help us to update the sql conformance
> page http://www.firebirdsql.org/en/sql-conformance/
>
> Sorry for cross posting so much , maybe i was over to much coffeine
> also i didn't had the time to explain what is with the link
>
> ps: he is not quite a random guy on the internet but a quite biased at the end
> Software Architect at MySQL/Sun/Oracle from 2003-2011, and at HP for a
> little while after that.
> http://www.linkedin.com/pub/peter-gulutzan/b/28/761
Well, you're convinced me and i've read that comparison (using google
cache) :)
I should note that some statements is very questionable (at least):
a) F531 Temporary tables
Firebird doesn't have this.
This not true - Firebird have standard GLOBAL TEMPORARY TABLES
b) T021 BINARY and VARBINARY data types
Firebird doesn't have this.
Firebird have [VAR]CHAR CHARACTER SET OCTETS data type which is exactly
the same as [VAR]BINARY, AFAIU.
c) F461 Named character sets
Note #1: Re character sets: Ignoring duplicates, alias names, and slight
variations:
Firebird multi-byte character sets are gbk, sjis , utf-8, gb18030
Here i'm not certain, probably Adriano have what to add
d) F690 Collation support
Note #2: Re collations: Although Firebird deserves special mention for
supporting a slightly
later version of the Unicode Collation Algorithm , the only character set for
which Firebird
has multiple collations is UTF-8
Hmm... For example, ISO8859_1 have 18 collations - according to fbintl.conf:
<charset ISO8859_1>
intl_module fbintl
collation ISO8859_1
collation ISO8859_1_UNICODE
collation DA_DA
collation DE_DE
collation DU_NL
collation EN_UK
collation EN_US
collation ES_ES
collation ES_ES_CI_AI
collation FI_FI
collation FR_CA
collation FR_FR
collation IS_IS
collation IT_IT
collation NO_NO
collation SV_SV
collation PT_BR
collation PT_PT
</charset>
Am i wrong here ?
Regards,
Vlad
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
