Hello Dmitry,
I'm still puzzled.
>29.01.2015 19:15, Martijn Tonies wrote:
>>
>>> 2) Create SP with EXCEPTION ERROR 'some Cyrillic string';
>>
>> Done. In the source, I see the following:
>>
>> begin
>>exception test _utf8
>> X'31D0A2D095D0A1D0A220D09DD09020D091D0AAD09BD093D090D0A0D0A1D09AD098
There is at least a good alternative, Frank Ingermann showed how to do
something very similar when calculating the amount of ingredients required when
baking a marble cake at a Firebird conference a few years ago. He used a
recursive CTE. Whether a recursive CTE is simpler than a recursive proce
29.01.2015 19:15, Martijn Tonies wrote:
>
>> 2) Create SP with EXCEPTION ERROR 'some Cyrillic string';
>
> Done. In the source, I see the following:
>
> begin
>exception test _utf8
> X'31D0A2D095D0A1D0A220D09DD09020D091D0AAD09BD093D090D0A0D0A1D09AD098';
> end
You don't need the _utf8 prefix wi
Hello Dmitry,
>>> btw, in Firebird 3, the RDB$EXCEPTIONS.RDB$MESSAGE is still NONE.
>>
>> Would it make sense to encode the message according to the given
>> connection
>> character set?
>
>Do you mean changing RDB$EXCEPTIONS.RDB$MESSAGE to UTF8? It was
>discussed but ended nowhere.
No, I meant
> there is a table with all Material (stock), each one has a number. Now, in a
> second table there is listed the material that is a part of the Material.
>
> For example:
>
> Material ABC
> Material BCD
> Material XXX
> Material OMV
> Material KOM
>
> Material OMV can be a Part of XXX and XXX
27.01.2015 14:48, Martijn Tonies wrote:
>> btw, in Firebird 3, the RDB$EXCEPTIONS.RDB$MESSAGE is still NONE.
>
> Would it make sense to encode the message according to the given connection
> character set?
Do you mean changing RDB$EXCEPTIONS.RDB$MESSAGE to UTF8? It was
discussed but ended nowher
Hello,
there is a table with all Material (stock), each one has a number. Now, in a
second table there is listed the material that is a part of the Material.
For example:
Material ABC
Material BCD
Material XXX
Material OMV
Material KOM
Material OMV can be a Part of XXX and XXX a