iBase.ru Forum

Код: Выделить всё

select pr.rdb$procedure_name,
pp.rdb$parameter_name,
pp.rdb$parameter_type,
pp.rdb$parameter_number,
fs.rdb$field_name,
fs.rdb$field_type,
fs.rdb$field_length,
fs.rdb$field_scale,
fs.rdb$field_sub_type,
fs.rdb$segment_length,
fs.rdb$dimensions,
cr.rdb$character_set_name,
co.rdb$collation_name,
fs.rdb$collation_id,
fs.rdb$character_set_id,
d.rdb$dimension,
d.rdb$lower_bound,
d.rdb$upper_bound,
pp.rdb$description,
fs.rdb$character_length,
fs.rdb$field_precision,
pp.rdb$parameter_mechanism,
pp.rdb$field_source,
pp.rdb$default_source
from rdb$procedures pr
left join rdb$procedure_parameters pp on pp.rdb$procedure_name = pr.rdb$procedure_name
left join rdb$fields fs on fs.rdb$field_name = pp.rdb$field_source
left join rdb$field_dimensions d on d.rdb$field_name = fs.rdb$field_name
left join rdb$character_sets cr on fs.rdb$character_set_id = cr.rdb$character_set_id
left join rdb$collations co on ((fs.rdb$collation_id = co.rdb$collation_id) and
(fs.rdb$character_set_id = co.rdb$character_set_id))
where (1=1)
order by pr.rdb$procedure_name, pp.rdb$parameter_type, pp.rdb$parameter_number

Код: Выделить всё

Cannot transliterate character between character sets.
Cannot transliterate character between character sets.