Mercurial > dive4elements > river
diff backend/doc/schema/oracle-sinfo-uinfo.sql @ 9664:692f49b7de63
Oracle s-/u-info create script adjusted for special chars
| author | mschaefer |
|---|---|
| date | Fri, 03 Apr 2020 13:15:40 +0200 |
| parents | 9b8ba3b83a15 |
| children |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-sinfo-uinfo.sql Fri Apr 03 11:56:45 2020 +0200 +++ b/backend/doc/schema/oracle-sinfo-uinfo.sql Fri Apr 03 13:15:40 2020 +0200 @@ -437,11 +437,11 @@ INSERT INTO vegetation_type (id, name, de_name) VALUES (2, 'dry hartwood forest floodplain', 'Hartholzaue, trocken'); INSERT INTO vegetation_type (id, name, de_name) VALUES (3, 'wet hartwood forest floodplain', 'Hartholzaue, feucht'); INSERT INTO vegetation_type (id, name, de_name) VALUES (4, 'salix alba forest', 'Silberweidenwald'); -INSERT INTO vegetation_type (id, name, de_name) VALUES (5, 'salix shrubs', 'Weidengebüsch'); -INSERT INTO vegetation_type (id, name, de_name) VALUES (6, 'reed bed', 'Uferröhricht'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (5, 'salix shrubs', 'Weidengeb'||CHR(252 USING NCHAR_CS)||'sch'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (6, 'reed bed', 'Uferr'||CHR(246 USING NCHAR_CS)||'hricht'); INSERT INTO vegetation_type (id, name, de_name) VALUES (7, 'bank pioneers', 'Uferpioniere'); INSERT INTO vegetation_type (id, name, de_name) VALUES (8, 'no vegetation', 'vegetationslos'); -INSERT INTO vegetation_type (id, name, de_name) VALUES (9, 'water', 'Wasserfläche'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (9, 'water', 'Wasserfl'||CHR(228 USING NCHAR_CS)||'che'); CREATE TABLE vegetation (