Re: [firebird-support] Re: Unicode text in Exception?

2015-01-29 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
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

Re: [firebird-support] nesting - weight calculation

2015-01-29 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
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

[firebird-support] Re: Unicode text in Exception?

2015-01-29 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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

Re: [firebird-support] Re: Unicode text in Exception?

2015-01-29 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
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

RE: [firebird-support] nesting - weight calculation

2015-01-29 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> 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

[firebird-support] Re: Unicode text in Exception?

2015-01-29 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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

[firebird-support] nesting - weight calculation

2015-01-29 Thread 'checkmail' check_m...@satron.de [firebird-support]
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