cvs: pear /Translation2/docs/examples Translation2_example.sql
| From: | Lorenzo Alberton | Date: | Sun, 07 Nov 2004 16:42:55 +0000 |
| Subject: | cvs: pear /Translation2/docs/examples Translation2_example.sql | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-25733@lists.php.net to get a copy of this message | ||
quipo Sun Nov 7 11:42:55 2004 EDT
Modified files:
/pear/Translation2/docs/examples Translation2_example.sql
Log:
the example was broken after an incomplete table re-definition (bug #2711). Thanks to ylf at xung
dot org
http://cvs.php.net/diff.php/pear/Translation2/docs/examples/Translation2_example.sql?r1=1.3&r2=1.4&ty=u Index: pear/Translation2/docs/examples/Translation2_example.sql diff -u pear/Translation2/docs/examples/Translation2_example.sql:1.3 pear/Translation2/docs/examples/Translation2_example.sql:1.4 --- pear/Translation2/docs/examples/Translation2_example.sql:1.3 Tue Nov 2 11:55:26 2004 +++ pear/Translation2/docs/examples/Translation2_example.sql Sun Nov 7 11:42:55 2004 @@ -8,36 +8,36 @@ it text ); -CREATE UNIQUE INDEX mytable_i18n_id_index ON mytable_i18n (id); +CREATE UNIQUE INDEX mytable_i18n_id_index ON mytable_i18n (id(16), page_id); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_01", "calendar", "january", NULL, NULL, NULL, "gennaio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_02", "calendar", "february", NULL, NULL, NULL, "febbraio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_03", "calendar", "march", NULL, NULL, NULL, "marzo"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_04", "calendar", "april", NULL, NULL, NULL, "aprile"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_05", "calendar", "may", NULL, NULL, NULL, "maggio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_06", "calendar", "june", NULL, NULL, NULL, "giugno"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_07", "calendar", "july", NULL, NULL, NULL, "luglio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_08", "calendar", "august", NULL, NULL, NULL, "agosto"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_09", "calendar", "september", NULL, NULL, NULL, "settembre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_10", "calendar", "october", NULL, NULL, NULL, "ottobre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_11", "calendar", "november", NULL, NULL, NULL, "novembre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_12", "calendar", "december", NULL, NULL, NULL, "dicembre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_0", "calendar", "sunday", NULL, NULL, NULL, "domenica"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_1", "calendar", "monday", NULL, NULL, NULL, "lunedì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_2", "calendar", "tuesday", NULL, NULL, NULL, "martedì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_3", "calendar", "wednesday", NULL, NULL, NULL, "mercoledì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_4", "calendar", "thursday", NULL, NULL, NULL, "giovedì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_5", "calendar", "friday", NULL, NULL, NULL, "venerdì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_6", "calendar", "saturday", NULL, NULL, NULL, "sabato"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("only_english", NULL, "only english text", NULL, NULL, NULL, NULL); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("only_italian", NULL, NULL, NULL, NULL, NULL, "testo solo in italiano"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("hello_user", NULL, "hello &&user&&, today is &&weekday&&, &&day&&th &&month&& &&year&&", NULL, NULL, NULL, "ciao, &&user&&, oggi è il &&day&& &&month&& &&year&& (&&weekday&&)"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("alone", "alone", "all alone", NULL, NULL, NULL, "solo soletto"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("isempty", NULL, NULL, "this string is empty in English and Italian, but not in German!", NULL, NULL, NULL); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("prova_conflitto", "in_page", "conflicting text - in page", NULL, NULL, NULL, "testo con conflitto - in page"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("prova_conflitto", NULL, "conflicting text - Global", NULL, NULL, NULL, "testo con conflitto - globale"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("pageid_vuoto", "", "string with empty pageID (i.e. NOT NULL)", NULL, NULL, NULL, "stringa con pageID vuoto ma non nullo"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("test", NULL, "this is a test string", NULL, NULL, NULL, "stringa di prova"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_01", "calendar", "january", NULL, NULL, NULL, "gennaio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_02", "calendar", "february", NULL, NULL, NULL, "febbraio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_03", "calendar", "march", NULL, NULL, NULL, "marzo"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_04", "calendar", "april", NULL, NULL, NULL, "aprile"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_05", "calendar", "may", NULL, NULL, NULL, "maggio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_06", "calendar", "june", NULL, NULL, NULL, "giugno"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_07", "calendar", "july", NULL, NULL, NULL, "luglio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_08", "calendar", "august", NULL, NULL, NULL, "agosto"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_09", "calendar", "september", NULL, NULL, NULL, "settembre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_10", "calendar", "october", NULL, NULL, NULL, "ottobre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_11", "calendar", "november", NULL, NULL, NULL, "novembre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_12", "calendar", "december", NULL, NULL, NULL, "dicembre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_0", "calendar", "sunday", NULL, NULL, NULL, "domenica"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_1", "calendar", "monday", NULL, NULL, NULL, "lunedì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_2", "calendar", "tuesday", NULL, NULL, NULL, "martedì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_3", "calendar", "wednesday", NULL, NULL, NULL, "mercoledì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_4", "calendar", "thursday", NULL, NULL, NULL, "giovedì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_5", "calendar", "friday", NULL, NULL, NULL, "venerdì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_6", "calendar", "saturday", NULL, NULL, NULL, "sabato"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("only_english", NULL, "only english text", NULL, NULL, NULL, NULL); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("only_italian", NULL, NULL, NULL, NULL, NULL, "testo solo in italiano"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("hello_user", NULL, "hello &&user&&, today is &&weekday&&, &&day&&th &&month&& &&year&&", NULL, NULL, NULL, "ciao, &&user&&, oggi è il &&day&& &&month&& &&year&& (&&weekday&&)"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("alone", "alone", "all alone", NULL, NULL, NULL, "solo soletto"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("isempty", NULL, NULL, "this string is empty in English and Italian, but not in German!", NULL, NULL, NULL); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("prova_conflitto", "in_page", "conflicting text - in page", NULL, NULL, NULL, "testo con conflitto - in page"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("prova_conflitto", NULL, "conflicting text - Global", NULL, NULL, NULL, "testo con conflitto - globale"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("page_id_vuoto", "", "string with empty page_id (i.e. NOT NULL)", NULL, NULL, NULL, "stringa con page_id vuoto ma non nullo"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("test", NULL, "this is a test string", NULL, NULL, NULL, "stringa di prova"); CREATE TABLE mytable_langs_avail ( @@ -51,6 +51,6 @@ CREATE UNIQUE INDEX mytable_langs_avail_id_index ON mytable_langs_avail (id); -INSERT INTO mytable_langs_avail (ID, name, meta, error_text, encoding) VALUES("en", "english", "my meta info", "not available", "iso-8859-1"); -INSERT INTO mytable_langs_avail (ID, name, meta, error_text, encoding) VALUES("de", "deutsch", "iso-8859-1", "kein Text auf Deutsch verfügbar", "iso-8859-1"); -INSERT INTO mytable_langs_avail (ID, name, meta, error_text, encoding) VALUES("it", "italiano", "charset=iso-8859-1", "non disponibile", "iso-8859-1"); +INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("en", "english", "my meta info", "not available", "iso-8859-1"); +INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("de", "deutsch", "iso-8859-1", "kein Text auf Deutsch verfügbar", "iso-8859-1"); +INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("it", "italiano", "charset=iso-8859-1", "non disponibile", "iso-8859-1");
http://cvs.php.net/diff.php/pear/Translation2/docs/examples/Translation2_example.sql?r1=1.3&r2=1.4&ty=u Index: pear/Translation2/docs/examples/Translation2_example.sql diff -u pear/Translation2/docs/examples/Translation2_example.sql:1.3 pear/Translation2/docs/examples/Translation2_example.sql:1.4 --- pear/Translation2/docs/examples/Translation2_example.sql:1.3 Tue Nov 2 11:55:26 2004 +++ pear/Translation2/docs/examples/Translation2_example.sql Sun Nov 7 11:42:55 2004 @@ -8,36 +8,36 @@ it text ); -CREATE UNIQUE INDEX mytable_i18n_id_index ON mytable_i18n (id); +CREATE UNIQUE INDEX mytable_i18n_id_index ON mytable_i18n (id(16), page_id); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_01", "calendar", "january", NULL, NULL, NULL, "gennaio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_02", "calendar", "february", NULL, NULL, NULL, "febbraio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_03", "calendar", "march", NULL, NULL, NULL, "marzo"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_04", "calendar", "april", NULL, NULL, NULL, "aprile"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_05", "calendar", "may", NULL, NULL, NULL, "maggio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_06", "calendar", "june", NULL, NULL, NULL, "giugno"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_07", "calendar", "july", NULL, NULL, NULL, "luglio"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_08", "calendar", "august", NULL, NULL, NULL, "agosto"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_09", "calendar", "september", NULL, NULL, NULL, "settembre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_10", "calendar", "october", NULL, NULL, NULL, "ottobre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_11", "calendar", "november", NULL, NULL, NULL, "novembre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("month_12", "calendar", "december", NULL, NULL, NULL, "dicembre"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_0", "calendar", "sunday", NULL, NULL, NULL, "domenica"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_1", "calendar", "monday", NULL, NULL, NULL, "lunedì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_2", "calendar", "tuesday", NULL, NULL, NULL, "martedì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_3", "calendar", "wednesday", NULL, NULL, NULL, "mercoledì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_4", "calendar", "thursday", NULL, NULL, NULL, "giovedì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_5", "calendar", "friday", NULL, NULL, NULL, "venerdì"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("day_6", "calendar", "saturday", NULL, NULL, NULL, "sabato"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("only_english", NULL, "only english text", NULL, NULL, NULL, NULL); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("only_italian", NULL, NULL, NULL, NULL, NULL, "testo solo in italiano"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("hello_user", NULL, "hello &&user&&, today is &&weekday&&, &&day&&th &&month&& &&year&&", NULL, NULL, NULL, "ciao, &&user&&, oggi è il &&day&& &&month&& &&year&& (&&weekday&&)"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("alone", "alone", "all alone", NULL, NULL, NULL, "solo soletto"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("isempty", NULL, NULL, "this string is empty in English and Italian, but not in German!", NULL, NULL, NULL); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("prova_conflitto", "in_page", "conflicting text - in page", NULL, NULL, NULL, "testo con conflitto - in page"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("prova_conflitto", NULL, "conflicting text - Global", NULL, NULL, NULL, "testo con conflitto - globale"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("pageid_vuoto", "", "string with empty pageID (i.e. NOT NULL)", NULL, NULL, NULL, "stringa con pageID vuoto ma non nullo"); -INSERT INTO mytable_i18n (ID, pageID, en, de, es, fr, it) VALUES("test", NULL, "this is a test string", NULL, NULL, NULL, "stringa di prova"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_01", "calendar", "january", NULL, NULL, NULL, "gennaio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_02", "calendar", "february", NULL, NULL, NULL, "febbraio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_03", "calendar", "march", NULL, NULL, NULL, "marzo"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_04", "calendar", "april", NULL, NULL, NULL, "aprile"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_05", "calendar", "may", NULL, NULL, NULL, "maggio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_06", "calendar", "june", NULL, NULL, NULL, "giugno"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_07", "calendar", "july", NULL, NULL, NULL, "luglio"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_08", "calendar", "august", NULL, NULL, NULL, "agosto"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_09", "calendar", "september", NULL, NULL, NULL, "settembre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_10", "calendar", "october", NULL, NULL, NULL, "ottobre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_11", "calendar", "november", NULL, NULL, NULL, "novembre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("month_12", "calendar", "december", NULL, NULL, NULL, "dicembre"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_0", "calendar", "sunday", NULL, NULL, NULL, "domenica"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_1", "calendar", "monday", NULL, NULL, NULL, "lunedì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_2", "calendar", "tuesday", NULL, NULL, NULL, "martedì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_3", "calendar", "wednesday", NULL, NULL, NULL, "mercoledì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_4", "calendar", "thursday", NULL, NULL, NULL, "giovedì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_5", "calendar", "friday", NULL, NULL, NULL, "venerdì"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("day_6", "calendar", "saturday", NULL, NULL, NULL, "sabato"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("only_english", NULL, "only english text", NULL, NULL, NULL, NULL); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("only_italian", NULL, NULL, NULL, NULL, NULL, "testo solo in italiano"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("hello_user", NULL, "hello &&user&&, today is &&weekday&&, &&day&&th &&month&& &&year&&", NULL, NULL, NULL, "ciao, &&user&&, oggi è il &&day&& &&month&& &&year&& (&&weekday&&)"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("alone", "alone", "all alone", NULL, NULL, NULL, "solo soletto"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("isempty", NULL, NULL, "this string is empty in English and Italian, but not in German!", NULL, NULL, NULL); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("prova_conflitto", "in_page", "conflicting text - in page", NULL, NULL, NULL, "testo con conflitto - in page"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("prova_conflitto", NULL, "conflicting text - Global", NULL, NULL, NULL, "testo con conflitto - globale"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("page_id_vuoto", "", "string with empty page_id (i.e. NOT NULL)", NULL, NULL, NULL, "stringa con page_id vuoto ma non nullo"); +INSERT INTO mytable_i18n (id, page_id, en, de, es, fr, it) VALUES("test", NULL, "this is a test string", NULL, NULL, NULL, "stringa di prova"); CREATE TABLE mytable_langs_avail ( @@ -51,6 +51,6 @@ CREATE UNIQUE INDEX mytable_langs_avail_id_index ON mytable_langs_avail (id); -INSERT INTO mytable_langs_avail (ID, name, meta, error_text, encoding) VALUES("en", "english", "my meta info", "not available", "iso-8859-1"); -INSERT INTO mytable_langs_avail (ID, name, meta, error_text, encoding) VALUES("de", "deutsch", "iso-8859-1", "kein Text auf Deutsch verfügbar", "iso-8859-1"); -INSERT INTO mytable_langs_avail (ID, name, meta, error_text, encoding) VALUES("it", "italiano", "charset=iso-8859-1", "non disponibile", "iso-8859-1"); +INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("en", "english", "my meta info", "not available", "iso-8859-1"); +INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("de", "deutsch", "iso-8859-1", "kein Text auf Deutsch verfügbar", "iso-8859-1"); +INSERT INTO mytable_langs_avail (id, name, meta, error_text, encoding) VALUES("it", "italiano", "charset=iso-8859-1", "non disponibile", "iso-8859-1");