Re: Any SQL3 DBMS ?

On Apr 20, 8:45 am, Timothy Madden <terminato...@xxxxxxxxx> wrote:
Lennart wrote:
On 19 Apr, 23:15, Timothy Madden <terminato...@xxxxxxxxx> wrote:
Hello

I am trying to learn standard SQL 99 (SQL3), but it is not very fun to
do when I have no RDBMS that implements it to play with :(.

Is there a newsgroup that discusses standard SQL ?

Not that I'm aware of. Troels Arvin has a page where he compares
different implementations that you might find interest in:

http://troels.arvin.dk/db/rdbms/

What DBMS would implement most (or at least enough) of the SQL-99 ?

I would guess on the following three: DB2, MsSQL and Oracle. I believe
you can download all of them for free.

What free or open-source DBMS would implement most of the SQL-99 ?

Guessing again, Postgres

/Lennart

Thank you.

I already got DB2, Oracle XE and Postgres. I am surprized to see that

    SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS;

returns an error in all 3 of them ! :)
Actually DB2 and Oracle seem to have no INFORMATION_SCHEMA at all !

mysql> SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS;
+--------------------+----------------------
+-----------------------------+--------+
| CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME |
DESCRIPTION | MAXLEN |
+--------------------+----------------------
+-----------------------------+--------+
| big5 | big5_chinese_ci | Big5 Traditional
Chinese | 2 |
| dec8 | dec8_swedish_ci | DEC West
European | 1 |
| cp850 | cp850_general_ci | DOS West
European | 1 |
| hp8 | hp8_english_ci | HP West
European | 1 |
| koi8r | koi8r_general_ci | KOI8-R Relcom
Russian | 1 |
| latin1 | latin1_swedish_ci | cp1252 West
European | 1 |
| latin2 | latin2_general_ci | ISO 8859-2 Central
European | 1 |
| swe7 | swe7_swedish_ci | 7bit
Swedish | 1 |
| ascii | ascii_general_ci | US
ASCII | 1 |
| ujis | ujis_japanese_ci | EUC-JP
Japanese | 3 |
| sjis | sjis_japanese_ci | Shift-JIS
Japanese | 2 |
| hebrew | hebrew_general_ci | ISO 8859-8
Hebrew | 1 |
| tis620 | tis620_thai_ci | TIS620
Thai | 1 |
| euckr | euckr_korean_ci | EUC-KR
Korean | 2 |
| koi8u | koi8u_general_ci | KOI8-U
Ukrainian | 1 |
| gb2312 | gb2312_chinese_ci | GB2312 Simplified
Chinese | 2 |
| greek | greek_general_ci | ISO 8859-7
Greek | 1 |
| cp1250 | cp1250_general_ci | Windows Central
European | 1 |
| gbk | gbk_chinese_ci | GBK Simplified
Chinese | 2 |
| latin5 | latin5_turkish_ci | ISO 8859-9
Turkish | 1 |
| armscii8 | armscii8_general_ci | ARMSCII-8
Armenian | 1 |
| utf8 | utf8_general_ci | UTF-8
Unicode | 3 |
| ucs2 | ucs2_general_ci | UCS-2
Unicode | 2 |
| cp866 | cp866_general_ci | DOS
Russian | 1 |
| keybcs2 | keybcs2_general_ci | DOS Kamenicky Czech-
Slovak | 1 |
| macce | macce_general_ci | Mac Central
European | 1 |
| macroman | macroman_general_ci | Mac West
European | 1 |
| cp852 | cp852_general_ci | DOS Central
European | 1 |
| latin7 | latin7_general_ci | ISO 8859-13
Baltic | 1 |
| cp1251 | cp1251_general_ci | Windows
Cyrillic | 1 |
| cp1256 | cp1256_general_ci | Windows
Arabic | 1 |
| cp1257 | cp1257_general_ci | Windows
Baltic | 1 |
| binary | binary | Binary pseudo
charset | 1 |
| geostd8 | geostd8_general_ci | GEOSTD8
Georgian | 1 |
| cp932 | cp932_japanese_ci | SJIS for Windows
Japanese | 2 |
| eucjpms | eucjpms_japanese_ci | UJIS for Windows
Japanese | 3 |
+--------------------+----------------------
+-----------------------------+--------+
36 rows in set (0.01 sec)


Timothy Madden

.

Relevant Pages

  • Re: Kling of KKKrap
    ... Other Mongol tribes ended in Northern ... >> from four populations with African, Asian, and European ancestry. ... >>similarities between Chinese and Japanese and differences between ... >>Chinese and Japanese and the one hand and Africans on the other, ...
    (sci.anthropology)
  • Re: 1st Mainstream Interracial Marriage & Child?
    ... Chinese and Japanese would be from the same "race" - in fact, ... happen to be of white European descent and just happen to have the ...
    (rec.arts.comics.dc.universe)
  • Re: And yet more shiao jiao clips
    ... Japanese archipelago were Malay-Polynesian folks. ... Yamato people who were probably Turkish horse culture. ... The peak of Chinese influence was in the Nara period, ... In the Tokugawa period, there was an endless fascination with Chinese ...
    (rec.martial-arts)
  • Re: What kind of "nationalism" would that be? Korean style?
    ... China should research the anti-Chinese propaganda Corea was fed during ... Chinese Propaganda ... Click here to see how a Japanese wartime propaganda film, ...
    (soc.culture.china)
  • Wartime Chinese Laborers Sue Japan for Compensation
    ... Wartime Chinese Laborers Sue Japan for Compensation ... rake and a vise made them call out the Japanese names for the antiquated tools. ... As evidence of Japan?s wartime use of forced labor has emerged in recent years, ...
    (soc.culture.malaysia)