firebird-net-provider

[Firebird-net-provider] Re: [Firebird-odbc-devel] Always return DBCS Length for string field ?

[Peter J. <pj...@wa...>]

Hi Shum, All, 

"Shum W.C." <sh...@mi...> wrote:
> I use BIG-5 Character set (Traditional Chinese Character)
> 
> I have the following problem after fetched fireBird through IBPhoenix ODBC
> 
> the result data (string type) always double the length:
> 
> for examples:
> 1.)  I get "Y " instead of "Y"  even the field is defined as CHR(1)
> 2.) "ABC   " instead of "ABC even the field is definec as CHR(3)

Carlos has fought against the very same problem (but surfacing for UTF-8, 
where all strings get triple length) for the .NET-provider.

Perhaps his solution (if any) can be ported to ODBC.

Regards,
Peter Jacobi

Re: [Firebird-net-provider] Re: [Firebird-odbc-devel] Always return DBCS Length for string field ?

[<car...@te...>]

Hello:

> Carlos has fought against the very same problem (but surfacing for UTF-8, 
> where all strings get triple length) for the .NET-provider.
> 
> Perhaps his solution (if any) can be ported to ODBC.

Finally i have implemented your solution in the 1.6 sources, i need to 
do more tests, but for now seems to be working.

It looks like this when reading char values:

string s = this.ReadString(
	field.Charset.Encoding,
	field.Length);

if ((field.Length % field.Charset.BytesPerCharacter) == 0 &&
	s.Length > field.CharCount)
{
	fieldValue = s.Substring(0, field.CharCount);
}
else
{
	fieldValue = s;
}


I have applied a similar one for the char parameter values (committed 
today):

string svalue = sqldata.ToString();

if ((param.Length % param.Charset.BytesPerCharacter) == 0 &&
	svalue.Length > param.CharCount)
{ 	
	throw new IscException(335544321); 	
}

						this.WriteOpaque(
	param.Charset.Encoding.GetBytes(svalue),
	param.Length);




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain