Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-05-23 Thread Jason Wharton
Adriano, PS. Good questions Geoff! > > While on this sort of subject are you able to offer any > > information about what happens to API text such as SQL > > statements and the like) sent to the server? (And details > > like relation names etc returned to the client.) > > > They're interpreted i

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Geoff Worboys
re: >> "The isc_create_database( ) ... > There is nothing wrong with it, except a dumb last parameter. > It's de facto public. Okay. That last parameter, I was just searching the code now for hints as to what it was. I just send a 0? > You confused things. ISQL own command is "SET NAMES ...".

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Adriano dos Santos Fernandes
On 29/04/2011 09:00, Geoff Worboys wrote: > Adriano dos Santos Fernandes wrote: >> Could also be done with isc_create_database. > The IB6 API documentation notes this as: > "The isc_create_database( ) method is not currently supported > from user applications. It is for internal use only. Use > isc

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: > Could also be done with isc_create_database. The IB6 API documentation notes this as: "The isc_create_database( ) method is not currently supported from user applications. It is for internal use only. Use isc_dsql_execute_immediate( ) to create a database with

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Adriano dos Santos Fernandes
On 29/04/2011 04:11, Geoff Worboys wrote: > > As far as I can tell it is still required to use > isc_dsql_execute_immediate to perform a CREATE DATABASE (if > I've missed any relevant API change in the release notes please > forgive me, I did look). > Could also be done with isc_create_database.

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: > On 28/04/2011 08:20, Geoff Worboys wrote: >>... >> While on this sort of subject are you able to offer any >> information about what happens to API text such as SQL >> statements and the like) sent to the server? (And details >> like relation names etc returne

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Geoff Worboys
> Yes. But UNICODE_FSS is currently validated as UTF-8 but in > fact it should not allow 4-bytes characters. So doing it may > result in problems when converting from UNICODE_FSS to UTF-8 > or other character set. > It's better to never use NONE charset, specially for the > connection charset. Ag

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2011 08:57, Geoff Worboys wrote: > Adriano dos Santos Fernandes wrote: >> On 28/04/2011 08:20, Geoff Worboys wrote: >>> ... >>> While on this sort of subject are you able to offer any >>> information about what happens to API text such as SQL >>> statements and the like) sent to the server

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: > On 28/04/2011 08:20, Geoff Worboys wrote: >> ... >> While on this sort of subject are you able to offer any >> information about what happens to API text such as SQL >> statements and the like) sent to the server? (And details >> like relation names etc return

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2011 08:20, Geoff Worboys wrote: > Adriano dos Santos Fernandes wrote: > ... >> Data is transliterated from its charset to client charset and >> vice-versa. > NONE/OCTETS ->> something: data is validated accordingly to something > something ->> NONE/OCTETS: nothing is done > something1 -

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: ... > Data is transliterated from its charset to client charset and > vice-versa. NONE/OCTETS ->> something: data is validated accordingly to something something ->> NONE/OCTETS: nothing is done something1 ->> something2: data is transliterated Hi Adriano, Wh

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 27/04/2011 19:28, Support List wrote: > I am doing a new major release of IB Objects soon and I want to get > confirmation of some things before I finalize it. > > I have some scenarios that I would like to know what to do about. > There are a total of 9 possible combinations of 3 aspects. > > A