wide-charecter_aware_downcase.sql

text/x-sql

Filename: wide-charecter_aware_downcase.sql

Type: text/x-sql

Part: 1

Message: multibyte-character aware support for function "downcase_truncate_identifier()"

--- This tests if identifier with special charecters using wide-charecter aware downcase.

create schema my_SchemÄ;

--- Since we smash identifiers to lower we try to find schema name
--- by downcasing nspname.
select count(nspname) from pg_namespace where nspname=LOWER('my_SchemÄ');

drop schema my_SchemÄ;