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 (

http://dive4elements.wald.intevation.org